2892300 - How to add a value between two fields using a calculated field - 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
• Integration Center

This can be done by adding a calculated field in Integration Center.

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

Example value:

• User ID: 103230
• Cost Center: US10_M6

Required result:

"103230/US10_M6"

Calculated field logic:

The logic will stay as follows:

1. Field Value = [User ID (userId) from Job Information (EmpJob)]
2. Concatenate/Append '/'
3. Concatenate/Append [Cost Center (costCenter) from Job Information (EmpJob)] 

So it will combine all the values (user ID + / + Cost Center) into a single value.

Note: it's not possible to concatenate/append the values of different records, for example the User ID of two different employees. It is only possible to concatenate values from different fields corresponding to the same record, just as this calculated field above did.

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

concatenate, add, together, values, different, calculated field, logic, append , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , How To