Uniquely determining the exchange rate for a currency pair requires the following input parameters:
- FROM-currency (also named FOREIGN-currency)
- TO-currency (also named LOCAL-currency)
- Exchange Rate Type
The following tables are used for calculating the exchange rate: TCURR, TCURN, TCURF, TCURV
For displaying the converted amount of a currency pair additionally table TCURX needs to be taken into acount.
To see a date instead of an integer number for date fields, please tick on 'Respect Conversion exit' in transaction SE16→ menu 'Settings'→ User parameters → tab Data Browser →section 'Format'.
Below you will find an explanation on the purpose of these tables and an explanation on how to interpret the content.
In this table you can define for each currency pair, whether rates for the pair are usually entered as direct or indirect quotations. It is possible that the quotation for a currency pair changes over time.
Given a FROM-currency= EUR, a TO-currency=USD and an exchange rate= 1,38
- Direct quotation means: 1 EUR = 1,38 USD
Given a FROM-currency= EUR, a TO-currency=USD and an exchange rate= - 0,724638
- Indirect quotation means: 0,724638 EUR = 1 USD or 1 EUR = 1 / 0,724638 USD
- TO-currency = B
- For all currency-pairs with a FROM-currency other than A and a TO-currency=B, indirect quotation (quotation value=2) is used valid from 01.01.1800 onwoards.
- For the currency-pair FROM-currency=A and TO-currency=B, direct quotation (quotation value=1) is used valid from 01.01.2000 onwoards
- You can check directly in table TCURR what quotation is used for a currency pair for a specific exchange rate type and date. Often the following notation is used:
- In case the value for field Exch. Rate has no prefix, direct quotation is used.
- In case the value for field Exch. Rate has a prefix like '-' or '/', indirect quotation is used.
- It is possible to customize prefixes in transaction SPRO (SAP Netweaver->General Settings->Currencies), they are saved in table TCURP.
This is the main table containing the exchange rate of a currency pair for a specific Exchange Rate Type and a specific date. The date is valid up to another similiar entry having a more recent date.
- FROM-currency = A
- TO-currency = B
- Exchange Rate Type = M
|Cl.||ExRt||From||To||Valid from||Exch. Rate||Ratio (from)||Ratio(to)|
- From 19.10.2000 to 31.08.2004 exchange rate /0,84110 (-0,84110) is valid.
- -> 0,84110 A = 1 B (not yet taking into account factors defined in table TCURF)
- From 01.09.2004 up to now exchange rate 2,60000 is valid.
- -> 1 A = 2,60000 B (not yet taking into account factors defined in table TCURF)
- Fields 'Ratio (from)' and 'Ratio (to)' in table TCURR are not used anylonger. This information is now maintained in table TCURF.
- The prefix "-" (displayed as "/" if conversion exit is considered in the format) indicates that indirect quotation is used. Also see table TCURN for more details.
This table contains the factors that are to be used for each currency pair. Additionally, it is also possible to maintain an alternate exchange rate type for a currency pair. If defined, the derived exchange rate type is overruling the initial exchange rate type.
- FROM-currency = A
TO-currency = B
Exchange Rate Type = M
|Cl.||ExRt||From||To||Valid from||Ratio (from)||Ratio(to)||AltE||ValidFrom|
- From 01.01.1800 to 31.12.1989 the factoring beween A:B=1:1
- From 01.01.1990 to 31.12.1999 the factoring beween A:B=1:100
- From 01.01.2000 onwoards alternativ exchange rate type EURX is to be used, overruling the entries maintained for inital exchange rate type M.
- You need to maintain an entry for each currency pair you want to use for currency tranlsation even when you are using crossrates (see table TCURV).
- Always check whether direct quotation or indirect quotation is used for a currency pair as it determines what TCURF table entry is taken into account.
In this table you can define for an exchange rate type whether currency conversion shall be done by using a reference currency or not (cross rates).
Additionally, you can define if the system shall try to use the inverse exchange rate for a currency pair shall be used in case that no exchange rate is maintained.
|3||M||Standard translation at average rate|
|3||EURX||EUR||X||EMU regulation, variable exchange rates|
|3||V||X||Standard translation for Travle|
- For exchange rate type M currency conversion is done using the standard approach
- For exchange rate type EURX currency conversion is done by using reference currency EUR.
- For exchange rate type V currency conversion is done using the standard approach. In case that no currency converions can be found for a currency pair and a specific date, the system tries to apply the inverse exchange rate (If no exchange rate is found for currency A->B the system uses currency B->A and converts the exchange rate)
- In case that the reference currency is defined, then the exchange rate is always calculated using this reference currency even if a direct conversion rate is maintained.
- The Inverse-Flag is only taken into acount if you have not made an entry for the corresponding exchange rate.
Table TCURX defines how currency amounts are converted between DB storage and display on the front-end. By default, all amounts are stored with 2 decimal places on the database and are later converted for display based on the currency entry in table TCURX. If a currency is entered with e.g. value 0, then the currency is displayed with 0 decimal places in BW Queries (which means that the amount is displayed with factor 100 higher than it is stored on DB Level).