topic Re: alv report in Application Development and Automation Discussions

alv report

Former Member — Fri, 10 Oct 2008 04:57:03 GMT

Hi all,

LOOP AT itab.

append itab to i_alv.

ENDLOOP.

I am displaying alv report with subtotals based on the currency.

My question is based on the new account (saknr) how to do the subtotals.

Ex:1001 USD 10 10

1001 USD 10 20

20 30

1002 USD 10 30

USD 30 60

I need out put like this.

Re: alv report

Former Member — Fri, 10 Oct 2008 04:59:50 GMT

Are you using Object Oriented ALV approach.

Re: alv report

Former Member — Fri, 10 Oct 2008 05:00:44 GMT

no i am using normal alv

Re: alv report

Former Member — Fri, 10 Oct 2008 05:03:04 GMT

populate the sort table based on SAKNR.

sort-fieldname = 'SAKNR'.

sort-up = 'X'.

sort-subtot = 'X'.

append sort to it_sort.

pass this it_sort to it_sort of the ALV function/method

Re: alv report

Former Member — Fri, 10 Oct 2008 05:08:27 GMT

Hi vijay,

thanks for the answer.As per your answer this will give subtotal on every saknr,

I don't want like that .I want when ever more than 1 saknr will come on that time i want subtotal.

Re: alv report

Former Member — Fri, 10 Oct 2008 05:09:01 GMT

Hi ,

You can try like this...considering your final table be it_final.


  LOOP AT it_final INTO wa_final.
    count = count + 1.
    value1 = value1 + wa_final-value.
    ntgew1 = ntgew1 + wa_final-ntgew.
    diff =  diff + wa_final-diff.
    IF count = 1.
      wa_final-bztxt = wa_final-bztxt.
    ELSE.
      wa_final-bztxt = ' '.
    ENDIF.
    
    wa_final1-value = wa_final-value.
    wa_final1-ntgew = wa_final-ntgew.
    wa_final1-diff  = wa_final-diff.
   
    APPEND wa_final1 TO it_final1.
    AT END OF bztxt.
      CLEAR count.
      wa_final1-bztxt = wa_final-bztxt.
       wa_final1-value = value.
      wa_final1-ntgew = ntgew.
      wa_final1-diff = diff.

   *here the fields that you don't want to show you can use the field name = " ". *
   
      APPEND wa_final1 TO it_final1.
      CLEAR : value , ntgew ,  diff .
      
    ENDAT.
  ENDLOOP.