SAP Knowledge Base Article - Public

3555613 - Incorrect Field Mapping in Mass Data Processing

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

  1. Go to the Mass Data Maintenance work center.
  2. Select the option to export supplier data.
  3. Choose Go and export the CSV file.
  4. 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