Symptom
When you trying to migrate materials but error detected in source record with key value 'ABC'.(ABC refers to the Material ID).
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Configuration work center.
- In overview, Search for activity: Migration of Material Valuation Data.
- Select Migrate material valuation data using the migration tool.
- Select the relevant Migration Unit.
- Click Execute Migration - Execute Migration Step by Step.
The Log shows: The below mentioned error message as follows;
Statistics
Errors detected during data import
Data Import (1 Errors Found, 0 Warnings Found)
Error detected in source record with key value 'TINMX05001, 301, 3015'
Go to Correction
Edit Source Record
Service call failed; report an incident
Cause
If Material Inventory valuation is maintained as long value, it will give dump in backend for numeric overflow which is causing the error in source record with key value 'ABC' (ABC refers to the Material ID).
For example in Material ABC, if the cost mentioned as in trillions or more than that for the valuation. There is a limitation for the length of the cost. There the data type must be a packed decimal number, it only accepts 22 digits including the decimal indicator and +/- sign. If its exceeds more than 22 digits, that is the reason we see dump being raised.
Resolution
Once the above mentioned error arises you have to report an incident to SAP Technical Support. Hence there won't be any workaround possible in UI system to change the values of the Materials.
It requires the engagement of Development Support to make the required backend correction.
To proceed with the correction you have to update the incident with your authorization.
They will check this dump about the digits limitation existing in the backend and will skip the exception raised in debug mode which hasCompose Paragraph. After this correction is done you can migrate the materials data.
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