topic Re: Problem With Currency Conversion in Application Development and Automation Discussions

Problem With Currency Conversion

Former Member — Fri, 16 Mar 2007 12:40:22 GMT

Hi All,

I am printing currency values in a SAP Script, for INR, GBP, dollar or any other currency it is giving the values correctly but for the currenvy EURO , it is replacing the comma with the dot and dot with comma For ex for 45,66.88 its showing 45.66,88.

Please suggest what can be the problem.

Thanks

Re: Problem With Currency Conversion

Former Member — Fri, 16 Mar 2007 12:43:27 GMT

Hi,

Currency values are different from country to country.

In some countries, comma become full stop. it's not a problem.

You can change the user settings in SU01 t code.

or you can write SET COUNTRY ..<name> in script to print that country specific settings for currencies.

Regards,

Anji

Re: Problem With Currency Conversion

Former Member — Fri, 16 Mar 2007 17:20:34 GMT

Country-Dependent Formatting: SET COUNTRY The formatting for certain field types depends on the country settings. These field types include, for example, date fields and number fields that include either a decimal point or the ‘thousands’ separator character. The formatting options defined in the user master record are usually the ones used here. To choose a formatting option other than the one specified in the user master record, use the SET COUNTRY control command. <b>The country-dependent formatting options are stored in the T005X table.</b>

Syntax: /: SET COUNTRY country_key You can enter the country key either as a literal value enclosed in quotes or as a symbol.

when this is behaving okay for all the currencies and only Euro is giving u the problem

Euro currency key is missing somewhere in the tables/spro settings to support the same .

In this case ..

So Euro cannot be classified as a country .Normally we can use this to do the thousands or the decimals separator .

alternative is pick the currency Key from table TCURC for Euro and

apply the condition

If waers = 'EUR'.

( logic to make the currency behave as required like replace ',' with '.' etc stuff ).

endif.

This might suffice as an<b> intermediate solution</b> but i suppose complete solution will be from a standard customize setting .

For the final solution

set the EURO currency setting in SPRO .

Regards,

vijay.

Re: Problem With Currency Conversion

Former Member — Sat, 17 Mar 2007 03:56:21 GMT

Hi Sniper,Thanks for ur reply,

I tried to find out the currency settings in the SPRO transaction but unable to find it,

Can u please tell me where to go to(In transaction SPRO which subtree) set the currency settings.

Thanks.

Re: Problem With Currency Conversion

Former Member — Sat, 17 Mar 2007 08:47:33 GMT

SPRO~~->sap rEf img~~> general settings --->sub node currencies (entry here)

---> set decimal places for currencies.

(entry here)

Regards,

Vijay