HCM Report Custom development ALV report

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.

TableRoleJoinSystem
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 unitPA0001-PERNR = PA0000-PERNRECC + S/4
T529TPersonnel Action TextsAction type textsT529T-MASSN = PA0000-MASSN AND T529T-SPRSL = SY-LANGUECC + S/4
T527XOrganizational UnitsOrganizational unit textsT527X-ORGEH = PA0001-ORGEH AND T527X-SPRSL = SY-LANGUECC + S/4
HRP1001Infotype 1001 (Relationships) Database TableOrganizational structure relationships used to roll up subordinate unitsHRP1001-OTYPE = 'O' AND HRP1001-OBJID = PA0001-ORGEHECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multiplePA0001-BUKRSYes1000
S_WERKSPersonnel areaRange / multiplePA0001-WERKSNoIST1
S_PERSGEmployee groupRange / multiplePA0001-PERSGNo1
S_ORGEHOrganizational unitRange / multiplePA0001-ORGEHNo50000120
P_BEGDAPeriod startSingle valuePA0000-BEGDAYes01.01.2026
P_ENDDAPeriod endSingle valuePA0000-ENDDAYes31.10.2026
S_MASSNLeaving action typesRange / multiplePA0000-MASSNNo10
S_MASSGVoluntary leaving reasonsRange / multiplePA0000-MASSGNo01, 02
P_SUBORDInclude subordinate unitsCheckbox—NoX

Output columns

#ColumnSource
1Org. unitPA0001-ORGEH
2Unit nameT527X-ORGTX
3OpeningCalculated Employees with STAT2 = 3 at period start
4HiresCalculated Hire actions in the period (PA0000-MASSN)
5Transfers inCalculated Employees whose PA0001-ORGEH changed to this unit
6Transfers outCalculated Employees whose PA0001-ORGEH changed from this unit
7Voluntary leaversCalculated Leaving action, PA0000-MASSG in the voluntary list
8Involuntary leaversCalculated Leaving action, PA0000-MASSG not in the voluntary list
9ClosingCalculated Employees with STAT2 = 3 at period end
10CheckCalculated Opening + hires + transfers in − transfers out − leavers − closing
11Avg headcountCalculated (Opening + closing) ÷ 2
12Turnover %Calculated Leavers ÷ average headcount × 100
13Annualized %Calculated Turnover % × 12 ÷ months in period

Sample output

Org. unitUnit nameOpeningHiresTransfers inTransfers outVoluntary leaversInvoluntary leaversClosingCheckAvg headcountTurnover %Annualized %
50000120Sales Operations8412327189086.509.2011.10
50000135Warehouse and Logistics1423114186146014416.7020
50000150Finance372012036036.505.506.60
50000162Production Planning253201028126.503.804.50
A view built with fictional sample data; not real system data.

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.

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

HCM Package Custom

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 …

4 components · v1.0

Related reports

HCM Report Custom ALV report

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 …

HRP1000 · HRP1001 · HRP1007 · T527X

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.

Related report: Headcount Movement and Turnover Report by Department