SAP Knowledge Base Article - Public

3406086 - DMC_MD_INTERPRETER 37 "Sheet &, column '&' : Row & will be truncated during transfer." in migration cockpit

Symptom

Migration cockpit process has status Validation Completed with the following Warnings issued:
  • DMC_MD_INTERPRETER 37 "Sheet &, column '&' : Row & will be truncated during transfer."

Environment

SAP S/4HANA Cloud Public Edition 

Cause

Value used in row & column & has length greater than field length permitted. 

Note: If the input is a decimal number, note the following: 

  • Most decimal numbers will be stored with longer decimal places in Microsoft Excel.
    When you upload the file, the number of decimal places will be truncated based on the number of decimal places defined by the migration object.

Resolution

Use a value in row & column & with length within the field length permitted.  

When using decimal numbers, pay close attention on the number of decimals accepted for the field.
For example:

  • The warning can be ignored if the field accepts 2 decimal numbers and the value provided is "12.99". 
  • If the same field is provided with value "12.999" the last number will be trimmed off.    

If it is determined that the messages can be ignored, the "Transfer Data to Staging Tables" option can be clicked to transfer the data to the staging tables.

Keywords

Skip, jump, stuck, Status Validation Completed with Warnings Warning issued, warning message, MYD, data migration. , KBA , CA-LT-MC , S/4HANA Migration Cockpit , Problem

Product

SAP S/4HANA Cloud Public Edition all versions