Skip to Content
Jan 13 at 12:33 PM

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



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