topic Re: display sum using alv grid control in Application Development and Automation Discussions

display sum using alv grid control

Former Member — Wed, 26 May 2010 13:11:24 GMT

hi,

am using cl_gui_alv_grid for displaying.

i tried by selecting all fields for sample and i got it.

but when i tried to have limited fields for this i used fieldcat of type lvc_t_fcat am not getting and also i tried to have total on one field.

am not getting total and limited fields output.

the report is displaying all the fields but the content will be only for the fields i selected in fcat.

i need only some fields and have total on one field.

please help...

Re: display sum using alv grid control

Former Member — Wed, 26 May 2010 13:17:01 GMT

You can use Layout Variants to hide some columns of the ALV.

Check method: SET_TABLE_FOR_FIRST_DISPLAY

Following parameters:

IS_VARIANT

I_SAVE

I_DEFAULT

Re: display sum using alv grid control

Former Member — Wed, 26 May 2010 13:23:17 GMT

Hi Mr X,

you can hide column from output and sum on particular column

NO_OUT = X in fcat for column which is not needed in output

do_sum = X in fcat for sum

Regards,

Gaurav

Re: display sum using alv grid control

former_member233090 — Wed, 26 May 2010 13:34:25 GMT

Hi,

if you want the subtotals you have to do

that is you need to mention the do_sum = 'X'. for the columns which you want to see the subtotals(quantities, currency etcc) in the fieldcatalog.

cheers,

Bhavana

Re: display sum using alv grid control

former_member233090 — Wed, 26 May 2010 13:38:33 GMT

This message was moderated.

Re: display sum using alv grid control

Former Member — Wed, 26 May 2010 14:43:09 GMT

hi,

i have used that method only.

in that i set

exporting

i_structure_name = 'mara'

changing

it_outtab = it_mara

it_fieldcatalog = fcat.

i need sum mainly, only 4 fields to be displayed.

please help....

Re: display sum using alv grid control

Former Member — Wed, 26 May 2010 15:20:15 GMT

Hi,

Can you explain more clearly?

Best regards,,

Leandro Mengue

Re: display sum using alv grid control

former_member233090 — Thu, 27 May 2010 06:35:52 GMT

yes,

to get sum up use this

do_sum = 'X' as i have given in the above example

cheers,

Bhavana