Important SAP PS Tables (Project System): PROJ, PRPS …

SAP PS Tables contains the list of SAP PS (Project System) module with the SAP PS Relationship between the main tables.

Find also the list of SAP PS Main Tables.

  • SAP PS Main Tables
  • SAP PS Tables Diagram

Main SAP PS Tables

When dealing with tables in SAP PS, you should first know these both table:

SAP PROJ Project Table

  • SAP PRPS table : SAP Work Center Table
  • The key for a Project in SAP PS PROJ is PROJ-PSPNR for Project definition (internal).

SAP PRPS Work Center Table

  • SAP PROJ table: SAP Project Table
  • Note that the keys for a PRPS for Work Center Table in SAP PS is PRPS-PSPNR for WBS Element.
  • The link between PROJ and PRPS is based on PROJ-PSPHI = PRPS-OBJNR.

List of Main Tables in SAP PS

The main Tables is SAP PS ( Project System) are :

Table Description
IMAK Appropriation requests ? general data
IMAV Appropriation request variant
IMPR Investment Program Positions
IMPU Texts for cap. inv. program positions
IMTP Investment programs
PMCO Cost structure of maintenance order
PRHI Work Breakdown Structure/ Edges (Hierarchy Pointer)
PROJ Project definition
PRPS WBS (Work Breakdown Structure) Element Master Data
PRTE Scheduling of WBS elements
AFVC Operation within an order Activities
AFVV Scheduling of Activities
AFRU Activity Confirmations
EVPOC Percentage of completion
BPJA Total costs for Annual period CO Object (WBS related Budgets)
RPSCO WBS and Activities /Network related Actual costs
CAUFV View Orders (PP/CO)- Networks

If you want to go further with SAP PS Module, check this book: Project Management with SAP Project System

Network Table in SAP PS

In SAP PS, The Network Table is RPSCO. It stores all notification’s related data to WBS, Activities and Network Related to Actual Costs.

Other SAP Network Tables in PS (Project System)

  • AFAB – network – Relationships
  • NPTX – PS Texts (Network)
  • TCA41 – Default values for standard networks and profiles
  • PLTX – PS Texts (Library network)
  • VSNPTX_CN – Version: PS texts (network)

You may check also

SAP PS Tables Mini Diagram

The following Diagram represents the relationship between the main SAP PS Tables

You can download the SAP PS Main Tables PDF Diagram here.

This PDF SAP PS Diagram Table regroups the SAP Project System Data model (simplified) with the keys required to join between the different Tables in SAP PS.

SAP PS tables Detailed Diagram

Here you can be found a detailed Diagram of SAP PS Tables with join keys between the different Table

SAP PS Tables Diagram