SAP Exchange Rate Table

Advertisement

SAP Exchange Rate TableIn this SAP FI tutorial, we will talk about SAP exchange rate table in SAP Financial Accounting. You will learn what tables in SAP FI are used for managing and changing exchange rates. We will mention the SAP transactions and tables that are relevant for this process.

Exchange Rates in SAP

As you should already know from our previous tutorials, Exchange rates are to be maintain in SAP to allow transactions in other than the company code currency or book value in additional local currencies in the New G/L accounting.

Advertisement

Example:

A company code currency is GBP and goods are purchased in EUR. In this case, first translation ratios need to be maintain for GBP/EUR and EUR/GBP combinations to allow us to maintain the exchange rate in the transaction code OB08.

SAP Exchange Rate Table

SAP has a dedicated table for maintaining exchange rates. The name of the table is TCURR.

SAP Exchange Rate Table
SAP Exchange Rate Table (TCURR)

The field ExRt of this table contains an exchange rate type. Exchange rate type M is provided by SAP which applicable to fetch an exchange rate for any foreign currency transactions. As per the client requirements, it is also possible to create new exchange rate types and it is not advisable to delete the standard exchange rate types.

Currency Translation Exchange Rate Types Table
Currency Translation Exchange Rate Types Table

The table TCURV contains the information about currency translation exchange rate types. In this table, there are the following fields:

  1. Reference Currency: Foreign currency translation is vital for many different currencies. Through the reference currency we can simplify maintenance of exchange rates. In this case, exchange rates need to be maintained against the exchange rate type and the reference currency combination.
  2. Buying and Selling rate: Buying and selling exchange rate types are not mandatory. If we maintain the exchange rate type here, then the spread needs to be maintain for all the relevant currency pairs.
  3. Inverter exchange rate: Inverter exchange rate helps to fetch exchange rate in case of unavailability. For example, the exchange rate for INR/USD might not be maintained but if you select this option, the system will consider the exchange rate for USD/INR.
  4. Exchange rate type uses special translation model: By selecting this option SAP will internally call an algorithm for calculation. It is used to meet the European Monetary Union (EMU) statutory guidelines. A reference currency needs be maintained if we are selecting this check box as per the EMU guidelines.
  5. Fixed: Exchange rates are calculated from the manually entered currency.

Path: SPRO – SAP Reference IMG – SAP NetWeaver – General settings – Currencies – Check Exchange Rate Types

Advertisement

Transaction code: OB07

Table: TCURV (Exchange rate types for currency translation)

Furthermore, there is a table for defining quotations for exchange rates – TCURN. These table has the following fields:

  1. Valid from: The date from which the exchange rate needs to be considered. If there is no valid-to date, the system considers the latest date as valid-from and the previous date as valid-to. For example, if in the system exchange rates needs to be maintained for 13.10.2015 and 14.10.2015, for 13.10.2015 valid-to also belongs to same date. Another example is if exchange rates need to be maintained for 13.10.2015 and 15.10.2015. In this case, the exchange rate for 13.10.2015 is valid until 14.10.2015.
  2. Indirect or Direct quotation exchange rates: Here we configure whether an exchange rate for the currency pair is on direct or indirect quotation basis.
Maintenance View for Table TCURN
Maintenance View for Table TCURN

A direct quotation means that exchange rates are entered for From currency to To currency. An indirect quotation means that exchange rates are entered for To currency to From currency. On the above screenshot, the currency AUD/NZD exchange rate is considered to be maintained against AUD to NZD. This kind of currency combination is called a direct quotation. If an indirect quotation is chosen for the same combination of currencies, then the exchange rate needs to be maintained for the same currencies NZD/AUD as an indirect quotation.

If a client wants to consider only direct quotations for all the currencies, then the quotations need to be maintained as shown below. By maintaining the currency quotation this way we can reduce the number of entries of each currency and their combinations.

Maintain Direct Quotation for All Currencies
Maintain Direct Quotation for All Currencies

Path: SPRO – SAP Reference IMG – SAP NetWeaver – General settings – Currencies – Define Standard Quotation for Exchange Rates

Advertisement

Table: TCURN (Quotations)

Prerequisites:

  • Currency translation ratios to be maintain – Transaction code OBBS
  • Currency exchange rates – Transaction code OBB8

Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP FI tutorials.

Navigation Links

Advertisement

Go to next lesson: SAP Chart of Accounts

Go to previous lesson: SAP Exchange Rates

Go to overview of the course: Free SAP FI Training

Page last updated by Cleo Isco on

2 thoughts on “SAP Exchange Rate Table”

  1. Hi Cleo Isco,
    I noticed on TCURR table valid from is not consistent as we have it in this order 2010, 2016 and 2015,
    and my question is why is SAP TCURR this way. I was actually thinking that it should have been either in descending or ascending order.

    1. It is first sorted by “ExRt” column. In our example, we have EURX and M exchange rate types in the first column. And then, within each exchange rate type, rows are sorted in descending order.

Leave a Reply

Do you have a question and want it to be answered ASAP? Post it on our FORUM here --> SAP FORUM!

Your email address will not be published. Required fields are marked *