Symptom
During freight migration using the migration tool, the validation step fails with the following error message:
'Freights': Mandatory value missing in column 'Document Type'.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Configuration Work center.
- Select the Overview View.
- Search and Open the activity Migration of Freights.
- Choose Migrate freights using the migration tool.
- Select You Can Also at the top right corner of the screen and download the Migration Template.
- Fill in the required and mandatory fields in the migration file, leaving the field Document Type empty.
- Upload the Migration File.
- Execute the migration for the respective file with Execute Migration Step by Step.
In the Validation step, observe the following error:
'Freights': Mandatory value missing in column 'Document Type'.
Cause
The error occurs because migration of custom freights is not supported in the migration tool. The field Document Type is mandatory in the standard freight migration template, and if it is not maintained, the system raises the validation error.
Resolution
Custom freights cannot be migrated using the migration tool. Instead, create freights via the Web Service ManageSalesPriceSpecificationIn, which does not require the Document Type field.
Keywords
freight migration, migration tool, mandatory value missing, document type, mandatory, custom , KBA , AP-SLO-SO , Sales Order , Problem
SAP Knowledge Base Article - Public