topic Re: summing in Application Development and Automation Discussions

summing

Former Member — Tue, 04 Mar 2008 12:20:53 GMT

how to add different amounts for a same account id ?

ex: accid- 1000 amt - 100

accid- 1000 amt - 1000

accid- 1000 amt - 200

accid- 1000 amt - 10000

accid- 1000 amt - 300

Re: summing

former_member182354 — Tue, 04 Mar 2008 12:23:40 GMT

Hi,

Use collect statement.

Collect itab.

Regards,

Raghav

Re: summing

dhruv_shah3 — Tue, 04 Mar 2008 12:24:42 GMT

Hi,

Use the Collect Statement inside the Loop..Endloop.

you have to use this collect statement on work area of the internal table.

HTH.

Regards,

Dhruv Shah

Re: summing

Former Member — Tue, 04 Mar 2008 12:25:02 GMT

Use loop for the account id table

Loop at accidtable.

amount = amount + accountid-amount.

Endloop.

Thanks,

Sunil

Re: summing

Former Member — Tue, 04 Mar 2008 12:25:24 GMT

Hi,

let us assume accid and amt fields are in an internal table say itab

now

loop at itab.
at end of accid.
sum.
write : / itab-accid,itab-amt.
endat.
endloop.

Cheers,

jose.

Re: summing

Former Member — Tue, 04 Mar 2008 12:30:18 GMT

hi ,

Use following code,

sort itab by accid.

Loop at itab,

itab1-amount = itab1-amount + itab-amount.

at end of accid.

itab1-accid = itab-acccid.

append itab1.

clear itab1.

endat.

endloop.

Regards,

Talwinder

Re: summing

Former Member — Tue, 04 Mar 2008 12:36:45 GMT

Hi,

You can use collect statement.


"Declare a work area and another internal table same as internal table.

loop at itab into wa.
collect wa into itab1.
endloop.

Thanks,

Sriram Ponna.