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

- 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/probation-and-fixed-term-contract-expiry-report/


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

### Closest standard alternatives

- PA20: Shows contract and date details per employee; gives no bulk list of upcoming events.
- PA30: Maintains infotypes 0016 and 0041 per employee; sends no advance notification.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PA0016 | Contract elements: contract type, end date, probation period and unit (driving table) | Read | - | ECC + S/4 |
| PA0041 | Date specifications: hire date type | Read | PA0041-PERNR = PA0016-PERNR | ECC + S/4 |
| PA0001 | Name, company code and organizational unit | Read | PA0001-PERNR = PA0016-PERNR | ECC + S/4 |
| T527X | Organizational unit text | Read | T527X-ORGEH = PA0001-ORGEH AND T527X-SPRSL = SY-LANGU | ECC + S/4 |
| HRP1001 | Chief relationship used to find the unit manager | Read | HRP1001-OTYPE = 'O' AND HRP1001-OBJID = PA0001-ORGEH | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes |
| S_WERKS | Personnel area | Range / multiple | PA0001-WERKS | No |
| S_ORGEH | Organizational unit | Range / multiple | PA0001-ORGEH | No |
| S_CTTYP | Contract type | Range / multiple | PA0016-CTTYP | No |
| P_DAR | Hire date type | Single value | PA0041-DAR01 | No |
| P_HORIZ | Horizon (days) | Single value | - | Yes |
| P_MAIL | Email managers | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Pers. no. | PA0016-PERNR |
| Name | PA0001-ENAME |
| Org. unit | PA0001-ORGEH |
| Unit name | T527X-ORGTX |
| Hire date | Calculated: PA0041 date type or first hiring action |
| Probation period | PA0016-PRBZT |
| Period unit | PA0016-PRBEH |
| Probation end | Calculated: Hire date + PA0016-PRBZT (by PRBEH unit) |
| Contract type | PA0016-CTTYP |
| Contract end | PA0016-CTEDT |
| Event | Calculated: Probation end or contract end |
| Days left | Calculated: Event date − key date |
| Manager | Calculated: Name of the unit manager from the HRP1001 chief relationship |

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

## Authorization objects

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

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=hcm-probation-contract-expiry
