ALV OUTPUT Display issue
ALV Output Display Issue..
I have an internal table, where the values are correctly populated as below,
in field catalog table also the values are same as displayed above.
But in ALV display,
For the Currency 'KRW' the NETPR value displayed is different.
I.e. in table = 1200.00
in ALV = 120,000.
is it due to the difference in data type of NETPR..in table it is p(6) dec(2), whereas in fieldcat table it is c(30).
Please help me out.
This is clearly due to number of decimal in a particular currency, KRW in this scenario.
KRW(Korean Won) do not have any decimal point and hence have 1 as a minimum unit.
SAP, when storing data in Database or internal tables, uses same field for all currencies and hence stores 120000 KRW as 1200.00 and 1200.00 EUR as 1200.00
That is why, when displaying amount on screen, corresponding Currency field is important.
In this scenario, as rightly mentioned in another response, you can use SAP Std FM CURRENCY_AMOUNT_SAP_TO_DISPLAY to convert it to correct format.
You can check that this FM converts 1200.00 EUR to 1200.00 EUR, but 1200.00 KRW to 1200000 as explained above.
Hope this helps.