Currency decimal format

[Former Member]

Hi,

I wanted to know if there is any table which stores the currency format for decimal places. for e.g some currencies use a period to indicate the decimal place while some use a comma.

if the amount is 127.54

in USD it will be 127.54

in FRF it will be 127,54

Is there any table which stores this information as to which currencies use comma and which use period.

Thanks,

Prasy

[Former Member]

Hi,

I wanted to know if there is any table which stores the currency format for decimal places. for e.g some currencies use a period to indicate the decimal place while some use a comma.

if the amount is 127.54

in USD it will be 127.54

in FRF it will be 127,54

Is there any table which stores this information as to which currencies use comma and which use period.

Thanks,

Prasy

[former_member156446]

Hi

table TCURX

[Former Member]

>

> Hi
> table TCURX

TCURX stores the number of decimal places, not the decimal format.

Perhaps you're thinking of the question asked yesterday

Rob

[Former Member]

Hi,

I was able to find the number of decimal places for each currency in the table TCURX...but in case a particular currency's data is not stored in this table3, is there any other alternate table that i could look at?

Thanks,

Prasy

[former_member156446]

In table GLPCT you will find a field RTCUR that is uses as reference

field for all CURR fields in transaction currency, and t001-waers for

all CURR fields in company currency[.|http://sap.ittoolbox.com/groups/technical-functional/sap-dev/wrong-currency-format-1491682#]

[more help|http://help.sap.com/saphelp_scm50/helpdata/en/9f/dba1ef35c111d1829f0000e829fbfe/frameset.htm]

[Former Member]

I think the decimal format is controlled by the user setting not the currency being output. For example:

REPORT ztest LINE-SIZE 80 MESSAGE-ID 00.
DATA: amt TYPE bseg-dmbtr VALUE '123.45'.
WRITE: /001 amt CURRENCY 'FRF'.

gives output for me as:

123.45

Rob

[former_member192897]

Check in User Master SU3 / SU01 & Global Settings OY01

[Former Member]

Hi,

Go to transaction OY01.

select the country and in that u change the decimal pt format.

regards

siva

[Former Member]

Hi,

I think this link solves your problem. http://help.sap.com/saphelp_scm50/helpdata/en/9f/dba1ef35c111d1829f0000e829fbfe/frameset.htm

(look for Special Output Formats in sap help).

Kind regards,

Florin

[Former Member]

Hi,

Pass curreny value in to write...Currency then will get correct out put format.

Regards

Md.MahaboobKhan