getting sum in alv

[Former Member]

can we get the total sum of aparticular field in an alv

[Former Member]

Yes we can get

in the fieldcatalog for that field

wa_fieldcat-datatype = 'QUAN' or 'CURR'
wa_fieldcat-do_sum = 'X'.

[Former Member]

Hello,

In the IT_SORT parameter of REUSE_ALV_LIST_DISPLAY

fill entries for following parameter.

fieldname = plant

subtot = 'X'

append fieldname to it_sort.

fieldname = division.

subtot = 'X'

append fieldname to it_sort.

And it will by default show you subtotals.

For sum you have field "do_sum" in fieldcatalog , set it to 'X' and you should be able to do sum on that field.

Hope that helps.

Regards

Kapadia

***Assigning points is the way to say thanks in SDN.***

[Former Member]

populate the IT_SORT internal table of REUSE_ALV_GRID_DISPLAY provided in the importing parameters.

fieldname = Company Code

append fieldname to it_sort.

fieldname = division.

append fieldname to it_sort.

If you explicitly need subtotals then add the following line

subtot = 'X'

For obtaining sum you have an attribute "do_sum" in fieldcatalog , set it to 'X' and you should be able to do sum on that field.

Ensure that these should be numeric / currency or quantity datatypes only.

Hope this solves your problem

PS : Please reward points if solution is helpful