SAP Exchange Rate Tables – Currency Conversion Table in SAP

SAP Exchange Rate Tables

The important Exchange Rate tables in SAP that are used for currency conversion are as follows.

After learning the important FX currency conversion table in SAP, as a SAP consultant you must know how this exchange rate table in SAP is working for real time currency conversion.

In SAP, there are three types of Exchange Rates are defined and these exchange rate types are used for various purchases. The different types of exchange rates are

1. Bank Buying Rate (G Type)
2. Bank Selling Rate (B Type)
3. Average Rate (M Type)

The currency which was assigned to company code is called as the local currency or company code currency. When the document is posted with the other than the company code currency/ local currency, then the transaction is called as the foreign currency.

Based on the Exchange Rates maintained in the tables, the currency conversion is done automatically from the foreign currency to the local currency. The values are converted as per the exchange rate table updated in the system.

Every organization updates the exchange rate frequently, so the foreign currency transactions are updated correctly and provide the correct exchange rate or gain reports.

The FX rates of exchange rates are maintained as per the

• Direct Quotation or
• Indirect Quotation.

Important Configuration Steps

The following are the important configuration steps of exchange rate that are used for maintaining the foreign currency conversions in SAP.

1. Define Translation Ratios for Currency Translation (OBBS)
2. Exchange Rate Types
3. Maintain Exchange Rates -> OB08
4.  Define Maximum exchange rate difference per company code
5. Define Maximum exchange rate difference per foreign currency
6. Maintain Exchange rates at End User Level : S_BCE_68000174
7. Currency Simulation – EWCT

Define Translation Ratios for Currency Translation

• Transaction Code: OBBS
• Table: TCURF

In this configuration settings, you maintain the currency translation ratios between the two currencies.

Fields in TCURF Table

Exchange Rate Types

• Transaction Code: OB07
• Table: TCURV

This is one time configuration. The exchange rate type determines the type exchange rate using for bank buying rate, bank selling rate and average rate for the foreign currency conversion in SAP.

Fields in TCURV Table

Maintain Exchange Rates

• Transaction code: OB08
• Table : TCURR.

This is the place where the exchange rates are maintained for the exchange rate type with a combination of currency types (From currency – To currency). The system picks the exchange rate values from this TCURR – Currency Conversion Table in SAP.