Skip to Content

TCURX

Hi,

some one please explain me what is perpose of TCURX and how it is impact on the currency.

please help me,

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2007 at 10:10 PM

    Rob,

    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.

    http://help.sap.com/saphelp_nw70/helpdata/en/ec/076f3b6c980c3be10000000a11402f/frameset.htm

    Apart from this, if you search sdn you will find a lot of threads on this topic.

    -Saket

    Add a comment
    10|10000 characters needed characters exceeded

    • 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:

      TCURR - rates

      TCURF - factors

      TCURX - decimals

      check this blog:

      /people/rasim.manavoglu/blog/2007/04/30/currency-currency-currency

      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)

      o Insertion of an entry in the TCURX

      this is from sdn thread

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.