Symptom
While trying to migrate the materials, however in the simulate step system gives the below mentioned error message.
Errors detected during data import
Data Import (1 Errors Found, 0 Warnings Found)
Error detected in source record with key value 'ABC' ('ABC' refers to the Material ID)
Go to Correction
Edit Source Record
Service call failed; report an incident
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Configuration work center.
- Go to the overview
- Search for activity: Migration of Material Valuation Data.
- Select Migrate material valuation data using the migration tool.
- Select the relevant Migration Unit.
- Give Execute Migration - Execute Migration Step by Step and in the simulation the log shows the error message as mentioned below,
Errors detected during data import
Data Import (1 Errors Found, 0 Warnings Found)
Error detected in source record with key value 'ABC'
Go to Correction
Edit Source Record
Service call failed; report an incident
Cause
If the material 'ABC' cost in the Inventory valuation view is maintained with long value such as in trillions, it will give the error mentioning that particular material 'ABC'.
Basically, there is a limitation for the length of the cost and the data type must be a packed decimal number, it only accepts 22 digits including the decimal indicator and +/- sign. If it exceeds more than 22 digits, that is the reason for this error message while migrating the materials,
Resolution
If this error message occurs, a case must be created to SAP Technical Support with an updated authorization to proceed with the correction. It requires the engagement of Development Support to make the required backend correction.
- There won't be any workaround possible in UI system to change the values of the materials,
- The error related to the digits limitation in the backend will be reviewed, and the exception raised in debug mode, which has the context menu "Compose Paragraph," will be skipped.
- Once the correction is completed, the materials data can be migrated.
Keywords
Migration of Material, Valuation, migration, Error detected in source record with key value, Service call failed , KBA , AP-FMD-MAT , Material Valuation Data , Problem