Active Employee, Department and Manager Data Feed to External Systems (LMS, Portal, Help Desk)
Short answer: An interface that regularly sends active employees with org unit, position, manager, cost center and email to external systems such as the learning management system, the employee portal and the help desk. Each target system gets its own field mapping; only changes are sent and a transfer report is produced.
- Estimated effort
- M · 8–12 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
The standard system offers the interface toolbox (PU12) and ALE distribution for employee data, but they are designed for payroll files or SAP-to-SAP distribution. There is no lightweight feed that sends active employees with manager and department names, with the field names the target system expects and only with changes; hires and leavers reach external systems manually or late.
Who uses it? HR information systems, learning and development teams, IT help desk and integration teams.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| PA0000HR Master Record: Infotype 0000 (Actions) | Employment status and actions | Read | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Org unit, position, cost center, company code | Read | ECC + S/4 |
| PA0002HR Master Record: Infotype 0002 (Personal Data) | First and last name | Read | ECC + S/4 |
| PA0105HR Master Record: Infotype 0105 (Communications) | Email and SAP user | Read | ECC + S/4 |
| HRP1000Infotype 1000 (Object) Database Table | Org unit and position names | Read | ECC + S/4 |
| HRP1001Infotype 1001 (Relationships) Database Table | Manager relationship and parent unit | Read | ECC + S/4 |
| T527XOrganizational Units | Org unit text (fallback) | Read | ECC + S/4 |
BAPIs and functions used
- RH_GET_LEADERGet Manager of an Organizational Object. Finds the manager of the org unit
- RH_STRUC_GETRead Organizational Structure for a Root Object. Finds the parent unit when a unit has no manager
- HR_ENTRY_DATEDetermine Employee Entry Date. Finds the hire date
- HR_READ_INFOTYPERead HR Infotype Records. Authorization-checked infotype read
- SO_NEW_DOCUMENT_ATT_SEND_API1SAPoffice: Send New Document with Attachments. Sends the transfer report as an Excel attachment
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_TARGET | Target system (mapping key) | Single value | — | Yes | LMS |
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | No | 1000 |
| S_PERSG | Employee group | Range / multiple | PA0001-PERSG | No | 1 |
| P_FULL | Full transfer (all active employees) | Checkbox | — | No | — |
| P_TEST | Test run (do not send) | Checkbox | — | No | X |
| P_MAIL | Transfer report recipient | Single value | — | No | [email protected] |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Personnel no. | PA0001-PERNR |
| 2 | Name | PA0001-ENAME |
| 3 | Org unit | HRP1000-STEXT |
| 4 | Cost center | PA0001-KOSTL |
| 5 | PA0105-USRID_LONG | |
| 6 | Manager | Calculated Result of RH_GET_LEADER, otherwise the parent unit's manager |
| 7 | Change | Calculated New, changed or inactive |
| 8 | Status | Calculated Sent, skipped (reason) or error |
Sample result list
| Personnel no. | Name | Org unit | Cost center | Manager | Change | Status | |
|---|---|---|---|---|---|---|---|
| 00012045 | Ayşe Örnek | Quality Assurance | 4110 | [email protected] | Mert Demo | Changed | Sent |
| 00012102 | Deniz Test | Production Planning | 4200 | Ece Örnek | New | Skipped: email missing | |
| 00011877 | Bora Demo | Sales | 5100 | [email protected] | Inactive | Sent | |
| 00012110 | Selin Örnek | Maintenance | 4310 | [email protected] | Kaan Test | New | Sent |
How does the program work?
- Selection: employees with active employment status (PA0000-STAT2 = 3) are selected; a leaver is sent once as an ‘inactive’ record in the first run after the leaving date. The hire date is found with HR_ENTRY_DATE.
- Organization: org unit, position and cost center are read from PA0001, and unit and position names from HRP1000. The manager is found with RH_GET_LEADER; for units without a manager the manager of the next higher unit is taken (RH_STRUC_GET).
- Communication: email and SAP user come from PA0105 (subtypes 0010 and 0001), and the name from PA0002.
- Change detection: records changed after the last successful transfer (AEDTM on the infotypes) and org changes are selected; the full transfer option resends all active employees.
- Mapping: the field mapping and format (CSV, JSON) for each target system are kept in a settings table; e.g. the learning system needs the manager’s email, the help desk needs cost center and location. Data is sent through a REST service or as a file to SFTP.
- Transfer report: sent, skipped (missing email, no manager found) and failed records are listed and emailed to the HR owner as an Excel attachment with SO_NEW_DOCUMENT_ATT_SEND_API1. The solution works with the same tables in on-premise HCM on S/4HANA and in ECC.
Performance notes
Read PA0000, PA0001, PA0002 and PA0105 with bulk SELECTs for the employee list; find the manager once per org unit and keep it in memory. Send only changes in the daily job; run the full transfer weekly or on demand.
Features
- Runs as a background job The daily change transfer is scheduled as a background job.
- Test mode (check without posting) Lists which records would be sent before sending.
- Send the result by email The transfer report is emailed to the HR owner as an Excel attachment.
- Line-by-line result and error log
- Export to Excel
Authorization objects
- P_ORGINRead authorization for infotypes 0000, 0001, 0002 and 0105
- S_OC_SENDAuthorization to email the transfer report
Frequently asked questions
How much personal data is shared?
Each target system receives only the fields allowed in its mapping table; for example, no ID or salary data is sent to the learning system. The field list is agreed with the data controller during installation.
When does a leaver become inactive in the external system?
An 'inactive' record is sent in the first transfer after the leaving action is saved; with the daily job this takes at most one day.
Related reports
Employee Master Data and Active Directory Comparison and Update
An interface program that compares hires, leavers and organizational changes in SAP HCM with the accounts in the corporate directory (Active …
Employees Missing Cost Center or Organizational Assignment Report
A custom ALV check report that finds, before payroll runs, active employees with an empty or invalid cost center, assignments left on the default …
Integration Extensions Between SuccessFactors Employee Central and On-Premise Payroll and Time Management
Extensions that complete the standard replication between Employee Central and on-premise SAP payroll and time management: local personnel number …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.