JPY currency issue

[former_member392636]

Hello Experts- 1. Japan currency does not have decimal. When we look into a Japan invoice the net value (i.e. vbrk-netwr) is coming 78.718, but through above custom report net value is coming 787,18

2. I can not use write statement with currency, because I will not able to append in lt_final table.

3. If I changes final table field type vbrk-netwr to like 'C', it will not help out at time of sorting and summing

So is there any possiblity, function module, feature of salv table that will solve the issue. System should automatically determine the amount corresponding to curreny, like system does at the time of invoice amount display.

I explored so many forum but could not get fix for this issue.

Regards,

Himansu

[raymond_giuseppi]

Could you try to

• Do not change the value read from database (remove the x 100 for currencies without decimals or the / 10 for currencies with 3 decimals..)
• Insure field catalog (hidden behind SALV) link correctly currency amount and currency code (CL_SALV_TABLE->GET_COLUMNS, CL_SALV_COLUMNS_TABLE->GET_COLUMN, CL_SALV_COLUMN->SET_CURRENCY_COLUMN)

[former_member392636]

Bingo!! Thanks Raymond for giving me permanent fix. I followed your approach and worked now. 🙂