Summing the delivery quantity in Dialog Programming

[Former Member]

Hello ppl,

I've to sum the delivery quantity for all the deliveries in the group from table LIPS.(LFIMG). How should I do it in Screen Programming. In the PAI, I receive the deliveries for the group(VBSS-VBELN). In other words, how to manipulate the records when i use only the TABLES statement.

Thanks.

Karthikeyan

[Former Member]

Hello ppl,

I've to sum the delivery quantity for all the deliveries in the group from table LIPS.(LFIMG). How should I do it in Screen Programming. In the PAI, I receive the deliveries for the group(VBSS-VBELN). In other words, how to manipulate the records when i use only the TABLES statement.

Thanks.

Karthikeyan

[Former Member]

Hi

U need to select the quantity from lips, u can use the SELECT stament with option SUM:

SELECT SUM(LFIMG) INTO V_QTA FROM LIPS WHERE VBELN IN .........

Max

[Former Member]

Thanks a lot Max. Appreciate it.