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

how to calculate totals in Blocked ALV Report

Hi All,

Can any body tell how to calculate totals & sub totals in

Blocked ALV Report[Blocked List].

Thanks in advance

Thanks & Regards,

Rayeezuddin.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2009 at 12:19 PM

    To show total in ALV Block:

    w_fieldcat-do_sum = 'X'.

    w_fieldcat-datatype = 'QUAN'. "or 'CURR'

    To show subtotal in ALV Block:

    wl_sort-fieldname = 'FIELD'.

    wl_sort-tabname = 'T_TABLE'.

    wl_sort-subtot = 'X'.

    In ALV block the field "datatype" in fieldcat table is necessary.

    It is wok in Hierarchical block and List block.

    Att.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2005 at 02:29 PM

    Not sure what a "Blocked List" is? But you calculate totals and subtotals either in code by using the field catalog or in a display variant.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 11, 2005 at 05:27 PM

    Hi,

    Set in the <b>fieldcatalog-do_sum = 'X'.</b>

    This will do a sum for the aprticular u want to sum.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2005 at 06:23 AM

    read this it might help

    Sums

    15. No_sumchoice(1) TYPE c : This parameter allows the choice for summing up

    Only by fieldcatalog.

    Value set: SPACE, 'X'

    'X' = fields which are to be summed, passed by the calling program (FIELDCAT-DO_SUM = 'X'). The user should not be able to change this value interactively.

    16. No_totalline(1) TYPE c : Removes the option of having totals after sub-totals.

    Value set: SPACE, 'X'

    'X' = no total record is to be output. Subtotals can still be calculated and output. The fields in the subtotals are flagged DO_SUM = 'X' in the field list.

    17. No_subchoice(1) TYPE c : Does not allow the user to interactively change the field chosen for subtotals.

    Value set: SPACE, 'X'

    'X' = value whose change triggers subtotals, provided by the calling program. The user should not be able to change this value interactively.

    18. No_subtotals(1) TYPE c : No subtotals possible

    Value set: SPACE, 'X'

    'X' = no subtotals.

    19. Numc_sum(1) TYPE c : Totals only possible for NUMC-Fields.

    20. No_unit_splitting TYPE c: No separate total lines by inh.units

    21.totals_before_items TYPE c: Display totals before the items

    22. Totals_only(1) TYPE c : Show only totals

    Value set: SPACE, 'X'

    'X' = only total records are output.

    23. Totals_text(60) TYPE c : Text for 1st col. in totals

    Value set: SPACE, string (max.60)

    ' ' = The first column in the total record contains an appropriate number of '*'s to indicate the total by default. If the first column is wide enough, the string 'Total' is output after the asterisks.

    'StringÂ’ = The string passed is output after the total indicated by '*', if the column is wide enough.

    24. Subtotals_text(60) TYPE c : Texts for subtotals

    Value set: SPACE, string (max.60)

    ' ' = In the first column of subtotal records, the subtotal is indicated by an appropriate number of '*' by default. If the first column is not a subtotal criterion, the string 'Total' is output after the asterisks, if the column is wide enough.

    'StringÂ’ = the string passed is output after the subtotal indicated by '*', if the column is wide enough and the first column is not a subtotal criterion. If it is a subtotal criterion, its value is repeated after the total, if the column is wide enough.

    ELSE TELL ME I WILL PASTE COMPLETE HELP

    regards

    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.