Subtotals in ALV

[roland_spindler]

Hi,

How can I exclude lines from the subtotals in ALV? (Certain lines in the ALV are just additional information and should not be added to the subtotals.)

I'd even try to change the subtotals manually if this is possible.

thanks in advance

Roland

[Former Member]

hai Roland,

Refer this link..

Regards,

Srikanth.

[Former Member]

hi,

Look at this link

http://www.geocities.com/mpioud/Abap_programs.html

Documentation of the fields for catlog

http://www.mpls.k12.mn.us/sites/f7071225-9844-4da6-96c0-996b9c74b221/uploads/SAP_Navigation_Training...

[roland_spindler]

Hi,

I do not want to exclude columns from the subtotals, but lines!

Here is an example of what I want:

..........................value

Relevant line A...1000

Irrelevant line.....2000

Relevant line B...3000

-

---

subtotal............4000

The subtotal is 4000, because the irrelevant line is excluded.

Roland

Message was edited by: Roland Spindler

Message was edited by: Roland Spindler

[naimesh_patel]

Hello,

Data: I_SORT TYPE SLIS_T_SORTINFO_ALV,

WA_SORT TYPE SLIS_SORTINFO_ALV.

*---Sort

WA_SORT-SPOS = '1'.

WA_SORT-FIELDNAME = 'LINE'.

WA_SORT-UP = 'X'.

WA_SORT-SUBTOT = 'X'.

APPEND WA_SORT TO I_SORT.

CLEAR WA_SORT.

Pass this in FM,

IT_SORT = I_SORT

Regards,

Naimesh

[roland_spindler]

Hi,

Thanks for explaining for the third time how to make a subtotal line, but that was not my question.

best regards

Roland

[naimesh_patel]

Hello Roland,

It is not possible to exclude certain lines from ALV subtotal. Because it is applicable to all.

Regards,

Naimesh

[Former Member]

Roland,

You would need to create your own custom ALV Class Object that excludes this information.

The sub-totals on all appropriate lines is the "out-of-the-box" solution provided by SAP.

Note - to write a custom ALV solution for this would be a noticable undertaking. I would suggest that you "live with it" as is.