SAP Knowledge Base Article - Public

2771598 - Using Data Workbench, Unable to Import Additional Entries for the Code List Property

Symptom

Your requirement is to import the data for the respective object in Data Workbench. For the code list mapping of a property, you added a new row to the list. But the newly added value is not available in the code list.

Environment

SAP Cloud for Customer.

Reproducing the Issue

  1. Go to Data Workbench workcenter.
  2. Go to Import view.
  3. Select the radio button for Individual Object.
  4. Go to Insert tab.
  5. Go to Standard Object tab.
  6. Search for the Data Workbench object XYZ (where XYZ is the object in Data Workbench).
  7. Select Download.
  8. Fill data in the fields.
  9. Save the file.
  10. Select Next and Browse for the file.
  11. Select Upload.
  12. Choose Next to Review and confirm system-proposed data mapping.
  13. Select Next.
  14. In the section Map codes in data file with Internal Codes, select a code list property.
  15. To maintain code list mapping for the property, select the button Download.
  16. Add a row to the Microsoft Excel file and fill the required fields.
  17. Save the file.
  18. Select the button Upload and upload the code list mapping file.
  19. In the search box for code list mapping, search for the newly added value.
  20. There is no data.

 

Example:

You want to import the Accounts using Data Workbench. While processing the file in Data Workbench, in the maintain code list mapping for a property, for the property Price Group, you added new Price Groups in the Microsoft Excel and uploaded the file. But the newly added value for the Price Groups is not available in the search box for code list mapping.

Cause

Using Data Workbench, while maintaining the code list mapping for the property, you added new row and maintained the new code list mapping for the respective property.

Resolution

Using Data Workbench, while maintaining the code list mapping for the property, you cannot import the additional rows with data (example: Code and their Descriptions) for the respective property.

You can maintain code list mappings by mapping code values maintained in data file with code values in SAP Cloud for Customer (internal). All the code list properties applicable for the selected object will be displayed. For all the values in the data file for which no code list value is assigned in SAP Cloud for Customer, you can assign a default code list value. You may also save this code list mapping as a template for future use. Code list mapping can also be done by downloading a template CSV file, maintain the mapping and upload the updated template back.

Keywords

Code list mapping, Property, Data Workbench , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem

Product

SAP Cloud for Customer add-ins all versions