SUM Grouping

[Former Member]

Hi,

I have an internal table with fields to be summed up. I require that the sum be grouped by field taxcode first then by field matnr. And then at the end of the report, sum everything.

Any ideas on how to do this?

Thanks in advance.

Kenny

[Former Member]

use control break events....

like

at end of <taxcode>

sum.

endat.

at end of <matnr>

sum.

endat.

at last.

sum.

endat.

at each above stage the value will get summed.

regds,

kiran

[Former Member]

Hi Kiran,

I have tried AT THE END OF, ON CHANGE, and AT NEW but I cant seem to make it work.

Please help.

Kenny

[Former Member]

how are the values stored kenny?

regds,

kiran

[Former Member]

Hi Kiran,

Both matnr and taxcode are fields of an internal table. I have a loop into a workarea for sum to work.

Thanks.

Kenny

[Former Member]

what i mean to say is.

the control break events depends upon the order of the fields declare in the internal table.

can u please give the fields in the order of the internal table.

regds,

kiran

[athavanraja]

declare the itab in such a way that the first field is tax code and next field is matnr.

then sort itab by taxcode matnr.

loop at itab.

move: itab to wa .

at end of taxcode.

SUM.

endat .

write:/ wa , itab-amount fields.

at end of matnr.

SUM

endat.

write:/ wa, itab-amount fields.

endloop.

Raja

[Former Member]

Thanks to both of you.

Raja, that does the trick. Didnt realize the order of the fields.

Its working now. Thanks to both of you again.

Regards,

Kenny