topic Re: Currency decimal format in Application Development and Automation Discussions

Currency decimal format

Former Member — Fri, 07 Nov 2008 21:02:25 GMT

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

Re: Currency decimal format

former_member156446 — Fri, 07 Nov 2008 21:03:08 GMT

table TCURX

Re: Currency decimal format

Former Member — Fri, 07 Nov 2008 21:07:01 GMT


> Hi
> table TCURX

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

Perhaps you're thinking of the question asked yesterday

Rob

Re: Currency decimal format

former_member156446 — Fri, 07 Nov 2008 21:15:58 GMT

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]

Re: Currency decimal format

Former Member — Fri, 07 Nov 2008 22:14:36 GMT

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

Re: Currency decimal format

former_member192897 — Sat, 08 Nov 2008 04:34:24 GMT

Check in User Master SU3 / SU01 & Global Settings OY01

Re: Currency decimal format

Former Member — Sat, 08 Nov 2008 09:43:50 GMT

Hi,

Go to transaction OY01.

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

regards

siva

Re: Currency decimal format

Former Member — Sat, 08 Nov 2008 10:14:30 GMT

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

Re: Currency decimal format

Former Member — Wed, 11 Feb 2009 11:07:32 GMT

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

Re: Currency decimal format

Former Member — Wed, 11 Feb 2009 11:34:13 GMT

Hi,

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

Regards

Md.MahaboobKhan