SAP Knowledge Base Article - Public

2594749 - How to use Value Lookup Table in Integration Center

Symptom

Customer requirement is to assign custom output values / codes for the standard output of query fields on an Integration Center output file.

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

Reproducing the Issue

Need to assign custom values on output fields in the Integration Center job.

Resolution

  1. Go to add value look up table;
  2. Create New table;
    1. Add Title and description;
    2. Create Table to assign custom values to each corresponding output reference value of the field.

See Figure A. For reference:

Figure A.jpg

Note: be aware that the values on the input code row are case sensitive.

Note 2: if a value is not configured with a Input Code/Output Code, it will be returned as blank in the integration result. Example below:

You have these two values:

emplStatus.jpg

But you only configure one of them in the Value Lookup Table:

valueLookup.jpg

The value which is not configured returns with a blank value in the result:

blank.jpg

See Also

Integration Center Guide

Keywords

Value LookUp Table, Integration Center, Custom Output Value / Code, value lookup table case sensitive, value lookup table blank, , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HXM Suite all versions