SAP Knowledge Base Article - Public

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


  • 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.


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


SAP Successfactors HXM Suite

  • Integration Center


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".


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


See Result :

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

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


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).


See Result :

UserId 80926 - Assigned with Category A

UserId budaPestTesting - Assigned with Category B


See Also

Integration Center Guide Link

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


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


SAP SuccessFactors HXM Suite all versions