SAP ABAP IMG Activity SIMG_CFMENUORKEKEC3 (Define Currency Translation Keys)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       KE0C (Package) Customizing for Profitability Analysis
IMG Activity
ID SIMG_CFMENUORKEKEC3 Define Currency Translation Keys  
Transaction Code S_ALR_87005656   IMG Activity: SIMG_CFMENUORKEKEC3 
Created on 19981222    
Customizing Attributes SIMG_CFMENUORKEKEC3   Define Currency Translation Keys 
Customizing Activity SIMG_CFMENUORKEKEC3   Define Currency Translation Keys 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name SIMG_CFMENUORKEKEC3    

When you execute a drilldown report, you can display value columns in another currency using the function Settings -> Currency. In this step, you maintain the currency translation keys to be used for translating value columns. These translation keys are valid for all operating concerns and therefore can be used for all reports in Profitability Analysis.

Activities

Define your currency translation keys by carrying out the following:

  1. Enter a descriptive text
  2. Specify the currency translation key (historic rate, average rate, and so on).
  3. Specify whether the target currency should be fixed or variable.

    Your choice will influence the next screen in the following way:

    1. If the target currency is to be fixed, the next screen will present you with the possibility of entering a fixed target currency. However, it is recommended to leave this field empty in most cases. In drilldown reporting, you usually wish to use the same currency translation key to calculate currency-independent values. This means that only currency translation keys without a specified target currency are appropriate.
    2. If you opt for variable at this stage, the next screen will allow you to set up a link to a characteristic by entering a table name and a field name. If, for example, you would like the target currency to be selected depending on the country, specify the table with the country data (T005) and the field for the country key (LAND1). To do so, the country key must be defined as a characteristic in the operating concern.
  4. Specify whether the currency translation key should use a fixed or a variable translation date.

    The query appearing on a further screen will depend on your selection at this stage.

    1. A fixed translation date is either a prespecified date or the day on which you execute the program. The date fixed here, together with the exchange rate type, determines the rate used later for the currency translation.
    2. For variable translation dates, the date selected in the information system (period or fiscal year) determines the rate for each data record. Here you need to specify the time reference (beginning of period or end of year, for example). This enables you to translate each record with the rate that was valid at the beginning of the corresponding period.
      Note that, with variable translation, all columns linked arithmetically to the column to be translated are automatically translated as well.
      Note: You cannot create a date field as a characteristic in Profitability Analysis. Consequently, the option "Time base to the day" is not available here.
  5. Specify whether the rate is an inverse exchange rate.

    A translation key with an inverse rate is useful when the amounts have already been converted and need to be returned to the original values.

  6. Save your currency translation keys.

Example of a currency translation key with inverse exchange rate

You have maintained the following rates:

DEM USD 1.60

USD DEM 0.63

When translating from USD to DEM with an inverse rate, the system uses the rate 1/1.60 = 0.625 instead of 0.63.

Further notes

The column "Specific translation key" is not used in Profitability Analysis.

The translation keys do not affect currency translation during actual data transfers.

Business Attributes
ASAP Roadmap ID 207   Establish Reporting 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG SIMG_CFMENUORKEKEC3 0 HLA0009438 O  
SIMG SIMG_CFMENUORKEKEC3 1 I070004701 Profitability Analysis 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
V_T242Q V - View KEC3 02 Currency translation types CO-PA 
History
Last changed by/on SAP  19990921 
SAP Release Created in