Symptom
- During mass data processing, an issue is being observed in the export of supplier data.
- The certain field values are not being written into the correct field. Instead, these values are being written into a different field.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Mass Data Maintenance work center.
- Select the option to export supplier data.
- Choose Go and export the CSV file.
- Observe that few values are displayed in different column.
Cause
Special characters like comma, question mark, period etc. may have been used in the filed.
- As the system identifies some of these characters as separators in a filed, this might cause the file to "break" into a wrong format, which leads to the mentioned technical exception.
- Or, for example, quotes are maintained as text qualifier during upload and quotes are also used in the file data (for example in description fields). But the text qualifier which is selected during the upload cannot be part of the data being imported.
Resolution
Review the file for values in incorrect formatting and correct the file.
Keywords
Mass Data Processing, Supplier Export, Incorrect Field Mapping, CSV Export , KBA , SRD-MD-BP-SUP , Suppliers , Problem
Product
SAP Business ByDesign all versions