how we add & grandtotal of sales order report in alv

[Former Member]

hi guru how we add & grandtotal of sales order report in alv

regards

subhasis

[Former Member]

hi subhasis,

since u want the grand total in ALV use the following code...

clear gs_fieldcat.

gs_fieldcat-fieldname = field.

gs_fieldcat-tabname = DB table

gs_fieldcat-seltext_m = text.

gs_fieldcat-do_sum = 'X'

gs_fieldcat-datatype = data type (Curr or Quant)

gs_fieldcat-ref_fieldname = reference field name

gs_fieldcat-ref_tabname = reference table name

append gs_fieldcat to gt_fieldcat.

hope this will work...

please reward points in case usefull

regards,

prashant

[arul_murugan]

hi,

in the alv fm there is one field it_fieldcatelog = mfc

for displaying,

CLEAR mfc.

mfc-fieldname = 'TOTAL'.

mfc-tabname = 'T_FINAL'.

mfc-seltext_l = 'Net Total'.

mfc-outputlen = '15'.

mfc-just = 'R'.

mfc-do_sum = 'X'.

APPEND mfc.

we use field catelog for the displaying the fields in the alv

in that there is one option called do_sum

[Former Member]

Hi,

While building fieldcatlog . Activate this field for the Field in table to get the sum n grandtotal.

l_line_fieldcat-do_sum = 'X'.

Regards,

Priyanka.