Querying Employee Master Data and Organizational Assignments from SAP SuccessFactors Employee Central

Objective

After completing this lesson, you will be able to query employee master data and organizational assignments from Employee Central

Parameters for the Employee Master Data and Organizational Assignment Query

Employee organizational assignments are replicated together with employee master data based on the employee's job information and job relationships in Employee Central.

Recommendation: Configurable Organizational assignment

The following is the recommended approach! New configurable approach; configurable organizational assignment: In the new ECS4HCM add-on, customers can configure what data is replicated from Employee Central to reflect the organizational assignments of the employees in the SAP S/4HANA system.

Recommendation: configurable organizational assignment.

Previous Approach

Previous (nonconfigurable) approach; classical org. assignment: In the PA_SE_IN add-on, the replication of organizational assignments wasn’t configurable. The way how position relationships were created in the SAP S/4HANA system was hard-coded. All additional or deviating logic could be influenced only by implementing a Business Add-In (BAdI).

Options with configurable organizational assignment

Options with Configurable Organizational assignment

With the configurable organizational assignment, you can:

  • Configure the standard (hard coded) relations between employee position and assigned objects and also other SAP S/4HANA relations and SAP S/4HANA custom relations.
  • Map the Employee Central object IDs from standard fields and also from customer fields.
  • Fill extra fields (such as PROZT) of relations from customer fields.
  • Configure a flexible org. hierarchy.
  • Configure any kind of job relationships.
  • Copy sample content for the standard organizational assignment relations.
  • With the new configurable organizational assignment, organizational assignment BAdIs are no longer called.
  • "Reduced organizational assignment" constants to exclude relations are no longer considered. Instead, only those HRP1001 relations that are not written by the generic organizational object replication must be configured.

Customizing: Define Parameters for Employee Master Data and Org Assignment Query

The settings for the query report are configured per transformation template group through the customizing activity Define Parameters for Employee Master Data and Org. Assignment Query:

  • Restrict data replication to: Company, country/region, employee class, type of workforce.
  • Decide whether the query only transfers employments whose company and country/region assignment matches the defined company and country/region filters.
  • Include organizational assignments into the replication.
  • Prevent replication of organizational assignments for employees with specific employment statuses.
  • Specify the target system of the data replication that DRM is to monitor.
  • Specify to use the external cost center ID instead of the internal cost center ID for the mapping.
  • Enable the replication of multiple job events per day.
  • Enable the replication of multiple compensation events per day (only available for Brazil.)
  • Enable notifications being created for the Employee Central Data Replication Monitor.
  • Disable confirmations being sent to the Employee Central Data Replication Monitor.

Customizing activity: Define Parameters for Employee Master Data and Org.Assignment Query.

Configure the Parameters for the Employee Master Data and Organizational Assignment Query

Employee Master Data and Organizational Assignments Query from Employee Central

Query Program

The query program Create and Execute Employee Master Data and Org. Assignment Query (ECPAO_EE_ORG_REPL_QUERY) creates and sends a query to replicate employee master data from SAP SuccessFactors Employee Central to the SAP S/4HANA system.

Data extraction and processing – Query program

Transformation template group (mandatory):

  • The query runs for all employees specified by the selection criteria, based on the transformation template group that is entered on the selection screen and based on the configuration stored for this transformation template group.
  • Which data is queried from Employee Central depends on which transformation templates are contained in the template group.
  • The earliest transfer date of the transformation template group defines the full transmission start date (FTSD) to be used for data replication.

External employee ID (optional):

  • Entering specific IDs triggers a full load for the employees in question.
  • To improve the performance, only a maximum number of 500 employees can be selected at a time.

Change date (optional):

  • Employees whose master data (or organizational assignments if applicable) was changed after this date are queried.
  • The change date must not be more than three months in the past and must be before the last modified date. If a change date is entered, the last modified date is reset to this change date.

Enable payload logging (optional):

  • With this option, extended information is transferred to the process log in the middleware.
  • This completes the options of the query program Create and Execute Employee Master Data and Org. Assignment Query.

Processing Program: Process Employee Replication Requests

The SAP S/4HANA system creates a replication request for each employee in the staging area when a replication run contains new or updated data for this employee. Writing replication requests to the staging area triggers the event SAP_SFIOM_EE_ORGAS_RPPQ_CREATED in the SAP S/4HANA system.

Processing Program: Report ECPAO_RPRQ_EE_PROCESSING

The processing program Process Employee Replication Requests (ECPAO_RPRQ_EE_PROCESSING) is used to process replication requests from the staging area for employee master data and employee organizational assignments replicated from SAP SuccessFactors Employee Central. The processing program can be scheduled as a regular background job that is registered on the triggered event.

The processing program can also run in dialog mode to process a specific set of replication requests:

  • External employee ID: Enter external employee IDs to process the requests of one or more specific employees.
  • Include failed requests: Select this checkbox to process the latest request of employees although it has the status Failed.
  • Parallel processing: Keep the default setting to process multiple packages with replication requests in parallel.
  • Server group name: Select a server group if server groups are used for specific purposes in the system. If a specific server group is not selected, the program uses all available work processes on all server groups.
  • Sequential processing: To process packages one after the other instead of in parallel, select this option.

Query Employee Master Data and Organizational Assignments Manually from Employee Central

Employee Master Data and Organizational Assignment Query Management

Reset the status of an employee master data and organizational assignment query if it cannot be completed in a longer period of time due to errors. The reset is necessary so that the next scheduled query can start.

Context

You can set the query status manually to Failed if a query sent by the Create and Execute Employee Master Data and Org. Assignment Query (ECPAO_EE_ORG_REPL_QUERY) program remains in the Sent or In Process status for a longer period of time. Resetting the status is necessary since the next query cannot be created before the current query has one of the statuses Successful or Failed. A query remains in the Sent status if it doesn’t reach the middleware, for example, due to configuration issues. It remains in the In Process status if data can't be transferred from Employee Central. If the query remains in the Sent status, it can be resent after a five-minute timeout has passed. Since the queries are triggered and administered by the SAP S∕4HANA system, you can't use the middleware to reset the query status.

Tip

Created On shows when the query was initiated. Status Set On shows when the status of the query was set. For successful queries, the difference between these two time stamps tells you how long the replication took. Here's an example:

Example: Query Runtime

Query TypeQuery StatusStatus Set OnCreated On
Last Modified QuerySuccessful2017.04.27 07:25:382017.04.27 07:23:30

This query ran for 2 minutes and 35 seconds.

You can also delete single queries completely.

Tip

To bulk-delete queries with the type Employee-Specific Query and one of the statuses Successful or Failed, use the Delete Queries from Admin Tables for EE Master Data and Org Assignment (ECPAO_DEL_EE_ORG_QRY_ADM) program.

Procedure

  1. Go to the Reset Query Administration Table (ECPAO_RESET_QRY_ADM) transaction in your SAP S∕4HANA system.
  2. To reset the status, select an entry with the Sent or In Process status and choose Set Status to Failed.

    You can't reset the status of queries that already have the status Successful or Failed.

  3. To delete queries, select one ore more entries and choose Delete Query.

    In productive system environments, delete only queries of the Employee-Specific Query type and only if they have one of the statuses Successful or Failed. If you delete other types of queries, the last modified date is removed. This means that the next query will trigger a full load, unless you enter a change date in the Select Employees with Data Changes After section.

Log in to track your progress & complete quizzes