to collect the total amount s of related same field

[Former Member]

hi Guru's,

i had a requriment that to collect the totals of similar customers accounts and

profit center.

let me explain in detail i had a requriment that in an internal table i have account number, customer, profit centre and amounts in this case i have to sum all the amounts of similar account customer and profit centre and pass it to an internal table.

please help me i am struck in this i have used at end of but it does n't meet my requriment.

thanks in advance

[Former Member]

Hi,

At end of will work in this case. Did u use two fields in at end of statement?

at end of field1 field2.

sum as per req..

endat.

regards,

Subbu

[Former Member]

hi subba

if i take at end of it will it triggers only if one field is triggered i am trying to do do that i should add amount of same profitcenter and same customer and same g/l account so how can i do that please please .

thanks in advance

[Former Member]

Hey,

Try <b> Collect itab. </b>

This causes summation of numeric fields for similar key combination.

Regards

Nishant

[Former Member]

before using collect i sorted the internal by respected fields and after that i collected i worked fine thank you .