SAP tableObjectPRHIModulePS

PRHI table — WBS Hierarchy Pointer Table

PRHI is the internal hierarchy pointer table for Project System WBS elements. It stores each WBS element's position in the project tree - its level and links to the parent and sibling nodes - so the system can navigate the structure quickly without recalculating it from PRPS every time. It carries no business data; PRPS and PROJ hold that.

This page covers PRHI, the technical pointer table SAP uses to represent WBS hierarchy structure for fast traversal, separate from the business content held in PRPS and PROJ. It focuses on how to diagnose hierarchy display problems that trace back to this table rather than to the WBS elements themselves, and on why the table should never be edited or joined directly in custom reporting.

Published 16 Sept 2026· 1,079 words

What it stores

One row in PRHI represents a single node's position in the internal tree structure of a project - typically a WBS element, including the top-level node that corresponds to the project definition. The row does not describe what the WBS element is or does; that content lives in PRPS (WBS element master data) and PROJ (project definition). PRHI exists purely as a performance and navigation structure: it records the hierarchy level of the node and its relationship to the node directly above it and to neighbouring nodes at the same level, so that hierarchy-aware processing (structure display, structure reports, mass processing by level) does not need to reconstruct the tree from PRPS's level indicator each time it runs. It is written and maintained automatically whenever a project structure is created, changed, or reorganized through standard project maintenance transactions such as the project builder. No one maintains it by hand in a healthy system, and no functional process is designed to update it directly.

Key fields

  • MANDT - client
  • PSPNR - internal number of the WBS element or project definition node this row describes, the same key used in PRPS
  • STUFE - hierarchy level of the node within the project structure, with the project definition or top WBS element normally at the lowest level number
  • hierarchy pointer fields - internal numbers identifying the parent node above this one and the neighbouring nodes immediately before and after it at the same level, used internally to walk the tree without a full scan of PRPS by level; exact field names are not given here because they are not confirmed and should be checked directly in the table definition before being used in custom code

How it joins the data model

  • PRHI-PSPNR = PRPS-PSPNR (each hierarchy pointer row corresponds to one WBS element master row)
  • PRHI-MANDT = PRPS-MANDT
  • PRHI-PSPNR = PROJ-PSPNR (the row for the top node corresponds to the project definition's internal number)
  • PRPS-PSPHI = PROJ-PSPNR (used first, outside PRHI, to collect the set of WBS elements belonging to one project before touching PRHI at all)

How to read it safely

Always restrict by MANDT first. PSPNR alone is not a useful restriction because it is an internal number shared across every project in the client and gives no indication of which project a given value belongs to. The safe pattern is to resolve the project definition's internal number from PROJ by its external project ID, pull the member WBS elements from PRPS where the parent-project field matches that internal number, and only then use that specific set of PSPNR values to filter PRHI. Querying PRHI without first scoping to a known project or WBS element set means scanning a table that grows with every project and every restructuring event in the system, with no natural selective key to stop on.

How to prove it in the data

Symptom: a WBS element shows up in the wrong place, or is missing, in a structure report or the project builder tree view, while it is clearly still active in PRPS. Selection: find the project definition's internal number in PROJ from its external ID, list the project's WBS elements from PRPS with their STUFE values, then pull the matching rows from PRHI for those PSPNR values and compare stored level and parent links against what PRPS and the actual structure imply. A mismatch confirms the hierarchy pointer table is out of sync with the current structure.

ECC vs S/4HANA

The Project System data model built around PROJ and PRPS carried forward into S/4HANA largely unchanged, and PRHI is expected to still exist as the same kind of internal pointer table serving the same purpose. No confirmed replacement by a CDS compatibility view is known for this specific table, and its content should still be treated as a derived, technical structure rather than a reporting source in either release line.

Common pitfalls

  • Editing PRHI directly, in any tool, on the assumption that fixing a broken hierarchy is a data correction - manual changes to pointer rows can corrupt tree navigation in ways that make WBS elements silently disappear from displays and reports without any error message
  • Treating PRHI as an alternative source of truth for hierarchy level or parent-child relationships instead of PRPS - if a project was restructured through a mass tool, an interface, or an inconsistent transport, PRHI can lag behind while PRPS already reflects the new structure, and reports built on PRHI show stale hierarchy
  • Assuming a missing PSPNR row in PRHI means the WBS element was deleted - it usually means the hierarchy pointer buffer is stale and needs a structure reorganization, not that the WBS element itself no longer exists in PRPS
  • Expecting to find planned costs, actual costs, dates, or status information in PRHI - it carries none of that, and joining it into a cost or schedule report is wasted effort that should go to PRPS, PROJ, or the relevant CO tables instead
  • Writing custom hierarchy-traversal reports directly against PRHI's pointer structure instead of using the standard hierarchy processing function modules that already interpret it correctly - getting the pointer semantics slightly wrong produces indentation and grouping errors that are hard to spot and easy to blame on master data

Whose problem this is

A hierarchy inconsistency traced to PRHI is a technical PS or ABAP development question, not a functional configuration one. Functional PS consultants should keep working from PROJ, PRPS, and standard structure maintenance transactions, and escalate to the technical team or basis when a structure reorganization or pointer rebuild is needed.

Related SAP objects

Reviewed pages this object connects to in the ERPClimb knowledge graph.

Source: ERPClimb — https://erpclimb.com/sap-tables/prhiERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.