SAP Knowledge Base Article - Public

2873912 - Integration Center - How to use a LookUp table with a Simple Calculated Field

Symptom

  • Sample Use Case
    Under 'userId' field of SFOdata.User entity, you need to differentiate the Employee into groups depending on the configuration of their 'userId' field.

    Those starting with Numbers 0-9 will be set to Category A

    Those starting with A-Z or a-z will be set to Category B

  • Sample Usage (not working): You create a calculation field and try to assign a lookup table on the field value calculation. But the result does not take reference with the values defined in the LookUp Table. See below where the Field Value is not being changed wrt to values entered in a lookup Table.

2.jpg

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

The reason for the 1st usage scenario not working is expected behavior as Value LookUp/LookUp table does not work on 'Field Values'. It works only on "Associated Value".

Resolution

Create Simple Calculation to define as the fields Associated Value and reference this with a LookUp Table.

Step 1 : In the Use case, we need to capture the 1st character of username either by operation 'Truncate Left' of By 'Substring' calculation. See below

3.jpg

See Result :

- 80926 userId is assigned with '8' (Numeric 0-9) Value

- budaPestTesting userId is assigned with 'b' (A-z, a-z) Value

4.jpg

Step 2 : Assign a LookUp Table and associate to the simple calculated field from step 1, either by uploading a csv file or creating (See 2594749 - How to use Value Look up table in integration Center for more on LookUp Table).

lookup.jpg

See Result :

UserId 80926 - Assigned with Category A

UserId budaPestTesting - Assigned with Category B

6.JPG

See Also

Integration Center Guide Link

2594749 - How to use Value Look up table in integration Center 

Keywords

  LookUp Table, Simple Calculated Field, Truncate, Substring, Associated Value   , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HXM Suite all versions