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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi rubbergrover,
This was exactly what I needed however:
NULL was not recognised;
changed line 9 into dc02 = '02'
thanks,
Marcel
This was exactly what I needed however:
NULL was not recognised;
changed line 9 into dc02 = '02'
thanks,
Marcel
https://www.sdn.sap.com/content_documents/Portal%20Data%20Viewer%20Presentation.ppt.
http://help.sap.com/bestpractices/industry/retail/v1470/Documentation/EN/Partneroriented%20Masterdata_EN_DOCU_V147.doc.
best of luck..
R.K