HCM Report Custom development ALV report

Probation and Fixed-Term Contract Expiry Report

Short answer: 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 organizational unit, and can email each manager their own team's list in advance. Extension or termination decisions are no longer left to the last day.

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?

Contract elements (infotype 0016) and date specifications (infotype 0041) are visible per employee in PA20; date monitoring reports list task dates but they do not calculate the probation end from the period and unit, do not combine it with contract expiry in one list and do not notify managers in advance.

Who uses it? HR business partners, personnel administration specialists and department managers.

Closest standard alternatives

  • PA20 Display HR Master Data. Shows contract and date details per employee; gives no bulk list of upcoming events.
  • PA30 Maintain HR Master Data. Maintains infotypes 0016 and 0041 per employee; sends no advance notification.

Tables used

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

TableRoleJoinSystem
PA0016HR Master Record: Infotype 0016 (Contract Elements)Contract elements: contract type, end date, probation period and unit (driving table)—ECC + S/4
PA0041HR Master Record: Infotype 0041 (Date Specifications)Date specifications: hire date typePA0041-PERNR = PA0016-PERNRECC + S/4
PA0001HR Master Record: Infotype 0001 (Organizational Assignment)Name, company code and organizational unitPA0001-PERNR = PA0016-PERNRECC + S/4
T527XOrganizational UnitsOrganizational unit textT527X-ORGEH = PA0001-ORGEH AND T527X-SPRSL = SY-LANGUECC + S/4
HRP1001Infotype 1001 (Relationships) Database TableChief relationship used to find the unit managerHRP1001-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_ORGEHOrganizational unitRange / multiplePA0001-ORGEHNo50000135
S_CTTYPContract typeRange / multiplePA0016-CTTYPNo02
P_DARHire date typeSingle valuePA0041-DAR01No01
P_HORIZHorizon (days)Single value—Yes45
P_MAILEmail managersCheckbox—NoX

Output columns

#ColumnSource
1Pers. no.PA0016-PERNR
2NamePA0001-ENAME
3Org. unitPA0001-ORGEH
4Unit nameT527X-ORGTX
5Hire dateCalculated PA0041 date type or first hiring action
6Probation periodPA0016-PRBZT
7Period unitPA0016-PRBEH
8Probation endCalculated Hire date + PA0016-PRBZT (by PRBEH unit)
9Contract typePA0016-CTTYP
10Contract endPA0016-CTEDT
11EventCalculated Probation end or contract end
12Days leftCalculated Event date − key date
13ManagerCalculated Name of the unit manager from the HRP1001 chief relationship

Sample output

Pers. no.NameOrg. unitUnit nameHire dateProbation periodPeriod unitProbation endContract typeContract endEventDays leftManager
00001088Zeynep Aktaşlı50000135Warehouse and Logistics10/01/20262Months12/01/202601Probation end14Okan Gürsoy
00001092Emre Kılınçer50000120Sales Operations06/01/20260212/31/2026Contract end44Aslı Tunaboy
00001095Nil Erdemoğlu50000150Finance10/20/20262Months12/20/20260204/19/2027Probation end33Cem Aydınlı
A view built with fictional sample data; not real system data.

How does the report work?

  1. For the selected employees, the contract record valid on the key date is read from PA0016: contract type (CTTYP), contract end (CTEDT), probation period (PRBZT) and its unit (PRBEH).
  2. The hire date is taken from the selected date type in PA0041; without that date type, the start date of the first hiring action is used.
  3. Probation end = hire date + PRBZT (days, weeks or months according to PRBEH).
  4. Days left = event date − key date; probation ends and contract expiries within the horizon are listed. If an employee has both events, two rows are written.
  5. The organizational unit is added from PA0001 and its text from T527X; the unit manager is found from the chief relationship in the organizational structure (HRP1001), and with email selected each manager receives their own list.

Performance notes

Select employees through the logical database; read PA0016 and PA0041 only for records valid on the key date. The manager lookup should be done once over the list of units. Schedule 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 infotype 0016 in PA20.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Each manager receives only their own unit's list.

Authorization objects

  • P_ORGINRead authorization for personnel data by infotype and organizational assignment
  • PLOGRead authorization for the chief relationship in the organizational structure

Frequently asked questions

Are probation and notice periods calculated by statutory rules?

The report uses the contract data in the system. Statutory rules on probation and notice periods are checked against current regulation at installation; no fixed statutory period is hard-coded in the report.

Who receives the email if the manager is missing in the organizational structure?

If the unit has no chief relationship, the manager of the parent unit is searched; if still none is found, the list goes to the HR address given on the selection screen.

How are fixed-term contract extensions tracked?

When an extension is entered as a new infotype 0016 record, the contract end date changes and the employee leaves the horizon. To count repeated extensions, an extra column can be added by reading the record history.

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

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 …

PA0000 · PA0001 · T529T · T527X

HCM Report Custom ALV report

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 …

PA2006 · PA2001 · PA0001 · T556A

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: Probation and Fixed-Term Contract Expiry Report