Show TOC

 Reports With Currency Translation Locate this document in the navigation structure

Use

In reporting for Overhead Cost Controlling (Cost Center Accounting, internal orders, business processes) you can display values in any currency as well as values in controlling area currency, transaction currency, or object currency. This particularly applies in the double currency phase for the European currency union. In this phase, you need to be able to display values in the Euro currency (as a freely selected currency) as well as the controlling area or object currencies in reports.

You can use the following options for defining or displaying reports in Overhead Cost Controlling, in a freely selected currency:

  1. Set up currency translation interactively in the selection screen, and in the output list for the Report Writer or Report Painter reports.

You can define a currency translation in the selection screen for reports. If other translations were defined using the options below, the system executes this translation as well. This means that the system may execute two currency translations. Once the report has run, you can change or deactivate the settings for the currency translation interactively.

  1. Reports with target currency entry on the selection screen

For customer-defined reports, the key figure Costs in target currency is provided in the Report Painter for column definitions. If you use this key figure during report definition in a column, then the following additional parameters appear in the selection screen for the report: Target currency, exchange rate date, and exchange rate type , for example, in the report for Cost Centers: Currency Translation (1S3W).

To do so, go to the SAP Easy Access menu, and choose Accounting -> Controlling -> Cost Center Accounting -> Information system -> Report selection -> More reports -> Cost Centers: Currency Translation.

To insert the target currency, the exchange rate date, or the exchange rate in the report texts, use a text variable from the selection criteria category.

SAP provides the following Report Painter standard reports. You can load this from the SAPServ as an alternative to the most important standard reports for cost centers and internal orders (available in the languages of the European currency union) in a variant that enables you to translate into any currency required.

Cost center reports (Library 1EU)

  • 1EAI Area: Cost Elements

  • 1EGJ Cost Centers: Fiscal Year Comparison

  • 1EHK Cost Centers: Drilldown by Partner

  • 1EIP Cost Centers: Actual/Plan/Variance

  • 1EKL Area: Cost Centers

  • 1ELK Cost Centers: Curr. Per. / Cumulated

  • 1EOB Cost Centers: Actual/Plan/Commitments

  • 1EOL Area: Actual/Plan/Commitments

  • 1EQU Cost Centers: Quarterly Comparison

  • 1EVG Cost Centers: Drilldown by Business Transaction

Internal order reports (Library 6EU)

  • 6EI0 Orders: Actual Annual Comparison

  • 6EI1 Orders: Actual Quarterly Comparison

  • 6EI2 Orders: Actual Period Comparison

  • 6EL0 List: Orders

  • 6EL3 List: Actual/Plan/Commitments

  • 6EM0 List: Cost elements

  • 6EO0 Orders: Actual/Plan/Variance

  • 6EO4 List: Debit/Credit

  • 6EO6 Orders: Current Period/Cumulated

  • 6EO8 Orders: Drilldown by Partner

  • 6EP0 Orders: Plan Annual Comparison

  • 6EP1 Orders: Plan Quarterly Comparison

  • 6EP2 Orders: Plan Period Comparison

  1. Global settings for report currency

From Release 4.0, you can enter user-dependent settings for the report currency. This is for all reports that use the basic key figure (costs in report currency) SWKG. To do so, choose Cost Center Accounting -> Information system -> User settings -> Report currency.

You can specify any target currency, source currency (= reference currency, such as controlling area currency), and an exchange rate date and exchange rate type.

You can also make these settings for reports in the following applications:

  • Internal Orders

  • Business processes

  • Overhead cost projects

  • Reconciliation Ledger

Most of the standard reports provided by SAP use the SWKG key figure (costs in report currency).