topic Re: HOW to do subtotal in Application Development and Automation Discussions

HOW to do subtotal

Former Member — Fri, 02 Feb 2007 05:22:08 GMT

hi gurus,

i have to show the summation of credit and debit balance in the alv output....cud u plz suggest me the parameter...the scenario is like this...

employee no debitamnt credit amnt

10001 42 00

10001 190 00

10001 89 00

10001 00 -56

10001 00 -67

total total

how to show the total in alv o/p......plz help me thnx in advance

Re: HOW to do subtotal

Former Member — Fri, 02 Feb 2007 05:25:10 GMT

for totals 

in the fieldcatalog  

wa_fcat-do_sum = 'X'.

for subtotals , u have to build the sort table

it_sort-fieldname = 'CREIT'.
it_sort-up = 'X'.
it_sort-subtot = 'X'.

append it_sort.
clear it_sort.

Re: HOW to do subtotal

Former Member — Fri, 02 Feb 2007 05:26:13 GMT

go thru this url:

http://www.sap-basis-abap.com/sapalv.htm

Regards

Shiva

Re: HOW to do subtotal

Former Member — Fri, 02 Feb 2007 05:27:04 GMT

HI Ravi,

See the Below Sample code for Totals in ALV ....

http://sap.niraj.tripod.com/id64.html

Regards

Sudheer

Re: HOW to do subtotal

Former Member — Fri, 02 Feb 2007 05:38:36 GMT

in fieldcat of devit and credit

wfieldcat-do_sum = 'X'.

data : isort type slis_t_sortinfo_alv,

wsort type slis_sortinfo_alv.

wsortinfo-fieldname = 'KUNNR'.

wsortinfo-up = 'X'.

wsortinfo-subtot = 'X'.

wsortinfo-group = '*'.

append wsortinfo to isortinfo.

in alv grid or list display pass the isort.

regards

shiba dutta