SAP Knowledge Base Article - Public

2985494 - Integration Center: Multiple table joins using navigation fields

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

  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:

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