Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
DjeCepap -
Did you need to go right to MKPF/MSEG for some reason? Could you get what you need by using EKBE instead? Or, have you investigated the logical databases that include EKKO?
Dave
| | | ---------------Original Message---------------
From: A D
Sent: Wednesday, September 07, 2011 4:51 AM
Subject: InfoSet with left outer join and query
Hi friends
I created an INFOSET of type join with EKKO, EKPO, EKET, MSEG and MKPF tables. And I added an left outer join between EKPO and MSEG as follows EKPO-EBELN = > MSEG-EBELN and EKPO-EBELP = > MSEG-EBELP.
The goal is to produce a query with purchase orders and their receipt s(if exist). However, when I run the query, the results obtained only contains purchase orders that have receipts. Purchase orders with no receptions are not on the result.
How can I get all with or without receipt purchase orders?
Thanks in advance. |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Dave Thornburgh
SAP Logistics Material Management Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement Popular White Papers
In the Spotlight SAP BusinessObjects: Dashboards and Analytics. Learn more about this Toobox.com Marketplace online course.  _.____.__ |
