Some of these activities are also earmarked as Milestones in the project and based on the Milestone completion revenue generation can be initiates in Sales and Distribution by means of an invoice creation for the relevant Milestone using Milestone billing functionality. The duration which each activity takes and lead time or lag time between two activities are also available in the network. Networks contain lot of activities which are linked to each other by means of different relationship types. The method to find the status of WBS element using this field is dealt in the later part of this document.Ī project can also contain various networks. This field is the key field for finding the status of the WBS element. 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. Hence using this field all the WBS elements assigned a project can be easily found in any custom report. The project related to the WBS element can be obtained from the field PRPS-PSPHI. The table has the field PRPS-PSPNR has the WBS element number. The details pertaining to the WBS elements are available at the database table PRPS. The method to find out the status of the project is dealt in the later part of the document.Ī project can have many WBS elements assigned to it. This is the key field for finding the status of the project. 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. In this table the field PROJ-PSPNR represents the project number. The database table which contains the relevant information about the project is PROJ. The costs are revenues at the network or WBS level will finally accrue as the cost and revenue of the project. Project is at the highest level and WBS elements are networks are subordinates of the project. Each such deliverables can be used to plan costs and revenues, resources and capacities. In order to manage the project, the project is subdivided into various small deliverables called WBS elements or Work Breakdown Structures. Even in those modules some of these tables may be used, but the logic mentioned here explains the usage, logic and joins between these tables only in the perspective of PS.Ī project is initiated with the intention of creating a unique purpose it can be a product a service or combination of both. This document explains the logic only around the functionalities enabled in PS system, but not in any other modules like PP or PM.

However it is included wherever possible. Transaction codes for all the project elements.Detailed information about the module as such and the processes involved.

Costing related data as my knowledge level is very less in this area.

Detailed information about the elements of project though it is precisely mentioned for the purpose of understanding.

Connecting link between various database tables.

Database tables for each of the project elements.

Knowing the project structure and its elements along with the database tables will help the consultants to devise customized reports for various scenarios suiting to individual projects. In the light of this, it is very much important for consultants to know various elements of the project and how these elements are related to each other.

The module which aligns centrally to all the logistics modules in the planning, execution and management of capacities, resources and costs is Project System popularly called as PS. The modules involved in logistics in SAP are tightly integrated between each other and works seamlessly in an organization.

Activity table