SAP PS (Project Systems) Module (I) - In Simple Words.

The Project System (PS) module of SAP is specifically designed to provide comprehensive and fully integrated project management functionality for SAP customers. A Project is a complex undertaking, bringing with it huge data of different type.

If somebody asks you to develop report in PS module what basic information do you need? Mainly you need to find out below things:
  • Master tables and their relationship with each other.
  • Standard transactions in PS module.

Here we explain the logic only around the functionalities enabled in PS system.

Elements Of Project 

A project is initiated with the intention of creating a unique purpose; it can be a product a service or combination of both.

Part I - SAP PS (Project Systems) Module - Functional Knowledge For ABAPer

In order to manage the project, the project is subdivided into various small deliverables called WBS elements or Work Breakdown Structures. Each such deliverables can be used to plan costs and revenues, resources and capacities. 


Project is at the highest level and WBS elements and networks are subordinates of the project. Project Definition is general description of the project that you want to manage. 

Frequently used Project Systems transaction codes for Project Definition are: 

The database table which contains the relevant information about the project is PROJ. In this table the field PROJ-PSPNR represents the project number. There is also another field PROJ-OBJNR is an important field as this field serves as the foreign key for making any queries at the project level. This is the key field for finding the status of the project. The method to find out the status of the project is dealt in the later part of the document. 

WBS Elements

A project can have many WBS elements assigned to it. The details pertaining to the WBS elements are available at the database table PRPS. The table has the field PRPS-PSPNR has the WBS element number. The project related to the WBS element can be obtained from the field PRPS-PSPHI. Hence using this field all the WBS elements assigned a project can be easily found in any custom report. 

The table PRPS also has got another field called PRPS-OBJNR which is the linking field to any other tables containing various information related to the WBS element. This field is the key field for finding the status of the WBS element. The method to find the status of WBS element using this field is dealt in the later part of this document. 

Frequently used Project Systems transaction codes for WBS element are: 

Network Header

A project can also contain various networks. Networks contain lot of activities which are linked to each other by means of different relationship types. The duration which each activity takes and lead time or lag time between two activities are also available in the network. In a network enabled business scenario, all the details of the project like Schedule, cost, capacity and reservations will flow from network to the higher level structures like WBS element and project. 

Various features of the network and their underlying database tables are discussed below here:

The database table AUFK contains the network header related information. Some of the important fields available in this table are listed one by one as follows. 

The field AUFK-AUFNR represents the network number created in the system. 

The field AUFK-OBJNR is a field which will be used as a foreign key in case this table needs to be linked with some other table. 

The field AUFK-PSPEL represents the WBS element which is linked to the network at the header level. However if the business scenario involves activities within the network, this field may not be of much use as each activity can have different WBS elements of the same project. This field assumes importance if the networks are used without activities. 

In case of assembly processing, where a network is created from a sales order using standard project elements the fields AUFK-KDAUF and AUFK-KDPOS represents the sales order number and line item respectively which triggered the network. These fields are seen in the network header in the fields Sales Order Number and Sales Order Item in the Assignments tab. 

There is also another table CAUFV which is similar to AUFK but CAUFV has some other additional information related to costing etc. The table CAUFV is very important because this table is the central table using which all the other network related tables are accessed. Some of the important fields in this table are discussed below. 

The field CAUFV-AUFNR represents the network number which is same as AUFK-AUFNR.

The field CAUFV-AUFPL represents the connecting link between all the related tables. The field which is read as “Routing number of Operations in the Order” is the main field to be used for any join using this table. 

Frequently used Project Systems transaction codes for Network are: 

Network Activities

The details pertaining to network activities can be obtained from the table AFVC. When a network number is known it should be passed as CAUFV-AUFNR and the resultant CAUFV-AUFPL and CAUFV-BEDID should be obtained. 

Now the value of CAUFV-AUFPL should be passed as AFVC-AUFPL and AFVC-BEDID respectively. The resultant list gives the list of all the activities of the network. 
Various fields and their importance are provided in detail below.

The field AFVC-VORNR refers to the activity number of the activity in the network. This number can serve as the foreign key in many of the tables associated with the network activities. However there are also other fields which can serve as foreign keys in different tables. 

The field AFVC-APLZL refers to the counter number of the activity. This is an important field when the network relationships are to be found out. 

The data pertaining to planned cost for primary cost activities can also be found in this table in the fields AFVC- PRKST for the planned cost and AFVC- SAKTO for the cost element against which the cost is planned.

There is also another table AFVCP where AFVCP-AUFPL = CAUFV-AUFPL using which the WBS element assigned to each of the activities can be found out. 

Frequently used Project Systems transaction codes for Network Activity are:

tags: Functional For ABAP, SAP ABAP PS Module, SAP Project Systems, SAP Project Systems basics, sap project systems overview, sap project systems process flow, SAP PS, SAP PS ABAP, sap ps module, sap ps tutorial, sap project system tables, sap ps tables, sap ps module overview,


Also Read...