Technical Articles

Megha Aggarwal

April 7, 2020 13 minute read

Complete configurations steps done in SPRO(SAP ERP HCM) for integrating employee master data from SuccessFactors EC to SAP ERP HCM via CPI.

I was working on project : Replicating Employee Master Data from Employee Central to SAP ERP HCM via CPI.

For this purpose I have used the Standard package available in CPI named: SAP SuccessFactors Employee Central to ERP Employee and Organizational Data. You can simply find them in discovery tab of CPI, And particularly for Employee Master data replication we have to use the Artifact 1 available in this package named: SAP SuccessFactors Employee Central to ERP Employee Data and Organizational Assignment.

For complete configuration step for Replicating Employee Master Data from Employee Central to SAP ERP HCM via CPI https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US you can follow this configuration guide. I have also taken reference from this configuration guide.

Now I am telling You the common steps which needs to be followed while replicating employee master data from EC to ERP Later in this blog post I will tell you complete configuration steps which is needed to be done in SPRO(SAP ERP HCM) system for the same.

For Replicating Employee Master Data from EC To SAP ERP HCM We have to follow the following steps:

Prepare the system connectivity of SAP ERP HCM System We need to do the Configurations in Transaction SOAMANAGER for activating inbound and outbound web services.(Generally configurations are done in web service configurations and Simplified Web Service Configuration).
Install all the root certificates in Transaction STRUST.
In CPI in Monitoring tab in keystore install all security related certificates and in Security materal tab add all the user credentials for SAP ERP HCM system as well as for SuccessFactors system.
Open the artifact and do all the configurations like adding the endpoint Urls ,adding credentials and all the other required information.
Open SuccessFactors and in Manage permission roles ,give access to all the required permissions necessary for replication of Employee master Data from the system.
In SuccessFactors Create replication Target system object.
In SAP ERP HCM system do all the customizing activity in Transaction SPRO.(In details discussed below )
Run the Query( ECPAO_EE_ORG_REPL_QUERY) in Transaction SE38 if connectivity and everything goes well you can see the logs in transaction SLG1 with the required data otherwise you can see the error logs.

All these things are not discussed in details, I will post more blog posts discussing these steps in details.

This Blog post is Particularly about Configurations which are done in SPRO(Integration perspective) T-Code which i think is most essential part in this whole configuration and most of us find this part little difficult and challenging.

Configuration Steps done in Transaction SPRO:

STEP 1: How and where to reach the path where configurations are done.

a.In SAP Easy Access Screen type Transaction SPRO

b. Navigate to path SAP Reference IMG > SAP Customizing Implementation Guide >Personnal Management> Integration with SuccessFactors Employee Central >Business Integration Builder > Basic Settings and Employee Data Integration.

Most of the configuration are done in Basic settings and Employee Data Integration.

STEP 2: System prepratory Steps:

1. Use Decoupled and Not Decoupled IT Framework

This is the system prepratory step.

a. Go to Transaction SPRO > SAP customizing implementation guide> Personnel Management > Personnel Administration >Customizing Procedures > Infotypes > Infotypes in Detached Infotype Framework >Use Decoupled and Not Decoupled IT Framework.

b. In Group Column add CCURE
c. In Sem. abbr. add PC_UI
d. In Value abbr. Set value to x.
e.In Description add anything relatable (for eg. UI Main Switch)
Reference Resource: https://help.sap.com/viewer/9893854eff274a77b29fc02d3b19b116/1911/en-US/7b686d018ad244d9a957cbf6f108ec1d.html .

2. Activating BIB(Bisuness Integration Builder)
If we want to use this integration it is essential to activate Business Integration Builder Mode

In your SAP ERP HCM system, go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder > Basic Settings > Maintain the Constant Values.
In the Constant Name field choose. Activate BIB for EC to ERP Employee Replication.
In the Constant Value field, enter X.

Reference Resource: https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US/b1013e17774944158e13ab6dcaf15412.html

3: Allowing replication for payroll areas(optional step)

1. In your SAP ERP HCM system, go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder > Basic Settings > Maintain the Constant Values
2. In the Constant Name field choose: EC to ERP (BIB / Non-BIB): Allow Replic. in Correction Phase
3. In the Constant Value field, enter X.
Reference Resource: https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US/4102505ddd0546618e307a6dc2cf4f15.html

STEP 3:This step shows setting up your employee Central Instance

In your SAP ERP HCM system, go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder > Basic Settings >Specify Employee Central Instance ID

2. Enter the ID of your Employee Central Instance and Description.

Reference Resource : https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US/3f1bfeb350d946a18cb6d01324e8a877.html

STEP 4:Importing Metadata from Employee Central

First, export the metadata file from the Employee Central System and save it to your desktop.
In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central>Business Integration Builder > Basic Settings > Import Meta data from from Employee Central > Choose Import Metadata for Web Service-Based Data Transfer from Employee Central

