Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

ALV

Former Member
0 Likes
545

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
503

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

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

3 REPLIES 3
Read only

Former Member
0 Likes
504

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

Read only

Former Member
0 Likes
503

Hi,

give

ls_fieldcatalog-do_sum = 'X'.

for the fields u need..

Regards,

JMB

Read only

Former Member
0 Likes
503

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...