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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

in ALV report is possible to display the subtotals in separate column

Go to solution
Yasin
Active Participant

‎2010 Mar 30 9:32 PM

0 Kudos
120

Hi,

I have made one ALV report, i need to show the subtotals of ekpo-brtwr (Gross Value) grouped by or sorted by

ekko-ebeln (Purshasing Doc) but in separate column not at the end of the line items of each purshasing doc

any idea how can i do this?

let us say i have the following cols in my report:

ekko-bukrs

ekko-ebeln,

ekko-aedat,

kko-lifnr,

ekpo-brtwr

i want to add one more col for example (T-Gross) and to fill it with the suptotals of (ekpo-brtwr) sorted by the

ekko-ebeln (Purshasing Doc).

thanks a lot.

1 ACCEPTED SOLUTION

Go to solution
former_member226234
Contributor

‎2010 Mar 30 9:56 PM

0 Kudos
83

AT END of ebeln, populate the new column with the accumulated value of the gross field.

2 REPLIES 2

Go to solution
former_member226234
Contributor

‎2010 Mar 30 9:56 PM

0 Kudos
84

AT END of ebeln, populate the new column with the accumulated value of the gross field.

Go to solution
Former Member

‎2010 Mar 30 10:20 PM

0 Kudos
83

If you need one more column, then you need to expand the field catalog table and data table as you did for all other fields and you need to code the logic to calculate the subtotals and populate the new column, but if you want to have row, that will be easy. For more info you can [refer |http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/4063c42a-2549-2c10-fab6-a8c99d98b9b5?quicklink=index&overridelayout=true]this: