SAP Knowledge Base Article - Public

2985494 - Integration Center: Multiple table joins using navigation fields


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."


  • SAP SuccessFactors HXM 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


1. When creating an IC job select the root entity:

2. Only one object can be selected as the starting entity


  1. Once the starting entity have been selected we can navigate between the objects to join table
  2. Let join the User table with data from the Empjob table
  3. Select Add field in IC then navigate to the field required to join the tables:


integration center, join tables, query multiple tables, navigation , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem


SAP SuccessFactors HXM Suite all versions