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

Posted by Sap Land Tuesday, 18 October 2011 07:58

Posted by tonybruno99
on Oct 18 at 11:00 AM

Hi,

I can't use A017(plant-specific) and A018 in the query.

I've already used the left outer join and the exclusion, but the problem is related that I've for one inforecord to records one with and one without the plant. So I don't understand when there is a inforecord without plant.

Thanks

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

__.____._