# Employee Leave Quota Balance and Expiry Risk Report

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

- Type: Report, Custom development, ALV report
- Module: HCM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/employee-leave-quota-balance-and-expiry-report/


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

### Closest standard alternatives

- PT50: Gives the quota and absence overview of one employee; no population-wide expiry risk list.
- PA30: Maintains infotype 2006 quotas per employee; gives no bulk balance report.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PA2006 | Absence quotas: type, entitlement, used, deduction period (driving table) | Read | - | ECC + S/4 |
| PA2001 | Absence records deducting the quota; used to split taken and future-booked | Read | PA2001-PERNR = PA2006-PERNR | ECC + S/4 |
| PA0001 | Name, organizational unit and company code | Read | PA0001-PERNR = PA2006-PERNR | ECC + S/4 |
| T556A | Quota type definition and time unit | Read | T556A-KTART = PA2006-KTART | ECC + S/4 |
| T554S | Absence type definition | Read | T554S-SUBTY = PA2001-AWART | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes |
| S_ORGEH | Organizational unit | Range / multiple | PA0001-ORGEH | No |
| S_PERNR | Personnel number | Range / multiple | PA2006-PERNR | No |
| S_KTART | Quota type | Range / multiple | PA2006-KTART | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |
| P_HORIZ | Expiry risk horizon (days) | Single value | - | No |
| P_RISK | Risky quotas only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Pers. no. | PA2006-PERNR |
| Name | PA0001-ENAME |
| Org. unit | PA0001-ORGEH |
| Quota type | PA2006-KTART |
| Deduction end | PA2006-DEEND |
| Entitlement | PA2006-ANZHL |
| Used | PA2006-KVERB |
| Taken to date | Calculated: Σ PA2001-ABRTG, PA2001-ENDDA < key date |
| Booked ahead | Calculated: PA2006-KVERB − taken |
| Remaining | Calculated: PA2006-ANZHL − PA2006-KVERB |
| Unit | T556A-ZEINH |
| Days to end | Calculated: PA2006-DEEND − key date |
| Status | Calculated: Expiry risk, negative balance or normal |

## How does the report work?

1. 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).
2. 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".
3. Remaining = ANZHL − KVERB. The unit (days/hours) is validated from T556A, the absence type from T554S.
4. Days until deduction end = DEEND − key date. "Expiry risk" if remaining > 0 and days until end ≤ horizon, "Negative balance" if remaining < 0, otherwise "Normal".
5. Organizational unit and name are added from PA0001; the result is shown with subtotals per unit and can be emailed to the unit manager.

## Authorization objects

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

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=hcm-leave-quota-balance
