cancel
Showing results for 
Search instead for 
Did you mean: 

Decimal change in currencies

former_member794604
Participant
0 Kudos

Hi,

We have an issue related to our SAP Production system.

At the time of raising Billing invoices to customers in USD currency,

we are using currency SAR with two decimal places currently. Now our requirement is to bring three decimal places to USD currency for another project. new project also in the same lanscape .To proceed further i need to achieve this change in existing settings and test the impacts. so it is a cross client change (oy04)it will be seriously effected to our production system. Whether it will be suggested for changing the TCURX table? as these change is a urgent requirement for our new IS Oil

project, as in the SAP note : 434349 and 137626 it is clearly mentioned that it will affect the already posted documents , I need to know what are the other impacts and is there any other way to do the same.

Regards

Sanj

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi sanj,

Check the table TCURX.Based on user profile you can get the currency format from USR01.Use This Code: It takes care of decimal notation based on user profile.What ever may be the user profile for decimal notation.

Expl:

FIELD_NUM = 1,233.50 And You can maintain this table via the R/3 Implementation Guide (Global Settings -> Currencies, Transaction OY04). If a currency is not defined in Table TCURX (decimal places for currency codes), this currency is regarded as currency with two decimal places.

Exp:ISO Currency Decimal places Code- USDN (Internal) US Dollar (5 dec.pl.) 5 ( OR )

Table TCURX (decimal places for currency codes) is a client-independent table of the delivery class "C" (Customizing table). Therefore the table contents for this table can only be delivered with new installations.

For upgrade installations, new or changed contents of Table TCURX are not delivered.

Currency codes and decimal places for currency codes are defined in ISO standard 4217. For the specification of decimal places for currency codes, SAP uses this ISO standard.

For some currencies, for example, for the "Turkish lira", the decimal places which are used in reality deviate from the ISO definition. In many of these cases, SAP decided to adhere to the definitions generally used.

Exp:ISO standard 4217 defines two decimal places for the Turkish lira (TRL), however in reality zero decimal places are being used for the Turkish lira. SAP delivers zero decimal places as Customizing presetting for "Turkish lira".

Regards

Sridhar

Edited by: sridhar.shetty on Feb 21, 2012 7:18 AM

former_member794604
Participant
0 Kudos

Hi Sridhar,

currently we are using the currency SAR , and it is not maintained into TCURX table so it will be taking two decimals ,now we are going for an IS OIL Implimentation and the landscape which is using is same ,

the important point is We are running in SAP for last 10 yrs , if we are going to change the currency decimal means it will be effected to all the posted documents

for exp: in my understanding if we previously posted a document with 1000.99 SAR , after the change it will be changed as 100.099 , and also it will be effected to ouyr reporting

so i am seriously doubted whether we can go for the same , the first thing i want is ,it wont be effected to my present system , as in the case of new implimentation we can suggest that , but if we are using the running system whether the change is feasible ?

and whether we can go for the SAP SLO Services for this ?

Regards

Sanj

Answers (5)

Answers (5)

naveen_krishna2
Participant

Hello,

HUF is one of my client's currency and in our SAP it has been implemented with no decimals, now they came back requesting to setup/allow decimals for this currency.

I know we can set decimals in OY04 but I would like to know the impact of doing these changes to existing postings?

Is there any work around to achieve this functionality if so please guide me. It's an urgent requirement.

Regards,

Krishna

Former Member
0 Kudos

Hi,

Client want to change the decimal digit of values from 2 digit to 4th decimal place. So can anyone provide the configuration to increase the deimal place for PO, PR and Contract value. Also provide the impact after changing the decimal position with respect to Old and existing document.

Thank,

Mahesh

0 Kudos

As outlined in this blog, you can't simply change the currency key defintion on decimals in a living system, when you have done allready postings (the more, the worse, so to say...)

The reason why you can't do so from a day 'X' onwards without having changed also history is selfexplaining: you will create the more the worse inconsistency, since you have applied the change from a key date onwards, ignoring nevertheless the fact that postings have been already made before, thus one and the same currency key has either a increase or decrease by factor 10 per decimal that you change either up or down from that keydate onwards - clear so far, I would assume?

