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

Accepted Solutions (0)

Answers (2)

Answers (2)

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

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Share your query result here to check and advise. Have you tried with left outer join instead of inner join?

Regards,

Nagarajan