The table TCURX stores decimal places for currency keys. This table is referenced by some function modules and standard programs. If you want to know more about currency keys then the following link is a good starting point.
Currency translation is one of the important thing in BW.It t can be used directly in reports,so that we can skip some custom code, when using BEx. we have to consider the following tables when u talk about currency translation:
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
o Deletion of an entry from the TCURX table (corresponds to changing the decimal places to the standard value of two decimal places)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.