topic Re: Currency Issue in Application Development and Automation Discussions

Currency Issue

Former Member — Fri, 13 Apr 2012 11:13:52 GMT

Hi,

I have a JPY currency amount. I can see the correct amount in transaction level (screen) - Ex. 4,749 (Four thousand forty nine), where as same filed in table is displaying 47.49 JPY.

Can any one please let me know why the system behaves different at transaction & table levels.

Thanks,

Chandra

Re: Currency Issue

former_member16553 — Fri, 13 Apr 2012 11:17:12 GMT

Please check your decimal notation in user profile tcode su01.

Re: Currency Issue

former_member209920 — Fri, 13 Apr 2012 11:21:15 GMT

you need to use the multiplication factor with the currency so as to display it properly. Use FM CURRENCY_CONVERTING_FACTOR.

This will solve your problem. This will also appear in IDR (Indonesia Currency).

Re: Currency Issue

Former Member — Fri, 13 Apr 2012 11:26:04 GMT

Hi,

this is correct.

In DB there are always 2 digits, but when You display it and use currency value (EUR, JPY, etc.)

system checks how many digits should be in the output.

Regards,

Przemysław

Re: Currency Issue

koolspy_ultimate — Fri, 13 Apr 2012 11:28:32 GMT

In transaction level (screen) it may be using the country key 'IN' and display the amount corresponding to that country's Currency.

Can you please specify the tcode which your are using?

Re: Currency Issue

Former Member — Fri, 13 Apr 2012 11:30:16 GMT

Thanks Manu,

But, the correct amount is 4,749 JPY (which is display in transaction level - screen), but not in table level. when I'm opening tcode in display its showing 4,749 JPY but not in table(47.49) even I m changing profile settings.

Re: Currency Issue

Former Member — Fri, 13 Apr 2012 11:31:54 GMT

Thanks Madhu,

I'm uploading data to transaction. Its Insurance related (FS-CD) IBR01.

I am giving 4749 JPY to my standard program.

Re: Currency Issue

former_member209920 — Fri, 13 Apr 2012 11:34:01 GMT

Dear Chandra,

you need to multiply the amount in table with the CURRENCY_CONVERTING_FACTOR. You will get the factor from FM CURRENCY_CONVERTING_FACTOR exporting the currency code.

Re: Currency Issue

Former Member — Fri, 13 Apr 2012 11:36:20 GMT

Hi Chandra,

Internally all currency amounts are stored with 2 decimal places. So this is not at all an issue.

SAP user FM 'CURRENCY_AMOUNT_SAP_TO_DISPLAY' while displaying the currency in the output of any tocde which does the necessary conversion.

Also JPY has a multplying factor of 100 which is the reason why you find it as 47.49 instead of 4749.

Thanks,

Best regards,

Prashant

Re: Currency Issue

koolspy_ultimate — Fri, 13 Apr 2012 11:40:01 GMT

Hi can you please tell clearly what you want?

if you want to display 47.49 in output then multiply it with 100 or use the fm CURRENCY_AMOUNT_SAP_TO_DISPLAY.