SAP PS Table Relationships

An interactive reference showing how SAP Project Systems tables connect across project definitions, WBS elements, networks, activities, milestones, budgets and status - in both SAP ECC and SAP S/4HANA.

The SAP Project Systems (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 Post

Interactive Data Model

Hover over any table to see its description, key fields and system compatibility. Purple nodes indicate object-status tables.

PS Transaction

Master Data

Status

Configuration

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	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
TCJ3	Network Profile	NETPR	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 systems 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

Watch demos View pricing Talk to our team