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.
Payscale Group value: USA/PROD/PLANT/ASSEMBLY
The logic is as follows:
Field Value = [Pay Scale Group (payScaleGroup) from Empjob]
- 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).
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