SAP Exchange Rates

Advertisement

SAP Exchange RatesIn this SAP FI tutorial, we will talk about SAP exchange rates in SAP Financial Accounting. You will learn what is an exchange rate in SAP FI and what are the configuration steps for foreign currency valuation in SAP system. We will mention the SAP transactions and tables that are relevant for this process.

Exchange Rates in SAP

SAP exchange rates are to be maintained to allow transactions in other than the company code currency or to book foreign currency transactions and update values in parallel currencies in the New G/L accounting.

Advertisement

For example:

A company code currency is INR but it purchased material in USD currency, so in this case first translation ratios are to be maintained for INR/USD and USD/INR combination. After that SAP system will allow to specify an exchange rate against INR/USD and USD/INR combinations.

Exchange rates fluctuate every day and for this reason exchange rates are to be maintained on a daily basis. In the real time scenario, an organization receives a daily exchange rate file through banks or third party team that uploads it to the SAP system.

In New GL accounting, SAP has provided a functionality called parallel accounting, i.e. for a company code an additional two parallel currencies can be maintained. With the help of the exchange rate the SAP system will update values in additional currencies so it is helpful for management to view different reports at company code currency and group currencies levels.

Prerequisites

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

Month End Activities

To prepare financial statements of an organization the foreign currency valuation is to be performed. Through this step foreign currency transactions will convert to company code currency and exchange rate loss or gain will be determined. It is possible to reverse foreign currency postings.

Advertisement

Prerequisites for Foreign Currency Valuation

Valuation Method

It is necessary to define the valuation approach to perform foreign currency valuation for open items and balances.

Define a Valuation Method
Define a Valuation Method

Valuation Area

A valuation area is necessary to report different valuation approaches and post to different accounts. It  is assigned to a valuation method.

SAP Valuation Area
SAP Valuation Area

Assignment of Accounting Principle of Target Ledger Group

A ledger group will be assigned to an accounting principle. For example, the accounting principle GAAP is assigned to the leading ledger Z2.

Assignment of Accounting Principle to Target Ledger Group
Assignment of Accounting Principle to Target Ledger Group

Assign Valuation Areas and Account Principles

An accounting principle needs to be assigned to a valuation area.

Assignment of Valuation Area to Accounting Principles
Assignment of Valuation Area to Accounting Principles

Prepare Automatic Postings for Foreign Currency Valuation

Here G/L accounts need to be maintained to post exchange rate gain or loss for each G/L account.

Account Determination for Exchange Rate Differences
Account Determination for Exchange Rate Differences

Path: SPRO – SAP reference IMG – Financial Accounting (New) – General Ledger Accounting (New) – Periodic Processing – Valuate – Define Valuation Methods, Define Valuation Areas, Check Assignment of Accounting Principle to Ledger Group, Assign Valuation Areas and Accounting Principles and Prepare Automatic Postings for Foreign Currency Valuation

Advertisement

Transaction: FAGL_FC_VAL

Tables: T030H (Acct Determ.for Open Item Exch.Rate Differences)

T030HB (Acct Determ.for Open Item Exch.Rate Differences)

FAGL_BSBW_HISTRY (Valuation History for Documents)

Advertisement

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

Go to next lesson: SAP Exchange Rate Table

Go to previous lesson: Currencies in SAP

Go to overview of the course: Free SAP FI Training

Page last updated by Cleo Isco on

2 thoughts on “SAP Exchange Rates”

  1. Just be careful of some minor gramatical errors throughout the course. For example:
    – “Exchange rates fluctuate every day and for this reason exchange rates are to be maintain[ed] on [a] daily basis.”
    – “for a company code [an] additional two parallel currencies can be maintained.”

    Overall a very helpful learning guide though 🙂

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 *