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

Posted by Sap Land Friday, 9 September 2011 00:53

Posted by DjeCepap
on Sep 9 at 3:57 AM

Hi Dave ;

I did some testing and I realized that to a criterion of selection, in the query, on a table with a left outer join causes this error.

For example I wanted to filter material document which do not concern the management of stocks (blank movement Code). I found a solution which is to add the following statements in the INFOSET:
IF EKBE-EBELN IS NOT INITIAL.
CHECK NOT EKBE-BWART IS INITIAL.
ENDIF.

Now I have the data. Good, I have yet to resolve the fact that data from EKPO repeated when there are several receptions by position.

B.R.

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

__.____._