Non-Recurring Deduction/Payments & Recurring Deduction in EC for replication
In this blog post, we will learn about the Replication of Recurring Deductions, Non-Recurring Payments and Deductions from SuccessFactors Employee Central to SAP ERP HCM infotypes IT0014 and IT0015.
To achieve the same, we need to make sure that the Middleware Content for Employee Master Data and Organizational Assignment Replication is deployed in CPI. The package in SAP CPI named: SAP SuccessFactors Employee Central to ERP Employee and Organizational Data that contained integration flow/flows:
- SAP SuccessFactors Employee Central to ERP Employee Data and Organizational Assignment
- SAP SuccessFactors Employee Central to ERP Generic Object
should be configured and deployed by the Integration team.
Configurations required in SAP ERP HCM:
LogIn to SAP ERP HCM System
Open T-Code SPRO, go to SAP Reference IMG > Personnel Management > Integration with SuccesFactors Employee Central > Business Integration Builder > Employee Data Integration >Define Additional Employee Central Entities for Employee Data.
Go to transaction code SM30 and open the view V_ECPAO_ECTMPL
Click Edit and New Entry.
- For Non-Recurring Payments, the next steps to be done are:
Create an entity EmpPayCompNonRecurring with proper entity name and CE API segment for One Time Payments/ Spot Bonus mapped to 0015 infotype.
Create an entity OneTimeDeduction with proper entity name and CE API segment for One Time Deductions/ Non-Recurring Deductions mapped to 0015 infotype.
3. For Recurring Deductions, the next steps to be done are:
There are some technical constraints in ERP side, while defining standard EC template in ERP for Recurring Deduction portlet due to which support of same is provided using custom template.
Create a new custom entity for parent node of ‘RecurringDeduction’ portlet with proper entity name and CE API segment for Recurring Deductions mapped to 0014 infotype.
3.1. For RecurringDeductionItem, the steps are as follows:
Create another entity for child node ‘RecurringDeductionItem‘ as following:
Once entities are ready, run the report ECPAO_ECTMPL_METADATA_WRITER and import the metadata from employee central using XML file for the entities created above.Below are the screenshots for one entity and same has to be done for all the entities created above.
Once metadata is posted for all the entities, Select Define Field Mapping for Employee Data to create a template groups for Non-Recurring Payments and Deductions and Recurring Deductions.
- For Non-Recurring Payments, the steps are as following:
Create a Transformation template for Non-Recurring Payments/ One Time Payments/Spot Bonus.
The primary mapping is as followed:.
To define the pay components/wage types for which One Time Payments/ Spot Bonus is paid, Move to Define Infotypes and Subtypes for Cloning Transformation Templates by selecting the Template Group and Transformation Template of One Time Payments.
Click on New Entries and make the entries of pay components for 0015 infotype as shown below:
2. For Non-Recurring Deductions, the steps are as following:
Create a Transformation template for Non-Recurring Deductions/ One Time Deduction:
Move to Define Infotypes and Subtypes for Cloning Transformation Templates by selecting the Template Group and Transformation Template of One Time Deductions as created above.
Click on New Entries and make the entries of pay components of deductions for 0015 infotype as shown below:
3. For Recurring Deductions, the steps are as following:
Create a Transformation template for Recurring Deductions with custom entity.
The primary mapping for Recurring Deductions are:
The primary mapping for Recurring Deduction Items are:
In order to replicate deduction pay components/wage type only for IT0014 recurring deduction in ERP. For the template created for IT0008, IT0014(Recurring), clear paycomponent to LGA01/LGART mapping, by using value conversion to clear the value. For this either replace with patterns can be used or the new check and replace operator can be used.
Move to Define Infotypes and Subtypes for Cloning Transformation Templates by selecting the Template Group and Transformation Template of Recurring Deduction as created above.
Click on New Entries and make the entries of pay components of recurring deductions template for 0014 infotype as shown below:
Note: This will avoid the warning message Subtype field LGART not mapped for infotype 0014 that occurs while replication.
Click on New Entries and make the entries of pay components of recurring deduction items template for 0014 infotype as shown below:
Note: The middleware exception is seen when the ce-api segment “deduction_recurring_item” is used. To eliminate the exception kindly add the custom entity and its CE API segment in the table: V_ECPAO_CEAPI_EX as following:
This is how to do configuration in SPRO for replicating Non-Recurring Payments and Non-Recurring Deductions and Recurring Deductions. Hope this blog is helpful.
Good Read. Easy to understand.
This blog is based on the understanding that the primary building blocks for integration are already in place.
Thank you very much for this article... This is very useful.
Hi Srishti Gupta.
I want to say thank you! I found here an answer that I was looking for regarding the infotype 0015.
Hello Srishti Gupta,
Great BLOG! Was very helpful. I have set this up and it is working for the employee recurring deductions to replicate down to SAP infotype 0014. But how do I get the employer costs?
For example, an employee medical deduction might be $100/month. But there is also and employer cost for medical which might be $300/month. Both of these are needed in on-premise payroll.
HI Shrishti Gupta,
for above details if we don't run the Meta data writer program replication will not pick the data,
can we create the fields as per IT0014 info type , how we update the data manually
Very nice explanation!
Question, how do configure the additional cost centre?
I added the cost centre to non-recurring deductions and Functional area.
I downloaded the metadata and imported it and i can see the functional area now, but what i dont know is how to do the Cost centre and functional area.