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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| 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 type | PA0041-PERNR = PA0016-PERNR | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Name, company code and organizational unit | PA0001-PERNR = PA0016-PERNR | ECC + S/4 |
| T527XOrganizational Units | Organizational unit text | T527X-ORGEH = PA0001-ORGEH AND T527X-SPRSL = SY-LANGU | ECC + S/4 |
| HRP1001Infotype 1001 (Relationships) Database Table | Chief relationship used to find the unit manager | HRP1001-OTYPE = 'O' AND HRP1001-OBJID = PA0001-ORGEH | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes | 1000 |
| S_WERKS | Personnel area | Range / multiple | PA0001-WERKS | No | IST1 |
| S_ORGEH | Organizational unit | Range / multiple | PA0001-ORGEH | No | 50000135 |
| S_CTTYP | Contract type | Range / multiple | PA0016-CTTYP | No | 02 |
| P_DAR | Hire date type | Single value | PA0041-DAR01 | No | 01 |
| P_HORIZ | Horizon (days) | Single value | — | Yes | 45 |
| P_MAIL | Email managers | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Pers. no. | PA0016-PERNR |
| 2 | Name | PA0001-ENAME |
| 3 | Org. unit | PA0001-ORGEH |
| 4 | Unit name | T527X-ORGTX |
| 5 | Hire date | Calculated PA0041 date type or first hiring action |
| 6 | Probation period | PA0016-PRBZT |
| 7 | Period unit | PA0016-PRBEH |
| 8 | Probation end | Calculated Hire date + PA0016-PRBZT (by PRBEH unit) |
| 9 | Contract type | PA0016-CTTYP |
| 10 | Contract end | PA0016-CTEDT |
| 11 | Event | Calculated Probation end or contract end |
| 12 | Days left | Calculated Event date − key date |
| 13 | Manager | Calculated Name of the unit manager from the HRP1001 chief relationship |
Sample output
| Pers. no. | Name | Org. unit | Unit name | Hire date | Probation period | Period unit | Probation end | Contract type | Contract end | Event | Days left | Manager |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00001088 | Zeynep Aktaşlı | 50000135 | Warehouse and Logistics | 10/01/2026 | 2 | Months | 12/01/2026 | 01 | Probation end | 14 | Okan Gürsoy | |
| 00001092 | Emre Kılınçer | 50000120 | Sales Operations | 06/01/2026 | 02 | 12/31/2026 | Contract end | 44 | Aslı Tunaboy | |||
| 00001095 | Nil Erdemoğlu | 50000150 | Finance | 10/20/2026 | 2 | Months | 12/20/2026 | 02 | 04/19/2027 | Probation end | 33 | Cem Aydınlı |
How does the report work?
- 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).
- 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.
- Probation end = hire date + PRBZT (days, weeks or months according to PRBEH).
- 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.
- 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
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
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 …
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 …
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.