3. a. Enter your EC Instance

b.Select the EC Entities for which you want to update the MetaData. You can select multiple entries at once also.

c.Select the path of your EC MetaData file from your computer.

In Action Type you can Select the various options:
a.Test Run : To sample run this activity without affecting the Existing MetaData.

b. To update the currently available MetaData.

c. To delete the MetaData.

Note: List of Mandatory Templates and infotypes Required for a Successful Replication of Employee Master Data:(web service based)

WS_2 (Biographical Info Template) WS_3 (Employment Info Template)
WS_4 (Job Info Template)
WS_5 (Personal Info Template)
WS_11(Compensation Template)
Mandatory SAP ERP Infotypes: IT0000(Events and Event reasons) IT0001( organizational assignments) IT0002(personal information)

Reference Resource : https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US/e5e1e49e32bb4151ac391002d03b5b89.html

STEP 5: In this step we will do all the configuration which is to be done to define Value mapping.

This step maps the field or values of EC Employee Central keys to corresponding keys or values of SAP ERP HCM system. For Example : In EC lets say one Divsion is Highway and in SAP ERP HCM key 0000 is assigned to Division Highway so here in this step we define all the steps to map these keys.

This step replaces the Employee Central field values or keys to corresponding SAP ERP HCM keys.

In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder > Basic Settings >Define Value Mapping

A. For using Picklist Value From EC you can import the picklist file from your EC System to your SAP ERP HCM System.

1. First Export Picklist from Employee Central. 2. In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder > Basic Settings >Define Value Mapping> Import Picklist from Employee Central.

a. Select your EC Instance.
b. choose your EC Picklist File from your local computer.

c. Enter the locale of the picklist labels that you want to import.
d. Select the Update Picklist checkbox .
e. Execute it and picklist will be uploaded.

B. Defining Value Mapping Entities:

In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder > Basic Settings >Define Value Mapping>Defining Value Mapping Entities.
You can copy the sample content for your convenience.

You will get all standard entries and you can modify and adjust according to the needs.

CREATING VALUE MAPPING ENTITIES FROM SCRATCH:

Enter Name and description of value mapping Entity.
In value mapping Type Enter weather it is foundation object or picklist lable, option id and so on.
To use the picklist values that you have imported to SAP ERP HCM from EC you can select from the EC Picklist Id field dropdown.

4. To use available input help values from an infotype field in the value mapping details, specify the SAP ERP HCM value help.

This field is a combination of technical name of the infotype table (such as PA0002) and the technical name of the infotype field (such as GESCH), connected with a hyphen (as in PA0002-GESCH).

3. Defining Value Mapping Details:

The value mapping details maps SAP ERP HCM values or keys to the corresponding Employee Central values(keys).

In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder > Basic Settings >Define Value Mapping>Defining Value Mapping Details.
Enter your EC Instance and Value mapping entity you defined in Define value mapping step.

3.Map SAP ERP HCM keys and the corresponding Employee Central keys.

If the value mapping entity has a picklist ID and a SAP ERP HCM value help assigned, you can select suitable picklist values in the EC Key field and corresponding input help values in the ERP Key field.

NOTE: Ask your HCM and EC Consultant to provide you with the list of SAP ERP HCM Keys and corresponding EC keys.

HCM Keys you can get from dropdown and EC Keys if you used picklist and picklist is available you can see it in dropdown values otherwise you can add keys as provided by your consultant.

We will be using these value mapping entities further in our field mapping.
Reference Resources: https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US/cc35c9ed784645168482b147dc423f64.html

STEP 6:IN THIS STEP WE WILL BE DOING ALL THE FIELD MAPPING:

1. Creating a Transformation Template Group :

A template group bundles all field mappings that you want to use when transferring data from Employee Central to SAP ERP HCM.

To define template groups, In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder >Employee Data Integration > Define Field Mapping for Employee Data.

2. Go to Define Transformation template group option

3. Enter Name and Description of your transformation template group.
4. In basic Settings:
EC Instance: Enter your EC Instance
Communication Channel: Web Service Transfer
Sample Content: From the dropdown choose your suitable Sample Content for example:EE_WS_2 in above.
5. In ERP/EC Integration :

Define an earliest transfer date:
You can specify this date to start employee data replication at a specific point in time. This prevents the complete history of data records being replicated from Employee Central to SAP ERP HCM. If you define an earliest transfer date for a transformation template group, this date influences effective-dated and non-effective dated templates in different ways.

Check the Enable for Delta Replication Checkbox if you want to use this integration to reflect Delta Changes.

Reference Resource: https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US/05df545384f840f9a87a342d6c0ea70d.html

2. Defining Templates in Template Group:

You can map fields from the transformation template to fields from the assigned Employee Central entity.

