2008 Jan 19 11:22 AM
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
2008 Jan 19 12:08 PM
Hi,
use collect statement.
it will add numeric fields if ur non numeric unique key fields get repeated...
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
2008 Jan 19 11:24 AM
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.....
2008 Jan 19 12:08 PM
Hi,
use collect statement.
it will add numeric fields if ur non numeric unique key fields get repeated...
| User | Count |
|---|---|
| 6 | |
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |