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
LookUp Table, Simple Calculated Field, Truncate, Substring, Associated Value , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To