SAP Knowledge Base Article - Public

3295116 - How to get a record in a 'one to many' relationship via Integration Center


How to get a record in a one-to-many relationship via Integration Center. 

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


Will use Pay Component Amount as example to explain how to get a record in a one-to-many relationship via Integration Center.


User has two Pay Component records:

Steps of how to:

1. Create a "Calculated Field" in the Configure Field section on Integration Center.

2. Set the start entity of Integration Center job as EmpEmployment,

3. Use the following calculation logic to get the Amount value for BASESAL_US under compInfoNav/empPayCompRecurringNav.

For Each Entity [Compensation (EmpPayCompRecurring)] 
  Choose [Pay Component (payComponent) from Compensation (EmpPayCompRecurring) relative to Compensation (EmpPayCompRecurring)] 
    When BASESAL_US 
      Field Value = [Amount (paycompvalue) from Compensation (EmpPayCompRecurring) relative to Compensation (EmpPayCompRecurring)] 
    When BASESAL_DE 
      Field Value = [Amount (paycompvalue) from Compensation (EmpPayCompRecurring) relative to Compensation (EmpPayCompRecurring)] 
      Field Value = Field Value  

Please Note:
1. 'Field Value = Field Value' is required under Otherwise section, the reason for this is unordered one-to-many records, if data you don't want to go to the second iteration, the null value will be returned. e.g.

2. In the case of one-to-one relational entities, it is more appropriate to start the calculation with the "Choose" option (e.g. EmpJob -> eventReasonNav)


Each Entity in Integration Center, One to Many, Choose When, Amount, Pay Component, EmpEmployment, Calculated Field , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , How To


SAP SuccessFactors HXM Core 2211