RE:[sap-log-mm] InfoSet with left outer join and query

Posted by Sap Land Wednesday 7 September 2011 23:39

Posted by DjeCepap
on Sep 8 at 2:46 AM

Hi Dave;

Thanks for you reply.

Yes, you are right. I have not thought about the table EKBE. I modified the INFOSET by removing the MSEG and MKPF tables. I added EKBE by transforming the join in left outer join. And so the works.

Thanks for your help, but I test to find the answer to the question why the left outer join with MSEG does not work?
Have you an idea?

---------------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.

__.____._