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