Skip to Content
Product Information

SAP Commercial Project Management – Tables

Hello friends,

SAP Commercial Project Management (SAP CPM) has been around for quite sometime now and it is tightly integrated with other SAP modules.

The Master Project in CPM can be linked to a PS Project or PPM Item or Sales Order.

The financial Planning Values can be transferred over to PS.

SAP CPM revolves around its Master Project. It is the main binding factor. All the information can be traced back to the Master Project.

In this blog post, I have listed down the tables for SAP CPM Master Project and Financial Plan..

The following are the Tables for Master Project in SAP CPM.

CPM Master Project
Table Name Description
/CPD/D_MP_ATTA_S Status Report Attachments
/CPD/D_MP_ATTACH Master Project Attachments
/CPD/D_MP_CONTAC Master Project contact person
/CPD/D_MP_HDR Master Project Header
/CPD/D_MP_HDR_S Master Project Header Short Text
/CPD/D_MP_ITEM Master Project  Structure  Elements
/CPD/D_MP_MEMBER Project Member
/CPD/D_MP_PROJ_8 Qualification of Project Member
/CPD/D_MP_PROJ_9 Qualification of Project Member
/CPD/D_MP_PROJ10 Qualification of Project Member – #GENERAT
/CPD/D_MP_REP_AT Reporting Attribute Node
/CPD/D_MP_RESP Responsibility Node
/CPD/D_MP_ST_ARV Table for Status Area version
/CPD/D_MP_ST_HRA Status Header Area
/CPD/D_MP_ST_REF Master Project Status reference – #GENERATED
/CPD/D_MP_ST_VHR Status Versions
/CPD/D_MP_STATUS Status Header
/CPD/D_MP_TEAM Team
/CPD/D_MP_TEAM_M Team Member Subnode
/CPD/D_MP_TEAM_R Team Role Subnodes
/CPD/D_MP_TM_RES Responsibility assigned to a Team
/CPD/D_MP_TMSKL Table for storing skill

To understand it .. Let’s see it with an example.. Below is the screenshot of a SAP CPM Master Project which is linked to a SAP PS Project.

SAP%20CPM%20Master%20Project

SAP CPM Master Project

 

Now If we want to check to which PS Object this Master Project is linked to from the DB tables, we need to do the following..

Go to Table /CPD/D_MP_HDR and get the DB Key for the master project ID. By passing the Master Project ID in the field MP_ID

Pass the DB key in the  /CPD/D_MP_ITEM table in field Node ID (Parent Key) and not in the DB_KEY field. 🙂

The Item Key field in this table stores the Value for the PS Project. And the field Related Object link gives the logical relation.

To get the Project Number you can pass the Item Key Value to Table Project in field OBJNR

Similarly We can get the linkage between the Master Project and its financial Plan from the following Tables

CPM Financial Plan
Table Name Description
/CPD/D_PFP_ANCH Anchor
/CPD/D_PFP_MS Mapped Structure
/CPD/D_PFP_OPLOG Reference Object error log table
/CPD/D_PFP_PA Plan Attachment
/CPD/D_PFP_PER Plan Exchange Rate
/CPD/D_PFP_PH Plan Header
/CPD/D_PFP_PH_KF Mapped Key Figure
/CPD/D_PFP_PHTXT Plan Header Description Text
/CPD/D_PFP_PLNBL Table for Planable Field of Plan Structure
/CPD/D_PFP_PS Plan Structure
/CPD/D_PFP_PV Plan Version
/CPD/D_PFP_PVTXT Plan Version Description Text
/CPD/D_PFP_RES Plan Details for Resources – #GENERATED#

Hope it helps..

Cheers !!

Sammar

1 Comment
You must be Logged on to comment or reply to a post.