Skip to Content
0
Former Member
Jun 12, 2015 at 08:00 AM

SQ01/02 Query SELECT SUM functionality

2979 Views

Hi all,

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

Attachments

Q.png (6.9 kB)