The process for replication of organizational objects from Employee Central has steps in three systems interacting with each other:
- The on-premise SAP S/4HANA system.
- The cloud-based middleware, SAP Cloud Integration.
- SAP SuccessFactors Employee Central.
Steps of the process flow:
- The query program in the SAP S/4HANA system, Create and Execute Organizational Object Replication Query (RH_SFIOM_ORG_OBJ_REPL_QUERY), calls the outbound Web service getOrganisationalObjectReplicationQuery. While calling the outbound Web service, the query program reads the query settings such as the filtering information, which you’ve defined in Customizing. It also updates the Administration of Organizational Object Query (SFIOM_QRY_ADM) table.
- The outbound Web service getOrganisationalObjectReplicationQuery sends the query to the middleware. The filter settings tell the middleware which data records are to be replicated. For example, only active records if you've defined a suitable filter.
- The middleware requests the corresponding data from Employee Central using the OData API.
- The middleware calls the inbound Web service OrganisationalObjectReplicationNotification in the SAP S/4HANA system to send a notification about the replication status.
- The inbound Web service OrganisationalObjectReplicationNotification updates the status in the query administration table.
- The middleware calls the inbound Web service OrganisationalObjectReplicationResponse in the SAP S/4HANA system to pass over the data it has received from Employee Central.
- The inbound Web service OrganisationalObjectReplicationResponse stores the data in the form of replication requests in the staging area for organizational objects. While storing the replication requests in the staging area, the SAP S/4HANA system reads the key mapping to map Employee Central keys with SAP S/4HANA keys.
- The inbound Web service OrganisationalObjectReplicationResponse updates the query administration tables and triggers the SAP_SFIOM_ORG_STRUC_RPRQ_CREATED event.
- The processing program Process Organizational Object Replication Requests (RH_SFIOM_PROC_ORG_STRUC_RPRQ) runs, which is scheduled with the SAP_SFIOM_ORG_STRUC_RPRQ_CREATED event as a start condition. The SAP S/4HANA system creates or updates corresponding infotype records in Organizational Management and updates the application log. While storing the data in the infotypes, it uses the key mapping and the field mapping settings that you've made in the Business Integration Builder.
Types of Queries Triggered by the Organizational Object Query Program
| Type | Meaning |
|---|---|
| Last Modified Query | This query requests all data that corresponds to your selection criteria and was changed after the last modified date. The last modified date is the time stamp of the last query that was created by the Create and Execute Organizational Object Replication Query (RH_SFIOM_ORG_OBJ_REPL_QUERY) program with the same selection variant. The program triggers this type of query when no specific objects are entered on the selection screen. When a change date is entered or the Initiate Full Load checkbox is selected, the program also triggers this type of query and resets the last modified date to the change date. The query shows the error message Query for EC instance <Employee Central instance>, EC entity <Employee Central entity> already sent for templ. grp <transformation template group> if the same Employee Central entity is used in more than one transformation template group. Make sure that you use the transformation template the Employee Central entity has been added to in only one transformation template group. |
| Object-Specific Query | This query requests data for specific organizational objects, whose IDs you entered on the selection screen of the Create and Execute Organizational Object Replication Query program. That is, the program triggers a full load of the objects in question. |
Query Administration Table
The Administration of Organizational Object Query (SFIOM_QRY_ADM) table stores an entry for each query being triggered by the Create and Execute Organizational Object Replication Query (RH_SFIOM_ORG_OBJ_REPL_QUERY) program.
Information Stored by Query
| Type of Information | More Info |
|---|---|
| Unique ID of the query. | Each new query triggered by the program gets a new ID. |
| ID of the transformation template group. | You enter the template group on the program selection screen. |
| Employee Central instance and Employee Central entity. | The Employee Central instance and Employee Central entity are derived from this template group. |
| Full transmission start date (FTSD). | You enter the FTSD on the program's selection screen. |
| Last modified date | This is the time stamp of the last query that was created by this program with the same selection variant. |
| Next last modified date. | This is the time stamp of the current query. With the next query, this time stamp is transferred to the last modified date and the time stamp of the new query is stored as next last modified date. |
| Query type | |
| Query status | |
| User | The name of the user who ran the query program manually or scheduled it to be run in the background. |
| Time stamp of the last program run. | The time when the program was executed manually or has last run in the background. |
Query Selection Parameters Table
The Selection Parameters for Organizational Object Query (SFIOM_QRY_ADMDT) table stores the parameters that you entered on the selection screen of the Create and Execute Organizational Object Replication Query program. For example, the object IDs or the change date you specified (if applicable), or whether the Enable Payload Logging checkbox was selected.