topic Re: accumulate amount in Application Development and Automation Discussions

accumulate amount

Former Member — Sat, 19 Jan 2008 11:22:02 GMT

hi,

i have internal table with waers, wrbtr.

i need to sort by waers and accumulate wrbtr.

for example :

from this

waers wrbtr

USD 50

USD 70

EUR 30

EUR 80

to this

waers wrbtr

USD 120

EUR 110

thanks

rgds

Former Member — Sat, 19 Jan 2008 11:24:33 GMT

To accumulate use collet

u will have one itab right..

then do like this

loop at itab into fs_itab.

collect fs_itab into itab_new.

endloop.

loop at itab_new into fs_itab.

write: / fs_itab-wears, ....

endloop.

plzz reward if it is useful.....

Former Member — Sat, 19 Jan 2008 12:08:38 GMT

Hi,

use collect statement.

it will add numeric fields if ur non numeric unique key fields get repeated...