To define template groups, In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder >Employee Data Integration > Define Field Mapping for Employee Data.
Go to Transformation Template option.

If you want to add the transformation template Go to New Entries you will get the below screen

In this screen add the name of your transformation template like Biographical_info, compensation .

Check the Is Active check box

Select the corresponding EC Entity like WS_4 for JOB_INFO etc.

Communication Channel and Entity Name in EC will reflect itself.

Reference Resource: https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US/fcfa2bebb2f34434b56fcc7bf3739a51.html

STEP 7: 1. Defining Field Mapping for Employee Data

To define template groups, In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder >Employee Data Integration > Define Field Mapping for Employee Data.
Go to Transformation template and select transformation template for which you want to create the primary field mapping.

An easy way to to define your field mapping is to copy the sample content.

After copying sample content screen will look like this. You will get most of the mappings after copying the sample content and also you can adjust it according to your requirements.

3. To create New entries or custom entries in Primary mapping field Go to New Entries Option.

You will get this screen after you choose New Entries .

1. From the EC Field Dropdown choose the EC field you want to create field mapping for

2. In Mapping Mode choose Infotype mapping.

In Infotype Field Select the infotype For example : 0000 for actions ; 0001 for organizational assignments etc.

3. If your field has subtype then select subtype.

4. In Infotype Field Enter the technical name of the field.

5. If any secondary mapping is associated with your Primary Mapping then enter the value in linking field.

8. Leave the Preconfigured Entity blank.

9. In value mapping Entity option choose the related Value mapping entity that you defined in previous step to use the value mapping keys.

After filling it will look like this screen.

Reference Resource: https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US/f8be1e40af184514a1299fab4ea08552.html

STEP 8: For filtering or ignoring the unwanted infotype and subtype you can do it from .Filtering of Infotype and Subtype for Employee Central

This is optional step

To define template groups, In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder >Employee Data Integration > Define Filtering of Infotype and Subtype for Employee Central
Enter the infotype field.
Enter the subtype.
Enter the country grouping.
Enter the work-force category.
Reference Resource: https://help.sap.com/viewer/a7f164924edd4dfe817b7bdc2fc4927a/2005/en-US/df6973f9c50948369ab5dcbfa902a869.html
STEP 9: Defining Parameters for the Employee Master Data and Organizational Assignment Query

This is important step as here we define the parameters for querying the program(ECPAO_EE_ORG_REPL_QUERY) Go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central >Business Integration Builder > Employee Data Integration > Define Parameters for Employee Master Data and Org. Assignment Query

TRANSFORMATION TEMPLATE GROUP: Select your template group.This is a mandatory step.
COMPANY: By Entering the company name you can Restrict the replication to employees who have a job in a specific company.(Optional)
COUNTRY: By Entering the Country name you can Restrict the replication to employees who have a job in a specific country specified in their Job Information in Employee Central.(Optional)
MATCHING: Data from EC is transferred for only those employees whose Country and Company is mentioned in previous filtering step.(Optional)
EMPLOYEE CLASS:You can restrict the replication to employees who have a job of a specific employee class(optional)
TYPE OF WORKFORCE: Decide for which group of your workforce data is to be replicated.This is mandatory step.
REPLICATION ORGANIZATIONAL ASSIGNMENTS CHECKBOX: Include organizational assignments into the replication or not by checking the checkbox.(optional)
EXCLUDING ORG. ASSIGNMENT:Excluding replication of organizational assignments for employees with specific employment statuses.(Optional)
TARGET SYSTEM: Enter the external code of the Replication Target System object that you created in Employee Central ,This is mandatory step.use Transaction S44C to get detail of your replication target system.
USE EXTERNAL ID:To use OBJID(External Id) field while replicating cost centers mark this checkbox.(Optional).
MULTIPLE JOB EVENTS: To Enable replication of multiple job events per day mark this checkbox.(Optional)
ENABLE NOTIFICATION CHECKBOX: If you want to Enable notifications to create in Employee Central Data Replication Monitor mark this checkbox.(Optional)
DISABLE CONFIRMATIONS: If you want to disable confirmations for data being transferred from EC check this checkbox(Optional)

Reference Resource: https://apps.support.sap.com/sap/support/knowledge/public/en/2754595

CONCLUSION: This is how one can do complete configuration in SPRO for replicating employee master data from EC To SAP ERP HCM. Some configurations can be changed according to your organization structure and values. Hope this blog is helpful for all.

23 Comments

You must be Logged on to comment or reply to a post.

Tamizamuthan Vedachalam

April 8, 2020 at 2:17 am

Excellent! Really Helpful

Ramesh Jakkula

April 8, 2020 at 4:21 am

Thanks for the great article.

kratika varshney

April 8, 2020 at 6:29 am

Nice Blog..

Neeraj Gupta

April 8, 2020 at 12:56 pm

