SAP Knowledge Base Article - Public

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


How to create a field which adds (concatenates) the values of two or more fields using a calculated field?

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


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.

NOTE: It is not possible to concatenate/append values of a single field from different rows (starting records). It is only possible to concatenate values from different fields corresponding to the same row (starting record).

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