SAP Knowledge Base Article - Public

3446952 - Multivalue List in OData Services

Symptom

You are performing a GET in OData and the values of a multivalue list are appearing in the same line separated by comma. E.g. 101,111,112.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Cloud for Customer

Reproducing the Issue

1. Go to OData Console.
2. Select the desired entity and perform a GET.
3. Look for the Multivalue List field in the JSON result.
Result: You will see that the field are separated by comma, not in different lines.

Example:

Cause

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.

In UI, you can see that the same behavior occurs: the value is shown separated by comma as well.

Example:

Resolution

This is the system expect behavior. 
You can reach to Influence Portal in case you want to post an idea to improvement with your request.

See Also

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

Keywords

Multivalue List; Mutivalue; Code; OData; Line; Comma. , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem

Product

SAP Cloud for Customer core applications 2402