Employee Leave Quota Balance and Expiry Risk Report
Short answer: A custom ALV report that separates entitled, used, future-booked and remaining days in each employee's absence quota, and flags remaining leave whose deduction period ends soon and quotas that have gone negative. Managers see their team's leave planning without waiting for month-end.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
PT50 shows the quotas of one employee. Standard quota reports list the remaining entitlement, but they do not split used days into taken to date and booked in the future, do not flag remaining leave with the days until the deduction period ends, and do not distribute the result by department via email.
Who uses it? HR time management specialists, department managers and payroll teams.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| PA2006HR Time Record: Infotype 2006 (Absence Quotas) | Absence quotas: type, entitlement, used, deduction period (driving table) | — | ECC + S/4 |
| PA2001HR Time Record: Infotype 2001 (Absences) | Absence records deducting the quota; used to split taken and future-booked | PA2001-PERNR = PA2006-PERNR | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Name, organizational unit and company code | PA0001-PERNR = PA2006-PERNR | ECC + S/4 |
| T556AAbsence Quota Types | Quota type definition and time unit | T556A-KTART = PA2006-KTART | ECC + S/4 |
| T554SAttendance and Absence Types | Absence type definition | T554S-SUBTY = PA2001-AWART | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes | 1000 |
| S_ORGEH | Organizational unit | Range / multiple | PA0001-ORGEH | No | 50000135 |
| S_PERNR | Personnel number | Range / multiple | PA2006-PERNR | No | 00001024 |
| S_KTART | Quota type | Range / multiple | PA2006-KTART | No | 10 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_HORIZ | Expiry risk horizon (days) | Single value | — | No | 60 |
| P_RISK | Risky quotas only | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Pers. no. | PA2006-PERNR |
| 2 | Name | PA0001-ENAME |
| 3 | Org. unit | PA0001-ORGEH |
| 4 | Quota type | PA2006-KTART |
| 5 | Deduction end | PA2006-DEEND |
| 6 | Entitlement | PA2006-ANZHL |
| 7 | Used | PA2006-KVERB |
| 8 | Taken to date | Calculated Σ PA2001-ABRTG, PA2001-ENDDA < key date |
| 9 | Booked ahead | Calculated PA2006-KVERB − taken |
| 10 | Remaining | Calculated PA2006-ANZHL − PA2006-KVERB |
| 11 | Unit | T556A-ZEINH |
| 12 | Days to end | Calculated PA2006-DEEND − key date |
| 13 | Status | Calculated Expiry risk, negative balance or normal |
Sample output
| Pers. no. | Name | Org. unit | Quota type | Deduction end | Entitlement | Used | Taken to date | Booked ahead | Remaining | Unit | Days to end | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00001024 | Deniz Arıkan | 50000135 | 10 | 12/31/2026 | 14 | 6 | 6 | 0 | 8 | Days | 44 | Expiry risk |
| 00001031 | Mert Yalınkaya | 50000135 | 10 | 06/30/2027 | 20 | 22 | 17 | 5 | -2 | Days | 225 | Negative balance |
| 00001057 | Selin Okyay | 50000120 | 10 | 03/31/2027 | 26 | 10 | 7 | 3 | 16 | Days | 134 | Normal |
How does the report work?
- For the selected employees, quotas valid on the key date are read from PA2006: quota type (KTART), entitlement (ANZHL), used (KVERB), deduction period start and end (DESTA, DEEND).
- Absence records deducting the quota are read from PA2001; those ending before the key date are summed as “taken”, later ones as “booked in the future”.
- Remaining = ANZHL − KVERB. The unit (days/hours) is validated from T556A, the absence type from T554S.
- Days until deduction end = DEEND − key date. “Expiry risk” if remaining > 0 and days until end ≤ horizon, “Negative balance” if remaining < 0, otherwise “Normal”.
- Organizational unit and name are added from PA0001; the result is shown with subtotals per unit and can be emailed to the unit manager.
Performance notes
Select employees through the logical database and restrict PA2006 to records valid on the key date. Narrow the PA2001 read to dates within the quota deduction period. For large populations, run the report as a weekly background job.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the personnel number opens the PT50 quota overview.
- Export to Excel
- Runs as a background job
- Send the result by email Each unit manager can receive only their own team's list.
Authorization objects
- P_ORGINRead authorization for personnel data by infotype and organizational assignment
- P_PERNRAccess control for the user's own personnel number
Frequently asked questions
Are leave requests waiting for approval included?
The default calculation uses absences recorded in PA2001. If self-service leave requests are used, pending requests can be read from the request tables and added as a separate "pending approval" column.
Does the report check statutory leave entitlements?
No. The report shows the quota definitions and records in the system. Statutory entitlement is calculated in time evaluation or quota generation settings and is checked against current regulation at installation.
Are hour-based quotas supported?
Yes. The unit is read from T556A, and for hour-based quotas the calculation uses PA2001-STDAZ; the list shows the unit in a separate column.
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
Mass Absence and Attendance Upload Program
A custom program that posts absence (infotype 2001) and attendance (infotype 2002) records coming from time clocks, shift planning tools or Excel into …
Probation and Fixed-Term Contract Expiry Report
A custom ALV report that lists employees whose probation ends or whose fixed-term contract expires in the coming days, with the days left and their …
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.