Function documentation Translation to a Target Currency Locate the document in its SAP Library structure

Use

You can use this function to translate the data records from a source key figure (such as the local currency) to a target key figure (such as the group currency).

Features

Translation from source key figure to target key figure

You can individually specify a source key figure for each selection, or a common one for the method layout. The target key figure is taken from the permanent parameters when the task is executed.

Use of exchange rate types

You may want to use different exchange rate types depending on which group of accounting objects you want to translate. Say, you want to translate long-term assets at historical exchange rates, inventory at current rates, and income statement items at average rates.

You define the exchange rate types in the SAP Implementation Guide at General Settings ® Currencies ® Check Exchange Rate Types and Enter Exchange Rates.

Use of currency translation keys

You may want to use different currency translation keys depending on which group of accounting objects you want to translate. Say, you want to translate cumulative balances for stockholders' equity, but periodic balances for retained earnings.

Currency translation supports the following currency translation keys:

Criterion /

Currency Translation Key

Translation Timeframe

Translation Rule

Date for Exchange Rate Determination

Cumulative

Cumulative translation

multiplied ...

... by the exchange rate of the current period

Periodic

Periodic translation

multiplied ...

... by the exchange rate of the current period

Periodic, average rate for reductions

Periodic translation

  • if value increases: multiplied by the current rate
  • if value decreases: multiplied by the average rate for the prior periods of the fiscal year

(see Translation Rule column)

Target key figure is not modified

If the values were recorded in the target currency:

  • the system does not modify the values
  • but the system performs a reference translation and records a translation difference

Periodic or cumulative translation

Periodic translation uses data that belongs to the current period. By contrast, cumulative translation uses data that belongs to the entire fiscal year.

Example

       

Periodic

Cumulative

Period

Value in LC

Total Value in LC

Exchange Rate

Value in GC

Total Value in GC

Value in GC

Total Value in GC

001

100

(100)

2.0

200

(200)

200

(200)

002

50

(150)

2.2

110

(310)

330-200
=130

(330)

LC = local currency; GC = group currency

Average exchange rate when value decreases

When the value decreases, you can determine that the period value is translated using the average rate, which stems from the prior periods of the fiscal year.

Example

This example uses periodic translation.

Period

Value in LC

Value in GC

Exchange Rate

001

1,000

1,500

1.5

002

1,000

2,000

2.0

003

1,000-

1,750-

1.75

The system calculates the average rate for period 3 as follows:

(1,500 + 2,000) / (1,000 + 1,000) = 1.75