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

[Former Member]

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.

[raymond_giuseppi]

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