HCM Report Custom development ALV report

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

  • PT50 Quota Overview. Gives the quota and absence overview of one employee; no population-wide expiry risk list.
  • PA30 Maintain HR Master Data. Maintains infotype 2006 quotas per employee; gives no bulk balance report.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
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-bookedPA2001-PERNR = PA2006-PERNRECC + S/4
PA0001HR Master Record: Infotype 0001 (Organizational Assignment)Name, organizational unit and company codePA0001-PERNR = PA2006-PERNRECC + S/4
T556AAbsence Quota TypesQuota type definition and time unitT556A-KTART = PA2006-KTARTECC + S/4
T554SAttendance and Absence TypesAbsence type definitionT554S-SUBTY = PA2001-AWARTECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multiplePA0001-BUKRSYes1000
S_ORGEHOrganizational unitRange / multiplePA0001-ORGEHNo50000135
S_PERNRPersonnel numberRange / multiplePA2006-PERNRNo00001024
S_KTARTQuota typeRange / multiplePA2006-KTARTNo10
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026
P_HORIZExpiry risk horizon (days)Single value—No60
P_RISKRisky quotas onlyCheckbox—No—

Output columns

#ColumnSource
1Pers. no.PA2006-PERNR
2NamePA0001-ENAME
3Org. unitPA0001-ORGEH
4Quota typePA2006-KTART
5Deduction endPA2006-DEEND
6EntitlementPA2006-ANZHL
7UsedPA2006-KVERB
8Taken to dateCalculated Σ PA2001-ABRTG, PA2001-ENDDA < key date
9Booked aheadCalculated PA2006-KVERB − taken
10RemainingCalculated PA2006-ANZHL − PA2006-KVERB
11UnitT556A-ZEINH
12Days to endCalculated PA2006-DEEND − key date
13StatusCalculated Expiry risk, negative balance or normal

Sample output

Pers. no.NameOrg. unitQuota typeDeduction endEntitlementUsedTaken to dateBooked aheadRemainingUnitDays to endStatus
00001024Deniz Arıkan500001351012/31/2026146608Days44Expiry risk
00001031Mert Yalınkaya500001351006/30/20272022175-2Days225Negative balance
00001057Selin Okyay500001201003/31/202726107316Days134Normal
A view built with fictional sample data; not real system data.

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.

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

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 Program Custom Mass upload

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 …

PA2001 · PA2002 · PA2006 · T554S

HCM Report Custom ALV report

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 …

PA0016 · PA0041 · PA0001 · 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: Employee Leave Quota Balance and Expiry Risk Report