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

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

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.


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

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?



Copyright © 2011 and message author. 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
Popular White Papers

In the Spotlight
Have an SAP Question? Ask Your Peers at Toolbox for IT


0 Response to "RE:[sap-log-mm] Info Record Query"

Post a Comment