Skip to Content
author's profile photo Former Member
Former Member

Subtotals

Hi,

In the ALV when I click the subtotal on a column(Material Group), the subtotaling happens on the basis of material group and yellow line appears.

Also there is a facility to drilldown(expand or collapse by clicking <u><b>|</b></u> icon which appears on the extreme right on the yellow line of the subtotal). Generally a hand like icon appears when the mouse pointer is moved towards it.

In my case I don't get that hand like icon and is unable to collapse or expand. I am able to drilldown sum level from the button available on the ALV toolbar.

Please help me how I can get the drilldown sum level facility on the ALV grid by clicking the mouse.

Regards,

Amit Behera.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 02:30 PM

    Hi Amit,

    You need to Pass 'X' to the field catalog for that field

    lwa_fieldcatalog-hotspot = 'X'.

    Regards,

    Satish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 05:23 AM

    SUBTOTAL is the TOTAL at perticluar level.

    TOTAL means TOTAL of all the lines.

    LIKE:

    N1 100

    N1 200

    N2 100

    N2 500

    Subtotal

    N1 300

    N2 600

    Total

    • 900

    To get the SUBTOTAL in the ALV you need to use the SORT tables.

    In the SORT table you can find a parameter SUB_TOT. Just pass 'X' on which you want to have an subtotal. Like in the about example FLD .. pass 'X' to SUB_TOT,

    To get the TOTAL .. pass FCAT-DO_SUM = 'X' for the amount fields.

    b]How do I add subtotals

    http://www.sapfans.com/forums/viewtopic.php?t=20386

    http://www.sapfans.com/forums/viewtopic.php?t=85191

    http://www.sapfans.com/forums/viewtopic.php?t=88401

    http://www.sapfans.com/forums/viewtopic.php?t=17335

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.