Human Capital Management Blogs by SAP
Get insider info on SAP SuccessFactors HCM suite for core HR and payroll, time and attendance, talent management, employee experience management, and more in this SAP blog.
cancel
Showing results for 
Search instead for 
Did you mean: 
NeeleshKamath
Product and Topic Expert
Product and Topic Expert

Overview


Happy new year friends. I want to begin 2021 with some exciting news especially around pressing requirements like getting sum of Child MDF records.

The following can be use cases

  1. Tuition Reimbursement – The sum of fees for various courses is usually stored as child records for a user. We would need to capture the total sum of these records in order to send total amount for reimbursement to payroll

  2. Time accruals – In some cases, customers would like to use past experience or past seniority from your old employments/companies in accrual scenarios along with current seniority in the current company.


And there are countless number of similar cases. The good news is that we can achieve this using Integration Center.

 

Steps to be followed


 

Previous experience MDF


 

Build your custom MDF. Parent MDF should have a field denoting the total field. Then link your parent with child (for which you need the sum)


In the above, we have a parent MDF cust_previous Emp which has user as external code and a total field

The Child MDF has Seniority items or previous employment records with a numerical field “number of years” in each company

You can notice that currently, the total field is empty as we currently do not have a rule function to calculate the required sum from child MDF records.

Using the Integration center we will calculate the sum of the number of years and put the result in Total Field.

Build an Integration Center Scenario (SF to SF Odata)


The source and destination entities are the same i.e Your custom MDF. In this case cust_previous_emp


Map the user field i.e external code from the MDF to External code of Destination object

In the destination field cust_Total , add a calculation as shown below

 


 

The operator used here is For Each Entity and this operation is used in cust_sernioity_items (which is nothing but the Child MDF where the numerical field “Number of Years” is present.

This will loop through each child's record and add the field value from “Number of Years”.

The total is then stored under “Total” Field of Parent MDF

Testing


Run the integration and observe the log


Go to manage data and check that for employee Jack Chen , now we have total calculated correctly.



 

Other considerations



  • Instead of storing the total amount in the same MDF, you can also choose to store in another MDF or Hris Entity like Employment Details.


 

  • Recommend to add time-based filters in the Integration Center Definition to only read recently modified or created MDF records. This will improve the performance.


 

  • Since this is not real-time, you can always schedule the Integration Job as per your needs.


 

Hope this is useful for your implementations

Thanks

Neelesh
4 Comments