topic Re: JPY currency issue in Application Development and Automation Discussions

JPY currency issue

former_member392636 — Thu, 03 May 2018 08:24:56 GMT

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

Re: JPY currency issue

RaymondGiuseppi — Thu, 03 May 2018 08:48:43 GMT

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)

Re: JPY currency issue

former_member392636 — Thu, 03 May 2018 09:12:13 GMT

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