Link to home
Start Free TrialLog in
Avatar of mleenen
mleenen

asked on

use query/infoset as input for new query/infoset

Hi,

I want to build an query in SAP (SQ0x) to identify all materials created in distribution channel 01 but not in distribution channel 02. The master data can be aquired from transparent table MVKE which contains material, sales organisation and distribution channel (DC); the three key's to check for. In the end I expect a query with an output like this:

Material  Sales Org  DC1 DC2
abcdefg  NL01         01   02   --> exists in both dc's
abcdefg  NL10         01   NULL --> only exists in dc01
etc...

Is this possible?

I have tried to make an alias of MVKE but creating a left outer join is not going to work (of course). I guess I have to build to new queries/infosets (one only containing DC01 and the other one only DC02) and use these for a left outer joint. Not sure if this is possible!!!

Thanks,
Marcel
Avatar of rama_krishna580
rama_krishna580
Flag of United States of America image

ASKER CERTIFIED SOLUTION
Avatar of rubbergrover
rubbergrover

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mleenen
mleenen

ASKER

Hi rubbergrover,

This was exactly what I needed however:
NULL was not recognised;
changed line 9 into dc02 = '02'

thanks,
Marcel