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

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

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Popular White Papers

In the Spotlight
Have you explored the Toolbox.com Marketplace? Learn more and access a free course now.

_.____.__

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

Post a comment