topic Re: alv sum in Application Development and Automation Discussions

alv sum

Former Member — Tue, 12 Dec 2006 11:02:31 GMT

hi, i am using alv grid , i wont tu have sum total numbers without clicking on sum buton after program executed.

thanks.

Re: alv sum

anversha_s — Tue, 12 Dec 2006 11:04:58 GMT

hi,

u can do it in the field catlog.

eg:

  fieldcatalog-fieldname   = 'NETPR'.
  fieldcatalog-seltext_m   = 'Net Price'.
  fieldcatalog-col_pos     = 7.
  fieldcatalog-outputlen   = 15.  
  fieldcatalog-do_sum      = 'X'        "Display column total
  fieldcatalog-datatype     = 'CURR'.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

rgds

Anver

Re: alv sum

Former Member — Tue, 12 Dec 2006 11:05:20 GMT

Hi Nick,

do this in the Fieldcatspecification:

MOVE 'X' TO WA_FIELDCAT-DO_SUM.

for the field you want to sum.

regards, Dieter

Re: alv sum

Former Member — Tue, 12 Dec 2006 11:05:59 GMT

For the columns for which you want to have the totals, you should set the field catalog parameter do_sum = 'X'. IT would automatically give the total in the last line.

REgards,

ravi

Re: alv sum

Former Member — Tue, 12 Dec 2006 11:06:00 GMT

in your field catalog add

wfieldcat-fieldname = <your field for which you want sum>

wfieldcat-do_sum = 'X'.

regrards

shiba dutta

Re: alv sum

Former Member — Tue, 12 Dec 2006 11:10:17 GMT

use this while designing the field catalog

fieldcatalog-do_sum = 'X'

Re: alv sum

Former Member — Tue, 12 Dec 2006 11:11:39 GMT

Hi Nick,

Please use the following code:

AT NEW field.

SUM.

ENDAT.