topic Re: ALV GRID DISPLAY in Application Development and Automation Discussions

ALV GRID DISPLAY

Former Member — Thu, 30 Nov 2006 22:19:08 GMT

Hello friends,

I have the output in the ALV grid display.

I need to find the total only for one field and display at the end in the same column at the bottom.

How can this be done.

Shejal.

Re: ALV GRID DISPLAY

Former Member — Thu, 30 Nov 2006 22:21:56 GMT

Hi,

Have DO_SUM = 'X' in the field catalog for the field that you want to total..

Thanks,

Naren

Re: ALV GRID DISPLAY

Former Member — Thu, 30 Nov 2006 22:22:28 GMT

In the field catalogue just make the do_sum = 'X'.

Example,

ls_fieldcat-fieldname = 'NETWR'.

ls_fieldcat-do_sum = 'X'.

Regards

Kathirvel

Re: ALV GRID DISPLAY

Former Member — Thu, 30 Nov 2006 22:24:55 GMT

u mean jsut changes here as follows.

w_fieldcat-tabname = 'it_output'.

w_fieldcat-fieldname = 'DMBTR'.

w_fieldcat-outputlen = '10'.

w_fieldcat-col_pos = '5'.

w_fieldcat-row_pos = '1'.

w_fieldcat-seltext_l = 'Value'.

APPEND w_fieldcat TO i_fieldcat.

CLEAR w_fieldcat.

Just by adding

w_fieldcat-DO_SUM = 'X' .,

before the append statement.

athanks,

Shejal.

Re: ALV GRID DISPLAY

Former Member — Thu, 30 Nov 2006 22:25:29 GMT

Thanks Naren and Karthivel.

Shejal.

Re: ALV GRID DISPLAY

Former Member — Thu, 30 Nov 2006 22:26:10 GMT

Hi,

Yes..

Thanks,

Naren

Re: ALV GRID DISPLAY

Former Member — Thu, 30 Nov 2006 22:28:06 GMT

Thanks,

Shejal.

Re: ALV GRID DISPLAY

Former Member — Thu, 30 Nov 2006 22:29:04 GMT

Hi Shejal,

This will do,

w_fieldcat-tabname = 'IT_OUTPUT'.

w_fieldcat-fieldname = 'DMBTR'.

w_fieldcat-outputlen = '10'.

w_fieldcat-col_pos = '5'.

w_fieldcat-row_pos = '1'.

w_fieldcat-seltext_l = 'Value'.

w_fieldcat-DO_SUM = 'X' .

APPEND w_fieldcat TO i_fieldcat.

CLEAR w_fieldcat.

Regards

Kathirvel