Application Development 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: 

additional row after the subtotal in ALV

Former Member
0 Kudos

Hi Friends,

  I want to develop an ALV report wherein I want to have an additional row after the subtotal in ALV to show some calculation.

Please refer the below link for the report layout. In the ALV output after subtotaling the total operating revenue and total other income i would like to have an additional row to show the Total revenue(total operating revenue + total other income). Similarly after subtotaling the cost of sales, I would like to show the gross profit(total operating revenue - cost of sales) in an additional row. Please let me know whether this is possible in ALV List/Grid .

http://www.imagebanana.com/view/gpl4ynnk/report_layout.jpg

3 REPLIES 3

former_member198275
Active Contributor
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi Imran,

Your requirement will fulfill by using the it_sort type slis_t_sortinfo_alv in alv grid display.

append the field names in to it_sort internal table and use event, if you want to add the new row at end of the list with your own calculation will add at end of list by using the events. That event details has pasted in below second link.                           

Please, find the below link then you would get one idea on your requirement based on below link.

http://saptechnical.com/Tutorials/ALV/Subtotals/line.htm

http://saptechnical.com/Tutorials/ALV/Subtotals/Define.htm

I hope, the above links will give the clear idea on your requirement.

Thanks

Sekhar

marcio_medeiros
Explorer
0 Kudos

Hi Imran

I saw your file jpg with the layout, If you need to put the 2 lines after the total/subtotal, so you will do the Manual calculation of the total and hide the bottons to sort data in ALV.

To create a manual Total/Subtotal you can change the colors of the lines .

Example report standard:

BCALV_TEST_FULLSCREEN_CALLS