SAP Data Models|Project System
SAP PS table relationships in one interactive diagram
How SAP Project System tables connect across project definitions, WBS elements, networks, activities, milestones, budgets and status, in both SAP ECC and SAP S/4HANA.
Trusted by 500+ enterprises. Read and write SAP data from any analytics or data platform.
SAP PS Table Relationships
An interactive reference showing how SAP Project System tables connect across project definitions, WBS elements, networks, activities, milestones, budgets and status - in both SAP ECC and SAP S/4HANA.
The SAP Project System (PS) module stores project-hierarchy and execution data across related tables covering project definitions, WBS elements, networks and activities, milestones, budgets, actual costs, and object status. Understanding how these tables join together is essential for building project cost reports, earned-value analyses, milestone tracking, budget-vs-actual dashboards and capital-project portfolio views.
Use the diagram below to explore table relationships visually, or scroll to the quick-reference guide for a complete list of tables, join keys and system compatibility. PS reuses the Order Master (AUFK) and order tables (AFKO, AFVC, AFVV, AFRU, RESB) shared with PP, and integrates with CO via COEP for actual cost postings. The data model is consistent between ECC and S/4HANA.
Read the Full Blog PostInteractive Data Model
Hover over any table to see its description, key fields and system compatibility. Purple nodes indicate object-status tables.
Quick-Reference Guide
All SAP PS tables shown above with their primary join keys and SAP system compatibility.
| Table | Description | Primary Join Keys | System |
|---|---|---|---|
| Project Structure - Master Data | |||
| PROJ | Project Definition (top of WBS hierarchy) | PSPNR | ECC + S/4HANA |
| PRPS | WBS Element | PSPNR | ECC + S/4HANA |
| PRHI | Project Hierarchy (parent/sibling links) | PSPNR, POSNR | ECC + S/4HANA |
| PRTE | WBS Scheduling Data | PSPNR | ECC + S/4HANA |
| MLST | Milestone (on WBS or network activity) | MLNR | ECC + S/4HANA |
| Network - Transactional | |||
| AUFK | Order Master Data (network header is an order) | AUFNR | ECC + S/4HANA |
| AFKO | Order Header (Network) | AUFNR | ECC + S/4HANA |
| AFVC | Network Activity (Operation) | AUFPL, APLZL | ECC + S/4HANA |
| AFVV | Activity Quantities/Dates/Values | AUFPL, APLZL | ECC + S/4HANA |
| AFRU | Activity Confirmations | RUECK, RMZHL | ECC + S/4HANA |
| RESB | Network Reservations / Components | RSNUM, RSPOS | ECC + S/4HANA |
| Budget & Costs - Transactional | |||
| BPJA | Budget Annual Values | OBJNR, GJAHR, WRTTP, VERSN | ECC + S/4HANA |
| BPEG | Budget line items (overall values) | LEDNR, OBJNR, GJAHR | ECC + S/4HANA |
| COEP | CO Document Line Items (actuals - shared with FICO) | KOKRS, BELNR, BUZEI | ECC + S/4HANA |
| COSP | Cost Totals (external postings) | OBJNR, GJAHR, WRTTP, VERSN | ECC + S/4HANA |
| Object Status | |||
| JEST | Individual Object Status (active/inactive) | OBJNR, STAT | ECC + S/4HANA |
| JCDS | Status Change Documents (history) | OBJNR, STAT, CHGNR | ECC + S/4HANA |
| TJ02 / TJ02T | System Status (code + text) | ISTAT / ISTAT, SPRAS | ECC + S/4HANA |
| TJ30 | User Status (in status profile) | STSMA, ESTAT | ECC + S/4HANA |
| Configuration | |||
| T001W | Plants | WERKS | ECC + S/4HANA |
| TCJ41 | Project Profile | PROFL | ECC + S/4HANA |
| TCN41 | Network Profile | PROFIDNETZ | ECC + S/4HANA |
Related Resources
Explore more SAP content from DVW Analytics.
SAP PS Tables Blog Post
Detailed descriptions of every table shown in this diagram, with practical tips for building project system analytics workflows.
DVW Help Centre
Guides and documentation for the DVW Connector for SAP, DVW Flow Tool and other DVW products. Available to free trial and paid users.
Try it free for 30 days
Free 30-day trial. Full functionality. No commitment.
Start Your Free Trial