Headcount Movement and Turnover Report by Department
Short answer: A custom ALV report that gives, for the selected period and per organizational unit, opening headcount, hires, transfers between units, voluntary and involuntary leavers and closing headcount on one line, checks that opening + movements = closing, and calculates the annualized turnover rate.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
S_AHR_61016369 gives headcount at a point in time; hire and leaver reports are separate lists. None of them shows that opening headcount plus movements equals closing headcount, separates transfers between units from hires and leavers, or groups leaving reasons into voluntary/involuntary to calculate a turnover rate. This table is usually merged in Excel every month.
Who uses it? HR business partners, HR reporting teams and department managers.
Closest standard alternatives
- S_AHR_61016369 Employee List. Gives headcount at a point in time; does not give period movements and turnover rate in the same table.
- PPOME Change Organization and Staffing. Shows the organizational structure and assignments; no period hire/leaver analysis.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| PA0000HR Master Record: Infotype 0000 (Actions) | Actions: action type, reason and employment status (driving table) | — | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Organizational assignment: company code, personnel area, employee group, organizational unit | PA0001-PERNR = PA0000-PERNR | ECC + S/4 |
| T529TPersonnel Action Texts | Action type texts | T529T-MASSN = PA0000-MASSN AND T529T-SPRSL = SY-LANGU | ECC + S/4 |
| T527XOrganizational Units | Organizational unit texts | T527X-ORGEH = PA0001-ORGEH AND T527X-SPRSL = SY-LANGU | ECC + S/4 |
| HRP1001Infotype 1001 (Relationships) Database Table | Organizational structure relationships used to roll up subordinate units | HRP1001-OTYPE = 'O' AND HRP1001-OBJID = PA0001-ORGEH | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes | 1000 |
| S_WERKS | Personnel area | Range / multiple | PA0001-WERKS | No | IST1 |
| S_PERSG | Employee group | Range / multiple | PA0001-PERSG | No | 1 |
| S_ORGEH | Organizational unit | Range / multiple | PA0001-ORGEH | No | 50000120 |
| P_BEGDA | Period start | Single value | PA0000-BEGDA | Yes | 01.01.2026 |
| P_ENDDA | Period end | Single value | PA0000-ENDDA | Yes | 31.10.2026 |
| S_MASSN | Leaving action types | Range / multiple | PA0000-MASSN | No | 10 |
| S_MASSG | Voluntary leaving reasons | Range / multiple | PA0000-MASSG | No | 01, 02 |
| P_SUBORD | Include subordinate units | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Org. unit | PA0001-ORGEH |
| 2 | Unit name | T527X-ORGTX |
| 3 | Opening | Calculated Employees with STAT2 = 3 at period start |
| 4 | Hires | Calculated Hire actions in the period (PA0000-MASSN) |
| 5 | Transfers in | Calculated Employees whose PA0001-ORGEH changed to this unit |
| 6 | Transfers out | Calculated Employees whose PA0001-ORGEH changed from this unit |
| 7 | Voluntary leavers | Calculated Leaving action, PA0000-MASSG in the voluntary list |
| 8 | Involuntary leavers | Calculated Leaving action, PA0000-MASSG not in the voluntary list |
| 9 | Closing | Calculated Employees with STAT2 = 3 at period end |
| 10 | Check | Calculated Opening + hires + transfers in − transfers out − leavers − closing |
| 11 | Avg headcount | Calculated (Opening + closing) ÷ 2 |
| 12 | Turnover % | Calculated Leavers ÷ average headcount × 100 |
| 13 | Annualized % | Calculated Turnover % × 12 ÷ months in period |
Sample output
| Org. unit | Unit name | Opening | Hires | Transfers in | Transfers out | Voluntary leavers | Involuntary leavers | Closing | Check | Avg headcount | Turnover % | Annualized % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50000120 | Sales Operations | 84 | 12 | 3 | 2 | 7 | 1 | 89 | 0 | 86.50 | 9.20 | 11.10 |
| 50000135 | Warehouse and Logistics | 142 | 31 | 1 | 4 | 18 | 6 | 146 | 0 | 144 | 16.70 | 20 |
| 50000150 | Finance | 37 | 2 | 0 | 1 | 2 | 0 | 36 | 0 | 36.50 | 5.50 | 6.60 |
| 50000162 | Production Planning | 25 | 3 | 2 | 0 | 1 | 0 | 28 | 1 | 26.50 | 3.80 | 4.50 |
How does the report work?
- Employees whose employment status in PA0000 is active (STAT2 = 3) on the period start and end dates, and their organizational units in PA0001, are determined.
- From PA0000 records in the period, the selected hire and leaving action types (MASSN) are counted; the leaving reason (MASSG) is split into voluntary or involuntary using the voluntary reason list on the selection screen.
- Employees whose PA0001-ORGEH changes in the period are counted as “transfer out” in the old unit and “transfer in” in the new unit.
- Check = opening + hires + transfers in − transfers out − leavers − closing; rows other than zero are flagged (usually retroactive entries or missing actions).
- Average headcount = (opening + closing) ÷ 2; turnover % = leavers ÷ average headcount × 100; annualized rate = turnover % × 12 ÷ months in the period. The unit text is added from T527X; subordinate units can optionally be rolled up.
Performance notes
Narrow the employee selection by company code and personnel area through the logical database or PA0001; read only the required infotypes. For organizations with tens of thousands of employees, run the report in the background at month-end. The report only produces counts; person-level detail opens only with authorization.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a count opens the list of employees behind that movement, subject to authorization.
- Export to Excel
- Runs as a background job
Authorization objects
- P_ORGINRead authorization for personnel data by infotype and organizational assignment
- PLOGRead authorization for organizational management objects
Frequently asked questions
How are voluntary and involuntary leavers separated?
The reason of the leaving action (PA0000-MASSG) is used. Which reasons count as voluntary is entered on the selection screen or tied to a fixed mapping during installation.
Why can the check column be other than zero?
Retroactive actions, missing organizational change records or several actions on the same day usually cause the difference. Double-clicking the row shows the personnel numbers behind it, subject to authorization.
Does the report show personal data?
The main list consists of counts only. The drill-down to the employee list depends on the P_ORGIN authorization, and fields such as names are shown only to authorized users.
Packages that include this solution
HR Reporting Pack
A pack that delivers the four topics of the monthly HR management report with one personnel area and organizational unit selection: headcount movement …
Related reports
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 …
Vacant Positions Aging Report
A custom ALV report that ages the vacant positions in the organizational structure by how long they have been vacant, the leaving date of the last …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.