Now: as also outlined in this blog, you do have variants:

Variant 1: Create your own currency key as a new name with your definition - absolutely free for you, if you are not bound to any restrictions why you can't do so.

Variant 2: (if only few postings are affected, say some 100 documents) take back the postings. Change the decimals defintion in a test system. Replay the posting under the new defintion in that test box. Check briefly. If suiteable, and tests were 100% fine, you may consider to do the same on Production.(not recommended by SAP)

Variant 3: If you are bound to history or other rules: SAP SLO currency key conversion (also known as 'decimal conversion) or SAP SLO currency conversion.

See also SAP note 434349 on this subject.

Hope this helps, Uwe

former_member220489
Active Contributor
0 Kudos

No, You cannot simply change the decimal places for an existing currency key, which is already in use for many years. Since it will effect the system with immidiat effect, and even for old docs also....As you are already aware

And i believe that, you are going to create a new company code for the IS-Oil project...right?

My advice is to create a new currency key like below in OY03.

Currency Key: USDZ

Long Text: United States Dollar - 3 Decimals

Short Text: USD 3deci

ISO Code: USD

Alternative Key: 840

So as per the SAP best practise, you must create a new currency key using the same ISO code as above.

Now in OY04, change the decimal places from 2 to 3 for the new currency key USDZ.

Note: SAP Standard currecny key USDN is similar to your case with 5 decimals, in case if you can use 5 decimals, thenyou dont need to create USDZ, rather you can use USDN directly for your new company code.

Regards,

Srinu

former_member794604
Participant
0 Kudos

Hi Srinu,

Thanks for valuable suggestion , but in our case there is some difference

1 there is no seperate company code created for IS OIL , we are going to use the same company code for our new project also

2 what are the other impacts on our existing system

3 if we are using the same company code , is it possible to do the suggested chsnge

i mean

create a new currency key like below in OY03.

Currency Key: USDZ

Long Text: United States Dollar - 3 Decimals

Short Text: USD 3deci

ISO Code: USD

Alternative Key: 840

Now in OY04, change the decimal places from 2 to 3 for the new currency key USDZ.

Regards

Sanj

former_member220489
Active Contributor
0 Kudos

Well, when you post documents related to new project in the same company code use the new currency key USDZ.

As long as you follow this principle, there wont be any issue with the existing docs.

But practically, if see any reports, you will get docs in morethan one currency key. Like few docs (for older proj) in currency USD and few with USDZ (with 3 decimals).

It is a kind of segregation.

I think that there is no other option left for you in this case.

former_member794604
Participant
0 Kudos

Hi Srinu,

whether we need to use the SAP SLO service for the same ?

because in the Note : 434349 it is detailed like that ,

Regards

Sanj

former_member220489
Active Contributor
0 Kudos

I have suggested you to create a new currency key USDZ with 3 decimals only, but not advised to change the decimal places for exsiting currecny key USD at all.

I think the note 434349, which is meant for changing the decimal places for an existing currency key, which is already in use. But not for new currency keys.

Former Member
0 Kudos

Hi,

Go to T.code: SU01 and Give your User name Click on change button (SHIFT+F6)and click on Defaults Tab change Decimal Notation and save

And SPRO>SAP NetWeaver>General Settings>Set Countries>Define Countries in My AP Systems and click on Define Countries in mySAP Systems and double click on your Country change Dec.pt.format (Decimal Notation) Under Date Format and Decimal Character and save

Thanks,

Raviteja

former_member794604
Participant
0 Kudos

Hi Ravi / nkonnipati ,

Thanks for your repply , OY01 will note work out for my scenario.

Regards

Sanj

Edited by: Sanj S L on Feb 21, 2012 12:28 PM

narasimhulu_konnipati
Active Contributor
0 Kudos

For a single user - User settings

SU3

Currency level

OY01 - Double click on Currency and set decimal place

Thanks