在SAP EPPM解决方案中,CPM是三大核心组件之一,而CPM其中一块核心功能就是项目前端报价,借助CPM可以让用户通过Excel与系统的交互从而更便捷地去做项目成本测算。
在CPM中首先需要创建Master Project,在Master Project下可以创建不同版本的Financial Plan用于不同场景下的成本测算,Financial Plan中也可以搭建成本测算结构,在报价阶段统称为Bid Structure,后续PS中的项目可以与CPM建立关联关系后在CPM中也可以根据PS的结构生成执行的Commecial Project Structure实现更多与PS数据上的交互。
CPM核心底表介绍:
Master Project:
/CPD/D_MP_HDR: Master Project Header(主要包含Master Project ID,项目类别,阶段、货币等数据。)
/CPD/D_MP_HDR_S:Master Project Short Text(主要包含Master Project相关描述)
/CPD/D_MP_ITEM:Master Project Structure Elements(主要包含了对应的PS项目定义对象号信息)
Master Project不同底表主要通过DB_KEY字段进行关联
Financial Plan:
/CPD/D_PFP_PH: Plan Header(主要包含了Financial Plan的IP,计划场景、计划类别等数据)
/CPD/D_PFP_PS:Plan Structure(主要包含了Financial Plan具体的结构层级信息等)
/CPD/D_PFP_PV:Plan Version(主要包含了Financial Plan版本相关信息,如版本描述、版本类别等)
Master Project和Financial Plan相关底表,主要通过MP_ID_INT进行关联。
Master Project详细底表清单:
/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
Financial Plan底表详细清单:
/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#