Project Systems
Hierarchical structure and Table links
Swarna S
Page 1 of 9
Introduction
This document provides the basic hierarchical structure of the Project Systems
module in SAP .The document also defines the terminologies used frequently in
the Project Systems module. Also the tables used in the module with the links are
diagrammatically presented which will be useful to technical people for
customised development.
Page 2 of 9
Hierarchical Structure of the Project Definition
SUB WBS
Page 3 of 9
A few Definitions of the terminologies used in PS module
Project:
The project definition is the binding framework for all organizational elements within a
project.
Work Break down Structure:
With a work breakdown structure you can divide the project into useful steps, specify fixed or
"basic" dates, specify the work involved, and determine project costs.
The individual levels of the hierarchy in a work breakdown structure enable you to organize a
project into steps.
Work Break Down Structure Element (Sub WBS):
You can further break down these steps into individual elements
Maximum steps supported are 99.
Network:
It is a special type work order on which cost can be planned, controlled and monitored.
Activities:
These are the actual tasks that are to be executed for the completion of the project.
Page 4 of 9
Frequently used Tables in Project Systems Module:
Scheduling Tables:
PROJ (Project PRPS (WBS Element PRTE (Scheduling
Definition) Master Data) WBS elements)
PROJ-PSPNR = PRPS-PSPHI PRPS-PSPNR = PRTE-POSNR
PRPS-PSPHI = PRTE-PSPHI
PRHI (WBS Element AFVC (Operation CAUFV (View
Hierarchy Pointer) within an order Orders PP/CO -
Activities) Networks)
PRPS-PSPNR = PRHI-POSNR PRPS-PSPNR = AFVC-PROJN AFVC-AUFPL = CAUFV-AUFPL
AFVV (Scheduling
of Activities)
AFVC-AUFPL = AFVV-AUFPL
AFVC-APLZL = AFVV-APLZL
Page 5 of 9
Percentage of Completion Tables:
PROJ (Project PRPS (WBS Element
Definition) Master Data)
PROJ-PSPNR = PRPS-PSPHI
PRHI (WBS Element AFVC (Operation CAUFV (View
Hierarchy Pointer) within an order Orders PP/CO -
Activities) Networks)
PRPS-PSPNR = PRHI-POSNR PRPS-PSPNR = AFVC-PROJN AFVC-AUFPL = CAUFV-AUFPL
EVPOC (Percentage
of Completion)
AFVC-OBJNR = EVPOC-OBJNR
AFRU (Activity
Confirmations)
AFVC-AUFPL = AFRU-AUFPL
Page 6 of 9
Costs Tables in PS:
Budget / Revenue/Planned Costs:
PROJ (Project PRPS (WBS Element
Definition) Master Data)
PROJ-PSPNR = PRPS-PSPHI
PRHI (WBS Element BPJA (Total Costs
Hierarchy Pointer) for Annual Period
CO object)
PRPS-PSPNR = PRHI-POSNR PRPS-OBJNR = BPJA-OBJNR
In all these costs only the value of the field VORGA (Budget/Planning Category) and is
changed as per the requirement. These values change as per the configuration too so this has to
be taken into consideration
VORGA Category
KSTP Planned Cost
KSTR Planned revenue
KBUD Budget
KNB0 Supplementary Budget
Page 7 of 9
Actual Costs:
PROJ (Project PRPS (WBS Element
Definition) Master Data)
PROJ-PSPNR = PRPS-PSPHI
PRPS-OBJNR = RPSCO-OBJNR
(Project/WBS related Costs)
RPSCO (WBS and
PRHI (WBS Element AFVC (Operation Activities/Network
Hierarchy Pointer) within an order related Actual Costs)
Activities)
PRPS-PSPNR = PRHI-POSNR PRPS-PSPNR = AFVC-PROJN AFVC-OBJNR = RPSCO-OBJNR
(Activities/network related Actual Costs)
CAUFV (View
Orders PP/CO -
Networks)
AFVC-AUFPL = CAUFV-AUFPL
Here in Actual Costs another important feature is that
The Field VORGA in the RPSCO table should contain all the business transactions pertaining
to CO objects from COIE to COIN and the Value of ACPOS (which is configured through
SPRO and value may change accordingly) is not of Revenue category and WRTTP ,value type
field takes a standard value of 4 for Actual costs.
Page 8 of 9
Material Assignment Tables:
PROJ (Project PRPS (WBS Element
Definition) Master Data)
PROJ-PSPNR = PRPS-PSPHI
PRPS-PSPNR = EBKN-PS_PSP_PNR
EBKN (Purchase
PRHI (WBS Element AFVC (Operation Requisition Account
Hierarchy Pointer) within an order Assignment)
Activities)
PRPS-PSPNR = PRHI-POSNR PRPS-PSPNR = AFVC-PROJN CAUFV-AUFNR = EBKN-NPLNR
CAUFV (View
Orders PP/CO -
Networks)
AFVC-AUFPL = CAUFV-AUFPL
Page 9 of 9
