HCM Report Custom development ALV report

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

  • PPOME Change Organization and Staffing. Shows the organizational structure and positions; does not calculate the vacancy duration.
  • PP01 Maintain Plan Data (Menu-Guided). Maintains the vacancy infotype per position; gives no bulk aging list.

Tables used

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

TableRoleJoinSystem
HRP1000Infotype 1000 (Object) Database TablePosition objects: abbreviation, name and validity (driving table)—ECC + S/4
HRP1001Infotype 1001 (Relationships) Database TableHolder (A008) and organizational unit (A003) relationships of the positionHRP1001-PLVAR = HRP1000-PLVAR AND HRP1001-OTYPE = 'S' AND HRP1001-OBJID = HRP1000-OBJIDECC + S/4
HRP1007Infotype 1007 (Vacancy) Database TableVacancy record: status and start dateHRP1007-PLVAR = HRP1000-PLVAR AND HRP1007-OTYPE = 'S' AND HRP1007-OBJID = HRP1000-OBJIDECC + S/4
T527XOrganizational UnitsOrganizational unit textT527X-ORGEH = HRP1001-SOBID AND T527X-SPRSL = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_PLVARPlan versionSingle valueHRP1000-PLVARYes01
S_ORGEHOrganizational unitRange / multiplePA0001-ORGEHNo50000135
S_PLANSPositionRange / multipleHRP1000-OBJIDNo50001210
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026
P_TARGETTarget filling time (days)Single value—No60
P_SUBORDInclude subordinate unitsCheckbox—NoX
P_VACRECOnly positions with a vacancy recordCheckbox—No—

Output columns

#ColumnSource
1PositionHRP1000-OBJID
2AbbreviationHRP1000-SHORT
3Position nameHRP1000-STEXT
4Org. unitHRP1001-SOBID
5Unit nameT527X-ORGTX
6Position valid fromHRP1000-BEGDA
7Last holder leftCalculated HRP1001-ENDDA of the last A008 relationship
8Vacancy statusHRP1007-STATUS
9Vacancy fromHRP1007-BEGDA
10Vacant sinceCalculated HRP1007-BEGDA or last holder left + 1 or position start
11Days vacantCalculated Key date − vacant since
12Over targetCalculated X if days vacant > target

Sample output

PositionAbbreviationPosition nameOrg. unitUnit namePosition valid fromLast holder leftVacancy statusVacancy fromVacant sinceDays vacantOver target
50001210SAT-UZM-3Sales Specialist50000120Sales Operations03/01/202408/31/2026009/01/202609/01/202677X
50001244DEP-VAR-2Warehouse Shift Supervisor50000135Warehouse and Logistics01/01/202510/15/2026010/16/202610/16/202632
50001290FIN-ANL-1Financial Analyst50000150Finance07/01/202607/01/2026139X
A view built with fictional sample data; not real system data.

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.

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

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

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: Vacant Positions Aging Report