# Vacant Positions Aging Report

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

- Type: Report, Custom development, ALV report
- Module: HCM
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/vacant-positions-aging-report/


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

### Closest standard alternatives

- PPOME: Shows the organizational structure and positions; does not calculate the vacancy duration.
- PP01: Maintains the vacancy infotype per position; gives no bulk aging list.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| HRP1000 | Position objects: abbreviation, name and validity (driving table) | Read | - | ECC + S/4 |
| HRP1001 | Holder (A008) and organizational unit (A003) relationships of the position | Read | HRP1001-PLVAR = HRP1000-PLVAR AND HRP1001-OTYPE = 'S' AND HRP1001-OBJID = HRP1000-OBJID | ECC + S/4 |
| HRP1007 | Vacancy record: status and start date | Read | HRP1007-PLVAR = HRP1000-PLVAR AND HRP1007-OTYPE = 'S' AND HRP1007-OBJID = HRP1000-OBJID | ECC + S/4 |
| T527X | Organizational unit text | Read | T527X-ORGEH = HRP1001-SOBID AND T527X-SPRSL = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_PLVAR | Plan version | Single value | HRP1000-PLVAR | Yes |
| S_ORGEH | Organizational unit | Range / multiple | PA0001-ORGEH | No |
| S_PLANS | Position | Range / multiple | HRP1000-OBJID | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |
| P_TARGET | Target filling time (days) | Single value | - | No |
| P_SUBORD | Include subordinate units | Checkbox | - | No |
| P_VACREC | Only positions with a vacancy record | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Position | HRP1000-OBJID |
| Abbreviation | HRP1000-SHORT |
| Position name | HRP1000-STEXT |
| Org. unit | HRP1001-SOBID |
| Unit name | T527X-ORGTX |
| Position valid from | HRP1000-BEGDA |
| Last holder left | Calculated: HRP1001-ENDDA of the last A008 relationship |
| Vacancy status | HRP1007-STATUS |
| Vacancy from | HRP1007-BEGDA |
| Vacant since | Calculated: HRP1007-BEGDA or last holder left + 1 or position start |
| Days vacant | Calculated: Key date − vacant since |
| Over target | Calculated: X if days vacant > target |

## How does the report work?

1. Positions (OTYPE S) valid on the key date in the selected plan version are read from HRP1000.
2. 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".
3. 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.
4. Days vacant = key date − vacancy start; those above the target days are flagged.
5. The organizational unit of the position is found from the A003 relationship and its text added from T527X; subordinate units are optionally included.

## Authorization objects

- PLOG: Read 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=hcm-vacant-positions-aging
