Symptom
Your ERP replication is currently running the replication program ECPAO_EE_ORG_REPL_QUERY using delta and you need to replicate some employees whose master data (or organizational assignments if applicable) was changed after a specific date.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP SuccessFactors HCM Suite
- Employee Master Data and Organizational Assignment Replication
- ERP On-Premise
Resolution
On SF side, you can do the following:
- Go to Data Replication Monitor
- Select the employee you want to replicate
- Click on Send button
This will make the employee be picked up by the next replication query that reaches SF.
On the ERP side you have some other options through SE38 > ECPAO_EE_ORG_REPL_QUERY.
You can specify the Employee ID of the employees you want to replicate, using the External Employee ID field:
You can also use the Change Date field. This field will change the "last_modified_on" parameter of the query. Let's say you put value 13.10.2020:
This will send the below Compound Employee query to SF:
<queryString>
SELECT address_information,alternative_cost_distribution,associated_employee_information,compensation_information,deduction_recurring,dependent_information,email_information,employment_information,global_assignment_information,job_information,national_id_card,paycompensation_recurring,person,personal_information,phone_information from CompoundEmployee WHERE replicationTargetSystem = 'S4ACLNT200' AND replicationContentType IN ('EMPLOYEE_MASTER_DATA','EMPLOYEE_ORG_ASSIGNMENT') AND last_modified_on >= to_datetime('2020-10-13T00:00:00Z') AND company IN ('1710') AND selectFromDate = to_date('2019-01-01','yyyy-MM-dd') AND isContingentWorker IN ('0','1') AND effective_end_date >= to_date('2019-01-01') AND hiringNotCompleted = 'false
</queryString>
This will return all employees that were changed since 2020-10-13.
Note: The Change Date value must not be more than three months in the past.
See Also
Keywords
ECPAO_EE_ORG_REPL_QUERY, bib, erp, replication, employee, master data, org assignment, reset, last modified, last_modified_on, ECPAO_QRY_ADM, on prem, on-prem, premise, erp, ecc, sap, sf, successfactors, force, sync, manual, manually , query , KBA , LOD-SF-INT-DRM , Data Replication Monitor , LOD-SF-INT , Integrations , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , LOD-SF-INT-CPI-ERP , Standard SF to SAP ERP or S/4HANA Integration using CPI , How To
Product
Attachments
Pasted image.png |
Pasted image.png |