SAP Knowledge Base Article - Public

3657774 - Migration objects with template files supporting 3-decimal currency places for currency amounts

Symptom

  • Migrating currency amounts for a country/region with three decimal places is not fully supported by most migration object's uploaded template files. Only two decimal places are generally allowed.
  • Error message "Value &1 cannot be converted; value can have maximum &2 decimal places (DMC_MD_INTERPRETER 035)" is thrown during the Validation step in Migrate Your Data app.

Environment

SAP S/4HANA Cloud Public Edition 2052 version and later 

  • "Migrate Your Data – Migration Cockpit" app
    • Migrate Data Using Staging Tables

Reproducing the Issue

  1. Upload data migration template files with currency amounts containing more than two decimal places in it. 
  2. Observe the error message "Value &1 cannot be converted; value can have maximum &2 decimal places (DMC_MD_INTERPRETER 035)" displayed during the validation step. 

Cause

In SAP configuration (table TCURX), seven currencies are defined with three decimals places:

  • BHD -Bahraini Dinar
  • IQD - Iraqi Dinar
  • JOD - Jordanian Dinar
  • KWD - Kuwaiti Dinar
  • LYD - Libyan Dinar
  • OMR - Omani Rial
  • TND - Tunisian Dinar

Two of them, BHD and JOD are using only two decimals in practice. The others are using three decimal places in practice.

Most of the data migration APIs' structure can only handle currency values with 2 decimals. Only a very little number of API structures can handle more than 2 decimals places. The data migration conversion rule CURR_TO_INTERN (Convert Currency to Internal Type CURR Format) and CURR_TO_INTERN_2 (Convert Currency to Internal CURR (w/o Source Currency) are used to convert currency values with 0 or 2 decimal places. They cover ~97% of the currencies used in the world.

Resolution

  • Newly delivered migration objects since release 2502 must support three decimal places for amount fields.
  • Based on the analysis of usage and the importance to use three decimal places within the object, there is a Development Plan to enhance existing currency amount fields of migration objects to support three decimal places.
  • The following existing migration objects are supporting three decimal places since 2508 now:
    • FI - Accounts payable open item (SIF_OPEN_ITEM_AP)
    • FI - Accounts receivable open item (SIF_OPEN_ITEM_AR)
    • FI - G/L account balance and open/line item (SIF_GL_BALANCE)
    • FI - Historical balance (SIF_FI_HIST_BAL3)
    • Product (SIF_PRODUCT)
    • Material inventory balance (SIF_INVENTORY_2)

See Also

For SAP S/4HANA and SAP S/4HANA Cloud Private Edition systems, refer to KBA 3517123 - Migration cockpit template only allows zero or two but no three decimal places for currency amounts.

Keywords

BHD, IQD, JOD, KWD, LYD, OMR, TND, TCURX, Oman, Kuwait, three decimal places, two decimals, three decimals, DMC_MD_INTERPRETER, 35, FI - Accounts payable open item, FI - Accounts receivable open item, FI - G/L account balance and open/line item, FI - Historical balance, Product, Material inventory balance, migration object, migrate your data, SAP S/4HANA Cloud Public Edition , KBA , CA-GTF-MIG , SAP S/4HANA Data Migration Cockpit Content , How To

Product

SAP S/4HANA Cloud Public Edition all versions