Currency Issue

[Former Member]

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

[former_member16553]

Hi

     Please check your decimal notation in user profile tcode su01.

[former_member209920]

Hi

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).

[Former Member]

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.

[former_member209920]

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.

[Former Member]

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

[koolspy_ultimate]

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?

[Former Member]

Thanks Madhu,

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

I am giving 4749 JPY to my standard program.

[koolspy_ultimate]

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.

[Former Member]

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