topic Re: ALV in Application Development and Automation Discussions

ALV

Former Member — Mon, 07 Apr 2008 11:29:25 GMT

i have following columns

item code apr may jun

101 100 200 300

102 200 100 100

103 300 400 500

i want total of three fileds like below

item code apr may jun

101 100 200 300

102 200 100 100

103 300 400 500

______________

600 700 900

i have written following code to display data

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'ITEM_CODE'.

ls_fieldcat-tabname = 'IT_OUTPUT'.

ls_fieldcat-seltext_m = 'Item Code'.

APPEND ls_fieldcat TO p_alv_fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'TSL01'.

ls_fieldcat-tabname = 'IT_OUTPUT'.

ls_fieldcat-seltext_m = 'Apr'.

APPEND ls_fieldcat TO p_alv_fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'TSL02'.

ls_fieldcat-tabname = 'IT_OUTPUT'.

ls_fieldcat-seltext_m = 'MAY'.

APPEND ls_fieldcat TO p_alv_fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'TSL03'.

ls_fieldcat-tabname = 'IT_OUTPUT'.

ls_fieldcat-seltext_m = 'JUN'.

APPEND ls_fieldcat TO p_alv_fieldcat.

what additional code i have to write to display totals of each column as mentioned above

Kindly guide me on the same

Re: ALV

Former Member — Mon, 07 Apr 2008 11:31:58 GMT

Hello,

Make this change:

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'TSL03'.

ls_fieldcat-tabname = 'IT_OUTPUT'.

ls_fieldcat-seltext_m = 'JUN'.

ls_fieldcat-do_sum = 'X'.

APPEND ls_fieldcat TO p_alv_fieldcat.

Cheers,

Vasanth

Re: ALV

Former Member — Mon, 07 Apr 2008 11:32:05 GMT

Hi,

give

ls_fieldcatalog-do_sum = 'X'.

for the fields u need..

Regards,

JMB

Re: ALV

Former Member — Wed, 09 Apr 2008 03:43:43 GMT

Hi Friend,

we have control break events...like

AT NEW <FIELD>.

ENDAT.

ON CHANGE OF <FIELD>

ENDON.

U CAN USE THESE EVENTS.. then ur problem is solved...