2801678 - Unable to Update Multiple Values in a KUT Field via Data Workbench

You are trying to update multiple values in a KUT field via Data Workbench, but the task fails with the following error message: "Invalid code; maintain correct ABC code" (where ABC stands for the name of the KUT field).

SAP Cloud for Customer

1. Go to the Data Workbench work center.
2. Access the Import tab.
3. Select Individual Object, choose Update Operation and then select the required Object.
4. Click on Next.
5. Upload the file in the Data Workbench.
6. Click Next, then click Import.
7. Go to the Monitor tab and check the CSV file with errors.

The separator of the multiple values for the field is a comma, which is the same character as the delimiter of the columns in the CSV file. Due to this, the system does not understand how to properly process the data.

1. Please maintain the multiple values of the multi-valued field within quotes — for example, "Z123,Z456" (where Z123 and Z456 stand for valid values for the field).

2. If this doesn't helps you can also try the reverse, using it without quotation marks: Z123,Z456.

IMPORTANT: Make sure the excel cell for particular multivalued code is formatted as text. Sometimes excel considers, for example "123,456" as a complete number and converts it to

1,23,456, which again can cause issue. More content on the topic:  https://support.microsoft.com/en-us/office/format-numbers-as-text-583160db-936b-4e52-bdff-6f1863518ba4

Please note that the support for multi-valued fields in Data Workbench was made available with system version 1811. Multi-valued fields created before this version must be re-added in order to be supported by the service. Help Center

Data Workbench, Invalid code, maintain correct, code, Multi-Valued Lists, KUT field. , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions