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

Hello Everyone,

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.

Process%20Flow

Process Flow

Process Steps:

  1. Steps to create MDI instance and distribution model in MDO application for connect SF ECP.
  2. 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.

MDI Instance creation

Instances

MDI%20Instances

MDI Instances

Service key(this key will need, creating destination in ECP system to connect MDI).

Service%20Key

Service Key

Login application (Master data integration(orchestration) and access tile (Manage distribution model) to create distribution model.

Reference link  : MDO MDO Application

Distribution%20Models

Distribution Models

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).

Model%20Provider%20details

Model Provider details

Consumer add destination (created instance ex: SF_ECP)

Model%20Consumer

Model Consumer

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.

  1. 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

OAuth%20Token%20Destination

OAuth Token Destination

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

OAuth%20Token%20Destination2

OAuth Token Destination2

  1. 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

Cost%20center%20replication%20Destination

Cost center replication Destination

Navigate to logon & security and select do not use a user option and save.

Cost center replication Destination2

  1. Maintain the two destinations are in table/view (T77SFEC_MDI_CONF) using SM30 for object type (Cost center) and save view.

Maintain%20Destinations%20in%20table/view

Maintain Destinations in table/view

  1. Execute the report to pull the cost centers from MDI to SF ECP system.

Report name : RP_HRSFEC_MDI_COSTCENTER_REPL

Report%20for%20CC%20replication

Report for CC replication

To check further replication log. Go SLG1 and enter object (HRSFEC), Sub object (MASTER_DATA_MDI), External ID (COSTCENTER)

SLG1%20Log

SLG1 Log

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

Thank you,

Syam