Performing Currency Normalization

By default, File Extractor performs currency normalization during the export of the data. SAP stores all currency fields with two decimal places. As a result, even if the specific currency does not have any decimal places, it is aligned in such a way that the result has two decimals. This behavior would display incorrect values for fields that are posted in currencies and that do not have two decimals.

To resolve this issue, FEX performs lookups to identify the correct currency key. This affects the number of decimals in the exported file. By default, this process is handled by function module ZSCD_FEX_REFTAB_TRANSLATE, which can cover basic cases. This function looks up a reference table based on common fields between the source table and the lookup table and then applies the currency key to the currency field value.

To handle more complex scenarios, it is possible to access two metadata tables from the FEX menu:

 

The table ZSCD_FEX_CN_H allows you to overwrite the reference table name and/or reference field name. It also allows you to register a custom function module, which must have exactly the same parameters as the original function module.

 

The table ZSCD_FEX_CN_MAP allows you to define a foreign key relationship between the source table and the lookup table if this relationship is not based on common fields with the same names.

 

If currency normalization is not required, you can use the function module ZSCD_FEX_NO_LOOKUP. Only use this function module in cases where there are only currencies with two decimals.

NOTE You can prevent short dumps caused by data inconsistencies by enabling the parameter CUR_TRANS_IGNORE. In this case, if a data inconsistency occurs, the value will not be normalized, and the process will not finish with an error.

Custom function modules for currency normalization are available in the following function groups:

  • ZSCD_FEX_CURR_NORM

  • ZSCD_FEX_HR_CURR_NORM

 

Dynamic Currency Adjustment

If dynamic currency adjustment is supposed to be used on the control system, currency adjustment must be disabled on the source system. To do so, you can enable the parameter CUR_TRANS_SKIP. This means that currency adjustment will not take place. Afterward, during the export of table structure, execute the step Generation > Export table structure (DD03L) and select the option Export reference field info.