Vacant Positions Aging Report
Short answer: A custom ALV report that ages the vacant positions in the organizational structure by how long they have been vacant, the leaving date of the last holder and the vacancy record, and flags those above the target time. HR and management see recruiting delays per unit.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 4
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
PPOME shows the organizational structure and positions; vacant position reports list positions vacant on a given date. There is no standard list that shows on the same line how many days a position has been vacant, when its last holder left and whether it exceeds the target filling time.
Who uses it? Recruiting teams, HR business partners and organizational management specialists.
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 |
|---|---|---|---|
| HRP1000Infotype 1000 (Object) Database Table | Position objects: abbreviation, name and validity (driving table) | — | ECC + S/4 |
| HRP1001Infotype 1001 (Relationships) Database Table | Holder (A008) and organizational unit (A003) relationships of the position | HRP1001-PLVAR = HRP1000-PLVAR AND HRP1001-OTYPE = 'S' AND HRP1001-OBJID = HRP1000-OBJID | ECC + S/4 |
| HRP1007Infotype 1007 (Vacancy) Database Table | Vacancy record: status and start date | HRP1007-PLVAR = HRP1000-PLVAR AND HRP1007-OTYPE = 'S' AND HRP1007-OBJID = HRP1000-OBJID | ECC + S/4 |
| T527XOrganizational Units | Organizational unit text | T527X-ORGEH = HRP1001-SOBID AND T527X-SPRSL = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_PLVAR | Plan version | Single value | HRP1000-PLVAR | Yes | 01 |
| S_ORGEH | Organizational unit | Range / multiple | PA0001-ORGEH | No | 50000135 |
| S_PLANS | Position | Range / multiple | HRP1000-OBJID | No | 50001210 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_TARGET | Target filling time (days) | Single value | — | No | 60 |
| P_SUBORD | Include subordinate units | Checkbox | — | No | X |
| P_VACREC | Only positions with a vacancy record | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Position | HRP1000-OBJID |
| 2 | Abbreviation | HRP1000-SHORT |
| 3 | Position name | HRP1000-STEXT |
| 4 | Org. unit | HRP1001-SOBID |
| 5 | Unit name | T527X-ORGTX |
| 6 | Position valid from | HRP1000-BEGDA |
| 7 | Last holder left | Calculated HRP1001-ENDDA of the last A008 relationship |
| 8 | Vacancy status | HRP1007-STATUS |
| 9 | Vacancy from | HRP1007-BEGDA |
| 10 | Vacant since | Calculated HRP1007-BEGDA or last holder left + 1 or position start |
| 11 | Days vacant | Calculated Key date − vacant since |
| 12 | Over target | Calculated X if days vacant > target |
Sample output
| Position | Abbreviation | Position name | Org. unit | Unit name | Position valid from | Last holder left | Vacancy status | Vacancy from | Vacant since | Days vacant | Over target |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 50001210 | SAT-UZM-3 | Sales Specialist | 50000120 | Sales Operations | 03/01/2024 | 08/31/2026 | 0 | 09/01/2026 | 09/01/2026 | 77 | X |
| 50001244 | DEP-VAR-2 | Warehouse Shift Supervisor | 50000135 | Warehouse and Logistics | 01/01/2025 | 10/15/2026 | 0 | 10/16/2026 | 10/16/2026 | 32 | |
| 50001290 | FIN-ANL-1 | Financial Analyst | 50000150 | Finance | 07/01/2026 | 07/01/2026 | 139 | X |
How does the report work?
- Positions (OTYPE S) valid on the key date in the selected plan version are read from HRP1000.
- If the position’s holder relationship to a person (A008) in HRP1001 is not valid on the key date, the position is treated as vacant; the end date of the last holder relationship is taken as “last holder left”.
- If a vacancy record (HRP1007) exists, its status and start date are read. Vacancy start = vacancy record start or last holder left + 1; if the position was never filled, the position’s creation date.
- Days vacant = key date − vacancy start; those above the target days are flagged.
- The organizational unit of the position is found from the A003 relationship and its text added from T527X; subordinate units are optionally included.
Performance notes
Restrict HRP1000 and HRP1001 by plan version, object type and key date; standard structure read functions can be used for the organizational structure. The report reads no personal data; it works only with position objects and relationships.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a position opens it in the organizational structure in PPOME.
- Export to Excel
- Runs as a background job
Authorization objects
- PLOGRead authorization for organizational management objects and relationships
Frequently asked questions
Does the report work if vacancy records are not used?
Yes. If vacancies (infotype 1007) are not used, the vacancy start is calculated from the end of the last holder relationship.
How is partial staffing (part-time holder) treated?
If the staffing percentage in the holder relationship (HRP1001-PROZT) is below 100, the position can be listed separately as "partially filled"; the default calculation is for fully vacant positions.
Does the report read personal data?
No. The report reads only position and organizational unit objects and relationship dates; the identity of the last holder is not shown.
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 …
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.