Employee master data synchronization using Compound Employee API
In this blog, I will briefly explain EC Compound Employee API and how it can be used to synchronize employee master data with on-demand or on-premise applications.
Compound Employee API Overview
Compound Employee API, a SOAP-based web service inside EC, is commonly used to synchronize employee master data between Employee Central and other on-demand or on-premise applications. Replication of employee master data by calling Compound Employee API happens synchronously, which means that the response is immediately returned. The Compound Employee API response is structured very similar to the data structures in Employee Central. It returns data about new employees and about changes of employee data.
How to define the consumer structure interface file gives an overview about the options for the generation of a consumer interface structure file.
Compound Employee API supports full transmission and delta transmission. In full transmission the API replicates the complete employee data including future and historic data, independently if the data was changed since the last replication or not. Contrarily, in delta transmission (effective-dated or period-based delta transmission; see also Delta transmission of Compound Employee API) the API only returns elements, which have been created, changed or deleted since the last replication.
The Compound Employee API supports two forms of extensibility, an overview about these is given in Compound Employee API: Extensibility.
Employee master data synchronization
To setup the data synchronization and to initially load the employee master data from Employee Central into the consuming system, first a full-transmission query of Compound Employee API without any selection parameter can be triggered. With this first synchronization, all employee data including historical data are then sent to consuming systems.
Afterwards only changed employees shall be sent to the consumers to update the employee master data on consuming side accordingly. This can be achieved by replicating changes for employees that happened since the last synchronization by using the Compound Employee API in
- full transmission mode using select parameter ‘last_modified_on’ to identify changed employees. However, the response of the full transmission contains the complete historical data of the employees and the consumer has to figure out, which data of the employees has changed.
- delta transmission to identify changed data for changed employees using select parameter ‘last_modified_on’ and /or a given period for not effective-dated delta transmission. In the Compound Employee API response for each segment it is indicated via an action code how the data change needs to be processed on consumer side.
You can find further info under in http://help.sap.com/hr_api/ or about Compound Employee API: http://service.sap.com/~sapidb/002007974700000283532014E and http://service.sap.com/~sapidb/012002523100008807102016E
Good blog to start with Mario!
Thanks Siddharth
Hi Mario ,
In middleware (HCI) we have FTSD (Full Transmission start date), when this is set, HCI will pull only those records from EC which are valid on or after this date.
Regards,
Manu
FTSD is set on HCI side and also available in ERP side
Last modified data also in on HCI side! its available in the guide. Please refer it, FTSD is the date from which records would be replicated before it would be cut off even though last modified goes prior to FTSD
Extremely helpful. Thanks for this blog.
Here are the new link to the Compound Employee API documentation:
Full Transmission: https://help.sap.com/viewer/5bb9a5b997a843c88e769a105e4af4d4/latest/en-US
Delta Transmission: https://help.sap.com/viewer/9b997ab9e29e4ffc9859688b076d91de/latest/en-US
Hello Qendrim,
Can you please point us the new documentation available for Compound employee Query. Above links are no more working.
I am trying to find the more information of return structure and different code values for fields such as Employment Status.
Regards,
Rohit