SAP Knowledge Base Article - Public

3390735 - Field value is returned enclosed by quotation characters when using Value Lookup Table - Integration Center

Symptom

You have added a field which is using a Value Lookup Table in your integration and it's being returned enclosed by quotation characters in the integration preview and in the output file:

All other fields are working fine, only this field with the Value Lookup Table is behaving like this.

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 SuccessFactors HXM Suite
    • Integration Center

Cause

You have added a comma character in the output value of the Value Lookup Table:

Resolution

When you add a comma character in the Value Lookup Table, Integration Center will always enclose the output value with double quotes because the comma may be identified as another separation of values in the CSV structure, which could break the logic of the values. This wouldn't happen when the comma is enclosed by double quotes.

Keywords

double quotes, quote, between, quotation marks, quotation, csv, , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , Problem

Product

SAP SuccessFactors HCM Suite all versions