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: 

REUSE_ALV_GRID_DISPLAY / Suppressing the end sum

Former Member
0 Kudos

Dear developper community,

I'm looking for a way to exclude certain sums or "sum levels" from being displayed in an ALV-Grid generated by using the FM REUSE_ALV_GRID_DISPLAY.

We have the rare case of data of which we do need the subtotals on the first group level, but where the overall

total at the very end of the list makes no sense at all. That's why we would like the end-sum not to be shown to the user.

Thanks for any hint

Andreas

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Set the parameter "no_sum = X" in the field catalog for the particular column you want to suppress total.

Cheers

4 REPLIES 4

Former Member
0 Kudos

Set the parameter "no_sum = X" in the field catalog for the particular column you want to suppress total.

Cheers

0 Kudos

Dear Sanjay,

we already use this parameter to exclude entire colums from any summation (where it makes no sense anyway).

Here is a simplified example to illustrate what we are looking for:

grouping line description value

-


-


-


group 1 value 1 1.000

group 1 value 2 2.000

group 1 generated subtotal 3.000 <- we want this !

group 2 value 3 1.000

group 2 value 4 1.000

group 2 generated subtotal 2.000 <- we want this !

              • generated subtotal 5.000 <- not wanted!

regards

Andreas

0 Kudos

Hi andreas,

i think you need to display only subtotals but not the total then

<b>NO_TOTLINE</b> is used to display only subtotals but not totals.

click below link for more info.

http://help.sap.com/saphelp_erp2004/helpdata/en/fa/efb52cf8a611d2b48d006094192fe3/frameset.htm

reward points for help full answers and close the thread if your question is solved.

regards,

venu.

Former Member
0 Kudos

Hi,

Have a look at this sample code

*  fieldcatalog-<b>do_sum</b>      = 'X'.
 gd_layout-<b>totals_only</b>        = 'X'.

Check out this part in the code sample.

http://www.sapdevelopment.co.uk/reporting/alv/alvgrid_enhanced.htm

http://www.sapdevelopment.co.uk/reporting/alv/alvgrid.htm

Hope this helps.

Kindly reward points for the answered which helped u and close the thread.