topic Re: summing in Application Development and Automation Discussions

summing

Former Member — Sat, 11 Apr 2009 07:19:00 GMT

hi friends,

my requirement is to capture carrid and sum seatsmax field and display at once.

for ex : 'LH' lufthansa we have a big list.

i need to capture carrid and sum seatsmax and display at once ...like wise all carrid with out any duplicates.

result should be LH 5500.

AA 6600.

thanks&regards

deepika.

Former Member — Sat, 11 Apr 2009 07:23:59 GMT

HI ,

use DELETE ADJACENT DUPLICATES FROM for deleting the repeated entries in the internal table .

regards

chinnaiya

Former Member — Sat, 11 Apr 2009 07:30:48 GMT

Use DELETE ADJACENT DUPLICATES FROM ITAB COMPARUNG FIELD.

AND write---- AT LAST.

SUM.

END AT.

OR use collect statement.

Former Member — Sat, 11 Apr 2009 08:41:09 GMT

yes thanks for your reply.

i have done by using loop statements but im not getting required output.

thanks&regards

deepika.

Former Member — Sat, 11 Apr 2009 08:45:34 GMT

Hi,

Don't use the DELETE DUPLICATE Statment.

SORT ITAB BY CARRID.
LOOP AT ITAB.

L_SEAT = L_SEAT + itab-seatsmax.

AT END OF CARRID.
 WRITE:/ ITAB-CARRID, L_SEAT.
 CLEAR L_SEAT.
ENDAT.

ENDLOOP.

Former Member — Sat, 11 Apr 2009 08:49:19 GMT

you can use collect if yu are in a loop

Regards,

Lalit Mohan gupta.

Former Member — Sat, 11 Apr 2009 08:52:03 GMT

thank you very much.

thanks&regards

deepika.