on 09-11-2017 6:46 PM
Hello,
I am trying to get a SQv1 query with the link bekiw
VEKP-VENUM inner join VEPO-VENUM
VEPO-VBELN left outer join LIPS-VBELN
VEPO-POSNR left outer join LIPS-POSNE
LIPS-VBELN inner join LIKP-VBELN
I am aiming to see all the deliveries document created within a defined period, and where there are, the packing handling unit. If there are no packing unit, i still want to see the delivery.
I am doing this above but I can only the Delivery that are linked to a packing unit.
any advices?
thanks
There must only be one table right of the out join, no further joins at this side
see the docu https://help.sap.com/saphelp_nw74/helpdata/en/4a/3ac30634b33f04e10000000a421937/frameset.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Addendum: as Jelena said, the following answer is valid for an infoset, so is valid for a classic query (SQ01), not for a local query (SQVI).
For complex SELECT, you may use an external or integrated reading program : SAP Library: Using Programs to Retrieve Data
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
But this is only available for the infosets (SQ02), no?
OP is trying to do SQVI. I suppose SQVI can be created using an infoset but then someone would need to create the infoset first.
AFAIK you can't do an inner join (VEKP in this case) to a table that is left join'ed (VEPO). You can try LEFT -> LEFT but I'm not sure SQVI will like it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.