Skip to Content
avatar image
Former Member

Grandtotal by currencies in ALV

hi experts,

i want to get grandtotal by all currency display in last record in ALV... how do i do like that?

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 18, 2008 at 03:38 AM

    Hi

    Check the program in below thread.

    http://www.saptechnical.com/Tutorials/ALV/Total/text.htm

    Thanks,

    Dasari

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2008 at 03:28 AM

    Need to do 2 steps.

    1. Specify do_sum = 'X' in the fieldcatalog of the currency field

    2. Populate the sort table based on currency key

    sort-fieldname = 'WAERS'.

    sort-up = 'X'.

    sort-subtot = 'X'.

    append sort to it_sort.

    use this it_sort in the Function/Method call

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      let say i have 3 currency in my int table.

      so

      grand total INR 100.00

      USD 290.00

      SGD 123.00

      i want my grand total display like that...how?