In this SAP FI tutorial, we will talk about SAP exchange rate table in SAP Financial Accounting. You will learn what tables inSAP FIare used for managing and changing exchange rates. We will mention the SAP transactions and tables that are relevant for this process.
As you should already know from our previous tutorials,Exchange ratesare 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
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 codeOB08.
SAP has a dedicated table for maintaining exchange rates. The name of the table is
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
contains the information about currency translation exchange rate types. In this table, there are the following fields:
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.
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.
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.
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.
Exchange rates are calculated from the manually entered currency.
Path:SPRO SAP Reference IMG SAP NetWeaver General settings Currencies Check Exchange Rate TypesAdvertisement
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:
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.
Here we configure whether an exchange rate for the currency pair is on direct or indirect quotation basis.
A direct quotationmeans that exchange rates are entered forFromcurrency toTocurrency.An indirect quotationmeans that exchange rates are entered forTocurrency toFromcurrency. 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 adirectquotation. If anindirectquotation is chosen for the same combination of currencies, then the exchange rate needs to be maintained for the same currencies NZD/AUD as anindirectquotation.
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.
Path:SPRO SAP Reference IMG SAP NetWeaver General settings Currencies Define Standard Quotation for Exchange RatesAdvertisement
Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. Itd be a big help for us, and hopefully its something we can address for you in improvement of our free SAP FI tutorials.
Go to overview of the course:Free SAP FI Training
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.
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.
I would like to ask question. I want to add into our System conversion from USD – CZK. How should I do this?
Which tables should be maintainend? Should I just add new entry into TCURR with those currencies or do I need something else to maintined?
Do you have a question and want it to be answered ASAP? Post it on our FORUM here –>
Your email address will not be published.Required fields are marked*
Save my name, email, and website in this browser for the next time I comment.
This SAP easy access tutorial will give you an ove…
When a company begins the process of implementing …
Implementing SAP in an organization not only align…
SAP financial accounting has several sub ledgers, …
The SAP functional specification, affectionately r…
how many currencies we can maintain in ecc 6 ?…
Im a SAP PSM Consultant around 10 years and looking for remote job for PSM…
Superb. In single place you explained notification process very well with realisting…
This is an unofficial blog about SAP certification, SAP training, and other things related to one of the worlds leading ERP system.
This blog is independent andNOTaffiliated with SAP SE (the company behind SAP ERP system). Your usage of this website signifies your agreement with our terms and conditions. We would be happy to hear your feedback or questions.