SAP tableObjectPRPSModulePS

PRPS table — PRPS WBS Element Master Data Table

PRPS stores one row per WBS element, the basic master data record for a work breakdown structure item: its external identifier POSID, its internal number PSPNR, the project it belongs to via PSPHI, organizational assignments, the responsible person, and the object number used to link to status, cost, and budget tables. It holds no cost or budget values itself.

PRPS is the master data table for WBS elements in Project Systems, one row per element regardless of hierarchy level. This page covers the fields consultants actually query, how PRPS joins to the project header, hierarchy, budget and cost tables, and the recurring mistakes people make when they treat this master data table as if it carried values.

Published 16 Sept 2026· 1,113 words

What it stores

Each row in PRPS is one WBS element: a single node in a project's work breakdown structure, whether that is the top element of the project or a leaf-level element several levels down. The row carries identifying and organizational data only - what the element is called, which project it belongs to, which company code and controlling area it is assigned to, who is responsible, what level it sits at - and a generated object number that acts as the key into every other part of the system that needs to know something happened against this WBS element. It does not carry planned costs, actual costs, or budget figures. Those live in separate CO and PS value tables keyed by the same object number. A WBS element that has been created but never posted to still has a full row here.

Key fields

  • MANDT - client
  • PSPNR - WBS element internal number, the technical key used by almost every other table that references a WBS element
  • POSID - WBS element identifier as displayed to the user, formatted according to the project's edit mask
  • PSPHI - internal number of the top WBS element of the project this element belongs to, links back to the project definition
  • PBUKR - company code
  • PKOKR - controlling area
  • PRART - project type
  • STUFE - level of this element in the WBS hierarchy
  • VERNR - personnel number of the person responsible for the element
  • OBJNR - object number, the key used to find status, cost, and budget records for this element
  • ERDAT - creation date
  • LOEVM - deletion indicator

How it joins the data model

  • PRPS-PSPHI = PROJ-PSPNR, the top WBS element of every row points back to the project definition
  • PRPS-PSPNR = PRHI-PSPNR, the hierarchy table that carries the up/down pointers defining parent-child structure between elements
  • PRPS-OBJNR joins to status tables (JEST for active system statuses, JCDS for status history)
  • PRPS-OBJNR joins to CO cost totals tables such as COSPD (and the classic COSP/COSS totals) for actual and plan values posted to the element
  • PRPS-OBJNR joins to budget tables BPGE (overall/total values) and BPJA (annual values)

How to read it safely

Always restrict on MANDT implicitly through the standard client handling, but do the real filtering on PSPHI when the goal is every element of one project, or on PBUKR plus PKOKR when scoping by organizational unit. Selecting on POSID with a wildcard is risky because the display format depends on the project profile's edit mask, so the same element can appear with or without separator characters depending on where the value came from. Never scan PRPS without at least one of PSPHI, PBUKR, or a PSPNR range - on a system with a long-running PS implementation this table can carry a large number of rows across many projects and years. If the entry point is a cost or budget posting, start from OBJNR and go backward into PRPS rather than starting from POSID text matching.

How to prove it in the data

A user reports that a WBS element cannot be used for posting. Look up PRPS by POSID (or PSPNR if already known) to get OBJNR, then check JEST for that object number to see the active system status - a status like technically complete or closed with the posting-blocking business transaction attached will confirm why postings are rejected, independent of anything in PRPS itself which never shows status directly.

ECC vs S/4HANA

PRPS continues to exist as a transparent table in S/4HANA and remains the primary master data table for WBS elements under classic Project Systems. Newer project management capabilities introduced in S/4HANA, such as enterprise project management built on different data objects, do not replace PRPS for projects created and maintained through the traditional PS transactions - those still write to PRPS exactly as in ECC. No compatibility view is needed for basic reads against this table in a classic PS context.

Common pitfalls

  • Assuming PRPS holds cost or budget amounts. It does not - it is pure master data, values are in the CO totals tables and the PS budget tables, both reached through OBJNR
  • Confusing PSPNR and POSID. Most other tables that reference a WBS element store PSPNR, not the human-readable POSID, so a join written against POSID against another table usually returns nothing
  • Treating LOEVM as proof the element is gone. A deletion flag set in PRPS means the element is marked for deletion, not that it has been archived or removed; it can still carry postings from before the flag was set and can still appear in older reports
  • Reading STUFE as an authoritative hierarchy. The level field can be out of step with the actual parent-child structure if the hierarchy was rebuilt or elements were moved; PRHI is the source of truth for structure, PRPS just carries a cached level value
  • Expecting one row to represent the whole project. Every WBS element, at every level, gets its own row - the project definition itself lives in PROJ, not in PRPS, and PSPHI is the only pointer connecting a PRPS row back to it
  • Matching on POSID text without accounting for the edit mask. Two systems, or two projects with different profiles, can render the same logical element with different separator characters, breaking naive string comparisons

Whose problem this is

The PS module consultant or project controller owns questions about WBS master data content, hierarchy structure, and status. Cost and budget value discrepancies reached through PRPS-OBJNR joins are usually a joint PS/CO question, since the values themselves are owned by controlling but the object structure they post against is owned by PS.

Related SAP objects

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

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