Skip to Content

JPY currency issue

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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 03, 2018 at 08:48 AM

    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)
    Add comment
    10|10000 characters needed characters exceeded