Skip to Content
avatar image
Former Member

how to display Various currency categories in same column in ALV grid?

hi..

i wanted to display currency field in a column which has the currency value of different currency categories like US dollar, EURO, Indian Rupees. The thing is,

1. for US dollar it should contain ONLY last 2 decimal pts.

2. for Euro, it should hav contain last 3 decimal pts.

3. For Indian, it should hav contain last 2 decimal pts.

how to achieve this in one column and how to declare it, because it all in same field.

This report is in ALV GRID.

and important is , i also wanted to do the SUM for the total amount which has combinations of all above specified currencies.

how to achieve it.

any answer will be rewarded.?

reply soon.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 29, 2008 at 08:30 AM

    You need two columns amount and currency code in your internal table, the fields must be of type CURR and CUKY, and the field catalog must link the amount and the currency code. (CFIELDNAME of the amount column contains the name of the currency code column)

    The amount will be displayed according to the currency code definition in customizing, and will be summed by currency code.

    Regards

    Add comment
    10|10000 characters needed characters exceeded