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

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