##### Child pages
• BW-BEX-OT-OLAP-CUR-TABLES - Overview of important tables used for currency translation
Go to start of banner

# BW-BEX-OT-OLAP-CUR-TABLES - Overview of important tables used for currency translation

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

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.

### Table TCURN

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

Table Example:

• TO-currency = B
Cl.FromToValid fromQuotation
3 B01.01.18002
3AB01.01.20001
•  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

Remarks:

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

### Table TCURR

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.

Table Example:

• FROM-currency = A
• TO-currency = B
• Exchange Rate Type = M
Cl.ExRtFromToValid fromExch. RateRatio (from)Ratio(to)
003MAB01.09.20042,6000000
003MAB19.10.2000 /0,841101 1
• 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)

Remarks:

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

### Table TCURF

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.

Attention: When using indirect quotation then the entry from the TO-currency to the FROM-currency is considered in table TCURF.

Table Example:

• FROM-currency = A
• TO-currency = B

• Exchange Rate Type = M

Cl.ExRtFromToValid fromRatio (from)Ratio(to)AltEValidFrom
003MAB01.01.200011EURX
003MAB01.01.19901100
003MAB01.01.180011

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

Remarks:

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

### Table TCURV

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.

3M       Standard translation at average rate
3EURX  EUR    EMU regulation, variable exchange rates
3VX      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)

Remarks:

• 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

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).

• No labels

1. Hi,

Can you please let me know how these currency tables can be loaded using flat files?

2. Hi,

you can do this in RSA1: Source system of type 'Flat File' --> Right click--> 'Transfer Exchange Rates'
The trasnaction is called RSIMPCUR (the program RSIMPCURFILE). I found the following paper which might be helpful:

best regards,
Peter

1. Hi Peter,

Thanks for the inputs.

My requirement is that I have only EUR - > other currency exchange rates available in TCURR.

My reports should be able to display in any currency depending on user inputs(variable).

We want to implement this using currency translation in Bex.

can you let me know the required settings in currency tables? Also, how to use date from data record as reference date for currency conversion?