Very useful indeed, waiting for your next blog...

Megha Aggarwal

Blog Post Author

April 8, 2020 at 4:00 pm

Thanks, will be writing soon.

Neeraj Gupta

May 15, 2020 at 5:52 am

Hi Megha,

We are integrating EC with SAP HANA via CPI, but we have limitation to go without cloud connector could you please help me to setup middle-ware.

Thanks in Advance!!!

Rajesh Narware

April 8, 2020 at 8:27 pm

very helpful. Excellent

Girija Shankar Behera

April 9, 2020 at 5:31 am

perfectly elaborated ??

to add on the ftsd date, it can be used to retain history of the erp infotype records .

i.e the records before the ftsd in sap erp wont be touched by bib integration.

Megha Aggarwal

Blog Post Author

April 9, 2020 at 6:08 am

Yes you are right, for betterment we should take our Go-Live date as ftsd (Full transmission start date).

Syambabu Allu

April 9, 2020 at 5:20 pm

Indeed Blog.Thanks for sharing!

Thank you,

Syam

Luciano Nascimento

April 14, 2020 at 12:53 pm

great text!

thank you so much!

Santosh Shivane

June 18, 2020 at 8:06 am

Hi Megha,

It's very helpful information for BIB Config.

Thanks

Santosh Shivane

Rushikesh Hande

June 21, 2020 at 2:37 pm

Awesome. Very useful indeed. Thank you.

AKHILESH KUMAR JAIN

July 16, 2020 at 7:57 am

Hi Megha,

very useful information.

thanks for sharing it.

Regards,

Akhilesh

Ricardo Soares

July 27, 2020 at 11:12 pm

Hi, for the flow where SFSF EC is master and SAP HCM is slave, how EC employee number works with and SAP HCM employee number. Do we have mapping table or create custom MDF to keep SAP HCM source system ID.

Meantime, great blog.

Thanks RS

Fabiana Gamen

January 21, 2021 at 3:17 pm

Hi! I'm trying to active the personnel number assignment by external assignment from Success Factors. Following the manual steps I have to:

-To include the assignment ID during the migration process, you need to enable the switch ERP to ER/EC to ERP (BIB): Activate Assignment ID External in the view V_ECPAO_CONSTANT

But my problem its that In this table I don't have this option available in the picklist to active

(Attaching screenshot)

Thank you for your help!!!

ramya t thota

March 2, 2021 at 3:35 pm

Hi Megha,

Thank you for sharing the post, Its very useful.

I am handling the same scenario in my current project in SAP S/4 HANA. Integration with SuccessFactors Employee Central is not available under Personnel Management path to do the Configuration for Business Integration Builder. Only Integration with SuccessFactors Employee Central Payroll is available in the system. Can some one please guide me on this. I am attaching the S/4 HANA screenshot for your reference.

Aji Hussain

March 2, 2021 at 3:58 pm

Hi Megha,

Thanks for sharing the post for EC - HCM BIB, transformation set up, ..!!

@All,

Any suggestion for position replication with Employee data replication.

We are following different position IDs in EC & HCM, expecting a replication using EC POS & HCM POS separately.

Can we manage this with Employee data replication only or any other workaround

Or need to enable Org data + assignment & replicate only position and update Org data Kmap

Thanks ...

baladeba behera

May 7, 2021 at 4:53 pm

Thanks sharing .....how to handle International Transfer Scenarios in Minimaster...

ramya t thota

May 14, 2021 at 1:49 pm

Hi Every one,

We are implementing Replication of HR Mini master( Org Structure and Emp master data) from SF- EC to S/4 HANA via CPI Interface.
I have done required Config in S/4 HANA till " Import metadata for file based Data Transfer from EC" step mentioned in below screenshot.
But When I am trying to import EC Picklist (CSV file ) provided by our SF consultant into S/4 HANA, I am facing error as " Upload Picklist File in proper Format". I have also tried with other picklists which were imported successfully in "Import metadata for file based Data Transfer from EC "step for testing purpose. But still facing the same issue. Can you please guide me how to resolve the issue.

Yanqing wang

June 26, 2022 at 7:30 am

Hi All,

Can any body help about the question as below: multple countries in one SAP system.

Shall we have one template group or several template group to replicate mater data from EC to SAP?

There are some challenges for the data which have several subtypes and country specific settings, because it's not possbile to have the infotype cloning as well as country specific settings.

Ross

VENKATA RATNA KUMAR JADA

August 6, 2022 at 8:29 am

Nice Blog Ramya Thanks for sharing.

SGIT Team

September 1, 2022 at 3:16 am

Very useful. Thank you..

Thilina Manaram

Technical Articles

Complete configurations steps done in SPRO(SAP ERP HCM) for integrating employee master data from SuccessFactors EC to SAP ERP HCM via CPI.

Assigned Tags