RE:[sap-log-mm] Info Record Query

Posted by Sap Land Tuesday, 18 October 2011 06:17

Posted by emmanuel_leclainche (Supply Chain Analyst)
on Oct 18 at 9:18 AM

Hello,

Make a" left outer join" between EINA and EINE (right click on the join)
Then, when executing the query, select all the existing plants (easy with matchcode + CNTRL Y) and put the list in the EXCLUSION single values.
You will have all the Inforecords attributed to no plant at all (the "" ones)
You can play with exclusion lists to get what you wish.
I think the outer join was missing.

Regards,
Emmanuel

---------------Original Message---------------
From: Antonio Bruno
Sent: Monday, October 17, 2011 9:32 AM
Subject: Info Record Query

Hi,
i've created a query to show the Info records not open for a specific division.
I've joined the tables EINA and EINE and selected only the records with WERKS equal to "". But some of these info records have a records with divisions.
Is there is an alternative way to show the info records not created for a specific division?

Thanks

Antonio

__.____._