SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

 SAP SuccessFactors HCM Suite

Resolution

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:

USA/PROD/PLANT/ASSEMBLY00000100258

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]

kbaconcatenate.PNG

 

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

Keywords

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

Product

SAP SuccessFactors HXM Suite all versions