cancel
Showing results for 
Search instead for 
Did you mean: 

SQ01 LIKP/LIPS Query. Only want to show line if reference document number in LIPS has changed

former_member838435
Discoverer
0 Kudos

Hi,

I am working on a SQ01 query to show delivery header data along with the associated reference number (sales doc).

I am getting this information from LIKP and LIPS, however due to the LIPS being joined it gives a line for each item in the delivery, where as the requirement is a line per delivery and reference number. Is there anyway of controlling this in SQ01 query creation?

Many thanks

View Entire Topic
od_manikandan
Active Contributor
0 Kudos

Hai,

Try T Code - SQVI

DO is reference to SO Line items

Try Connecting LIKP - VBFA -vbeln.

Or use abap to select single.

Regards,

OD