Performing Currency Translation (SAP Library - Enterprise Controlling (EC))

Performing Currency Translation

Use

Currency translation enables you to translate individual items or groups of items from local and/or transaction currency to group currency. Alternatively, values in group currency can be taken directly or historically from the additional financial data. The combination of translation options is grouped together in one or more translation methods and assigned to the consolidation units.

Procedure

Call up the transaction as follows:

Menu Path	Accounting ® Enterprise Controlling ® Consolidation ® Data collection ® Monitor
Transaction Code	CXCD

Choose Layout ® Show tasks if required.

Select Dimension 01 and choose

If the data monitor was not completely blocked after the validation task was unblocked and performed, you will see that no currency translation is required for some of the consolidation units (indicated by the sign "-", for example for C9000 and C3000), as these consolidation units are domestic. A red "x", like the one for cons unit C1000 indicates that the task is incomplete.

Select the row/column combination CrcyTrans. and C1000 and choose Update run.

On the Currency translation screen, you see that cons unit C1000 will be translated using translation method 00002 DEMO: ANI weighted. The underlying reference exchange rate is specified as 0.7.

Choose

, to expand the whole page.

Set CS01-190000, which contains the long-term asset items, is listed first. The items of this set are translated using currency translation key 1.

The total value of the items is then displayed in local currency and group currency. Any difference that results appears in the next column Diff. This is the difference between the reference value and the group value.

If necessary, use the scroll bar to get to item CS01-190000.

You now see a more detailed breakdown of the individual asset items of the fixed assets. By expanding further, for example item 191100, you see the corresponding transaction types. In this case, the total value belongs to transaction type 100 Opening balance.

Expand the item CS01-389999 to display the translation in the income statement.

Item 301100 Sales 3^rd prty has a local value of 71,445,270.94, which is translated with currency translation key 5 and an exchange rate of 0.65 in accordance with the translation method. This corresponds to a consolidated value of 46,439,426.11. However, if the value had been translated using the current exchange rate of 0.7, this would have resulted in a reference value of 50,011,689.66. Therefore, a translation difference of 3,572,263.55 is calculated.

Select the items Currency translation/ Differences/ Total and choose .

Select Differences and choose

The currency translation differences and rounding differences are now displayed.

Choose

, to return to the Data Monitor screen.

Choose

for the currency translation task and the cons groups CG1 and CG4 .

If you want to view the translation method in detail, call up Customizing as follows:

Menu Path	Tools ® AcceleratedSAP ® Customizing ® Edit Project
Transaction Code	SPRO

Choose

SAP Reference IMG.

Enter the following data:

Menu Path	Enterprise Controlling ® Consolidation ® Data ® Automatic Posting ® Currency Translation ® Translation Methods ® Define Currency Translation Methods
Transaction Code	CXD1

Select currency translation method 00002 and choose the level Method Entries in the Dialog Structure section by double-clicking on it.

Select the first sequence number 010 and choose

More information is available online in the R/3 Library under Accounting ® Enterprise Controlling ® Consolidation.

Choose

until the overview tree appears.