SAP Knowledge Base Article - Public

3211978 - Value from a field being shown in the wrong column - Integration Center

Symptom

A Integration Center job is created and the value of some fields appear in wrong columns.

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

If any field includes comma "," in it's value, Integration Center will treat it as a command for starting a new column. As a result of it, fields may appear in the next right column.

Resolution

A suggestion for you to solve this would be removing all commas that have in each field by following these steps:

  1. Click on the column header and go to Edit Calculation


  2. Select "Remove all" in Operation dropdown
  3. Provide the value "," in Text to Remove

Keywords

comma, ic, wrong place, Edit Calculation, Remove all , KBA , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , Problem

Product

SAP SuccessFactors HCM Suite all versions

Attachments

Pasted image.png