# Headcount Movement and Turnover Report by Department

> 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.

- Type: Report, Custom development, ALV report
- Module: HCM
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/headcount-movement-and-turnover-report-by-department/


## 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.

### Closest standard alternatives

- S_AHR_61016369: Gives headcount at a point in time; does not give period movements and turnover rate in the same table.
- PPOME: Shows the organizational structure and assignments; no period hire/leaver analysis.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PA0000 | Actions: action type, reason and employment status (driving table) | Read | - | ECC + S/4 |
| PA0001 | Organizational assignment: company code, personnel area, employee group, organizational unit | Read | PA0001-PERNR = PA0000-PERNR | ECC + S/4 |
| T529T | Action type texts | Read | T529T-MASSN = PA0000-MASSN AND T529T-SPRSL = SY-LANGU | ECC + S/4 |
| T527X | Organizational unit texts | Read | T527X-ORGEH = PA0001-ORGEH AND T527X-SPRSL = SY-LANGU | ECC + S/4 |
| HRP1001 | Organizational structure relationships used to roll up subordinate units | Read | HRP1001-OTYPE = 'O' AND HRP1001-OBJID = PA0001-ORGEH | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes |
| S_WERKS | Personnel area | Range / multiple | PA0001-WERKS | No |
| S_PERSG | Employee group | Range / multiple | PA0001-PERSG | No |
| S_ORGEH | Organizational unit | Range / multiple | PA0001-ORGEH | No |
| P_BEGDA | Period start | Single value | PA0000-BEGDA | Yes |
| P_ENDDA | Period end | Single value | PA0000-ENDDA | Yes |
| S_MASSN | Leaving action types | Range / multiple | PA0000-MASSN | No |
| S_MASSG | Voluntary leaving reasons | Range / multiple | PA0000-MASSG | No |
| P_SUBORD | Include subordinate units | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Org. unit | PA0001-ORGEH |
| Unit name | T527X-ORGTX |
| Opening | Calculated: Employees with STAT2 = 3 at period start |
| Hires | Calculated: Hire actions in the period (PA0000-MASSN) |
| Transfers in | Calculated: Employees whose PA0001-ORGEH changed to this unit |
| Transfers out | Calculated: Employees whose PA0001-ORGEH changed from this unit |
| Voluntary leavers | Calculated: Leaving action, PA0000-MASSG in the voluntary list |
| Involuntary leavers | Calculated: Leaving action, PA0000-MASSG not in the voluntary list |
| Closing | Calculated: Employees with STAT2 = 3 at period end |
| Check | Calculated: Opening + hires + transfers in − transfers out − leavers − closing |
| Avg headcount | Calculated: (Opening + closing) ÷ 2 |
| Turnover % | Calculated: Leavers ÷ average headcount × 100 |
| Annualized % | Calculated: Turnover % × 12 ÷ months in period |

## How does the report work?

1. 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.
2. 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.
3. Employees whose PA0001-ORGEH changes in the period are counted as "transfer out" in the old unit and "transfer in" in the new unit.
4. Check = opening + hires + transfers in − transfers out − leavers − closing; rows other than zero are flagged (usually retroactive entries or missing actions).
5. 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.

## Authorization objects

- P_ORGIN: Read authorization for personnel data by infotype and organizational assignment
- PLOG: Read 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=hcm-headcount-movement-turnover
