Skip to Content
-3

JPY currency issue

May 03 at 08:24 AM

31

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Raymond Giuseppi May 03 at 08:48 AM
0

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)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0