Step by step guide for Setting up the Employee Central Payroll for replication of cost center master data using the SAP Master Data Integration service
I would like to share my experience of the Integration setup for cost center replication from BTP Master data integration to SAP Employee Central Payroll.
Business Purpose and Flow
Integration scenario you can create, update, and delete cost centers in SAP S/4HANA Cloud and have them transferred to Employee Central Payroll by ongoing replication. The cost center master data is continuously replicated to Employee Central Payroll using the SAP Master Data Integration service that runs on the SAP Business Technology Platform. SAP S/4HANA Cloud system, the replication to the SAP Master Data Integration service on the SAP Business Technology Platform is triggered automatically after cost centers are newly created, changed, or deleted. In Employee Central Payroll, a scheduled batch job fetches the cost center master data from the SAP Master Data Integration service on the SAP Business Technology Platform, and the cost center master data is then updated in Employee Central Payroll.
Data can flow given below graphical representation.
- Steps to create MDI instance and distribution model in MDO application for connect SF ECP.
- Configuration Steps for Setting up the Cost Center Replication from BTP MDI to SF ECP.
Steps to create MDI instance and distribution model in MDO application for connect SF ECP.
Create a Instance(ex:SF_ECP) and service key in BTP subaccount under service (Master Data Integration) plan sap-integration.
Service key(this key will need, creating destination in ECP system to connect MDI).
Login application (Master data integration(orchestration) and access tile (Manage distribution model) to create distribution model.
Reference link : MDO MDO Application
Maintain the necessary details like Model name (CC_ECP), Business Object Type (sap.odm.finance.costobject.CostCenter), Mode (Pull), Package size (1), Continuous distribution (Yes), Provider interface (MDI_LOG_COST_CENTER), Version(3.0.0) .
Provider add Destination (MDI).
Consumer add destination (created instance ex: SF_ECP)
Save and activate the Distribution Model.
Configuration Steps for Setting up the Cost Center Replication from BTP MDI to SF ECP.
Setting Up Employee Central Payroll Destination for OAuth Authentication and Cost center log
OAuth authentication information (also known as service key) from SAP Master Data Integration is available to you. This service key JSON file contains the OAuth authentication URL. This URL is used in setting up the destination for OAuth Authentication.
- Log on to Employee Central Payroll and navigate transaction SM5P to create RFC destination and select connection type(G).
Destination Name : MDI_TOKEN_DEST
Target host: https://<identityzone>.authentication.eu10.hana.ondemand.com
Path prefix: /oauth/token
Navigate to Logon & Security tab and select Basic authentication (maintain credentials) and save.
User: Client id from service key
Password: Client secret from service key
- Create another HTTP destination for connecting Employee Central Payroll to SAP Master Data Integration to replicate cost centers.
Destination Name: MDI_CC_REPL
Target host: “uri”: https://one-mds.cfapps.eu10.hana.ondemand.com
Path prefix: /v0/log
Navigate to logon & security and select do not use a user option and save.
- Maintain the two destinations are in table/view (T77SFEC_MDI_CONF) using SM30 for object type (Cost center) and save view.
- Execute the report to pull the cost centers from MDI to SF ECP system.
Report name : RP_HRSFEC_MDI_COSTCENTER_REPL
To check further replication log. Go SLG1 and enter object (HRSFEC), Sub object (MASTER_DATA_MDI), External ID (COSTCENTER)
With this we have completed the integration setup.
Thanks for reading this blog, I would like to know your thoughts in the comments!!!
Reference Scope item: 1NL Setup link