SAP Knowledge Base Article - Public

2892300 - How to add a value between two fields in Calculated field in Integration Center


How to add a value between two fields in Calculated filter?

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 HCM Suite


This can be done through adding a calculated field in Integration center.

Let's say the business requirement is to combine two fields  "Pay Scale Group" and "User ID"  in one field and add a value between the mentioned fields.

Example value:

Payscale Group value: USA/PROD/PLANT/ASSEMBLY

Userid: 100258

Required result:


The logic is as follows:

    1. Field Value = [Pay Scale Group (payScaleGroup) from Empjob]
    2. Concatenate/Append "00000000"
    3. Concatenate/Append [User ID (userId) from Empjob]



What this did was to combine the PayscaleGroup field + added the string 0000 + userID field.

See Also

 2597306 - How to Add Leading Zeros to a String Field to bring the employees User ID username up to a required length


Add string between two fields, How-To , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-INC , Integration Center , Problem


SAP SuccessFactors HXM Suite all versions