I want to make sure if the following is possible using SQ01 query with additional coding:
The case is like this; for one sales order, there are four deliveries.
I want to report the total delivered quantity, versus the order quantity.
When I join the tables using VBELN = VGBEL, POSNR = VGPOS, I get four rows in the report output, as there are four lines in the LIPS table.
I want to list one single line for the sales order, and in this line I want to list the total quantity of 180.
How can I achieve this?
I believe using the coding options in the SQ02 data source, but I'm going to need clear examples for how.
Thanks in advance