cancel
Showing results for 
Search instead for 
Did you mean: 

Currency Maintenance - Add decimal places

Former Member
0 Kudos

Hi everyone

I need to upload an EBS through FF.5 in COP (Colombian Peso) Currency.

Problem is COP is defined with NO decimal places and EBS has decimal places (different than zero).

When trying to maintain currency through OY04 I receive the following: u201CIn a productive system, you must not delete the currencies in use or change the decimal places. This could make amounts in documents already posted incorrect or invalid.u201D

AND AFTER I receive:

Before you continue, please read the following text carefully.

If you do not heed this note, you can cause irreparable damage to the system with this transacton. In the R/3 System tables currency fields are stored as decimal figures with a variable number of decimal places. The decimal point is not stored in the field in the database. Instead, each currency field refers to a currency key field. In this transaction you assign the number of decimal places to this currency key uniquely. Example: If you have set currency USD to have two decimal places and you post an amount of 100 USD, an amount of 10000 USD is stored in the currency field in the database. Not until this amount is processed further or is output does the system use the currency key from the reference field to determine the number of decimal places via this table. In this way the table content can be interpreted correctly for further processing or formatted for output with the correct punctuation. If after posting you changed the number of decimal places for USD, for example, to 3, the existing field content of 10000 would be interpreted for futher processing or output as 10 USD (10.000). This would mean that the contents of tables across the system would, for all currency fields containing an amount in USD, be interpreted incorrectly by 10 per cent. To change the number of decimal places for a currency already in use, you must convert all the tables in the R/3 System that contain currency fields, so that the data integrity remains. This cannot, however, for both organizational reasons and under the runtime aspect be carried out in a productive system. The following changes to the TCURX table can thus lead to the loss of data integrity if you make the changes in a productive system or transport them into a productive system: o Change to the number of decimal places of an existing currency o Deletion of an entry from the TCURX table (corresponds to changing the decimal places to the standard value of two decimal places) o Insertion of an entry in the TCURX (corresponds to changing the standard value of 2 decimal places to a different value), if this is a currency code that already exists Uncritical changes are any made to this table during the Customizing of a new installation or the insertion of TCURX even during operations, if the currency codes have just been entered in the TCURC table using transaction OY03, signifying that no postings to these currency codes can have been carried out yet.

Do you want to change the decimal places despite all recommendations?

So how can I configure the upload of an EBS for Colombia that has two decimal places different than zero?

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

SAP suggest to round COP.

Note 149274 - Incoming bank account statement with decimals

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi, thank you for your answer. Note 149274 suggests to round decimals manually or use ABAP to round.

This is something tricky if you realize that every rounding can lead you to difference with future EBS final and ending balances.

Former Member
0 Kudos

Hola CheS77, me podrías informar si este problema lo pudiste solventar?

Gracias de antemano por la respuesta!

Former Member
0 Kudos

Hola Alfredo.

No se puede solucionar si no es con ABAP.

Se le puede pedir al banco que te envíe los EBS sin decimales o con decimales en cero. A pesar de que COP no tiene decimales, si están en cero, los toma.

Slds, C.-