02-04-2013 1:20 PM
Hi there,
We have just implemented SAP Retail in Taiwan for few months and now need to add two decimal places for the Taiwanese dollar currency. I would much apprecial if someone could share with me the proper way to do so.
Many thanks in advance.
Cheers,
Ivan
02-07-2013 9:05 AM
Hi,
In order to add two decimal places for your currency you can do the setting under the below mentioned path.
SPRO --> SAP Netweaver --> General Settings --> Currencies --> Set Decimal Places for Currencies.
Note: In 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.
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 further 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 Decimal Field:
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 run time 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
Award points if helpful.
Regards,
Madhan Raj. C
02-07-2013 9:05 AM
Hi,
In order to add two decimal places for your currency you can do the setting under the below mentioned path.
SPRO --> SAP Netweaver --> General Settings --> Currencies --> Set Decimal Places for Currencies.
Note: In 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.
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 further 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 Decimal Field:
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 run time 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
Award points if helpful.
Regards,
Madhan Raj. C
03-01-2013 9:59 AM
Hi Madhan,
Thanks for the detailed explanations. Do you have any recommendation if we have to make the changes in a productive system?
Best regards,
Ivan
03-01-2013 11:05 AM
Hi Ivan,
Once you have started posting the documents in the production system it is hard for you to correct the already posted documents.
Hence it is not recommended to make any changes in the Production Environment.
Regards,
Madhan Raj. C