Symptom
User needs to join tables in integration center(IC).
"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
- Integration Centre
Reproducing the Issue
1. User has created a job in IC
2. They want to join multiple tables using navigation
3. They need direction on how to join tables via navigations
Cause
1. When creating an IC job select the root entity:
2. Only one object can be selected as the starting entity
Resolution
- Once the starting entity have been selected we can navigate between the objects to join table
- Let join the User table with data from the Empjob table
- Select Add field in IC then navigate to the field required to join the tables:
Keywords
integration center, join tables, query multiple tables, navigation , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem
Product
SAP SuccessFactors HCM Suite all versions