/CPD/D_MP_HDR

Transparent Table Application Table
44 Fields 23 CDS Views

Master Project Header

/CPD/D_MP_HDR is an SAP database table in S/4HANA. Master Project Header. It contains 44 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
E_CustomerProject view from EXTENSION Customer Project
E_Internalproject view from EXTENSION Extension View for Internal Project
E_MasterProject view from EXTENSION Extension view for Master Project
E_PPM_EngagementProject view from EXTENSION Engagement project - Extension
FNDEI__cpd_d_mp_hdr_BLOCKINGIN view from Filter View for table /CPD/D_MP_HDR
FNDEI__cpd_d_mp_hdr_FILTER view from Filter View for table /CPD/D_MP_HDR
I_EngagementProjectBasic view from BASIC Header Information of Engagement Project
I_EngagementProjectHeader view from BASIC Engagement Project Header
I_MasterProject view from BASIC Master Project
I_Mpattachment view from BASIC Master Project Attachment
I_MstrProjKeyMember view from BASIC Master Project Key Member
P_EngagementProject view from BASIC
P_EngagementProjectHeader view from BASIC
P_EngagementProjectItem view inner BASIC
P_Engagementprojectmail view from BASIC
P_ENGMTPROJSDM view from BASIC
P_Mpeacmonthly view left_outer BASIC
P_Mpsingleplan view from BASIC
P_MstrProjAlertMSC view from BASIC
P_MstrProjBillPlanBAP view inner BASIC
P_MstrProjBillPlanFixed view inner BASIC
P_MstrProjBILLPLANRRB view inner BASIC
P_Riskmanagement view inner BASIC

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
mp_id /CPD/MP_ID Cust Project ID
mp_type /CPD/PWS_WS_MP_TYPE Comm. Proj Type
mp_stage /CPD/PWS_WS_MP_STG Stage
start_date /CPD/MP_START_DATE Start Date
end_date /CPD/MP_END_DATE End Date
customer /CPD/PWS_MP_CUST_NO Customer
org_id /CPD/PWS_WS_ORG_UNIT_ID Service Org.
confidential /CPD/PWS_WS_CONFIDENTIAL_FLAG Confidential
proj_manager_id abap.numc
project_type /CPD/SS_PROJ_TYPE Project Type
proj_mgr_bupa_id /CPD/PWS_WS_BU_PARTNER Business Partner
proj_currency /CPD/PWS_WS_CURC Currency
overall_status_id /CPD/PWS_WS_STATUS_KEY_FIG Status
cut_off_date /CPD/PWS_CUT_OFF_DATE Cut-Off Date
created_by /BOFU/USER_ID_CREATED_BY Created By
created_on /BOFU/TSTMP_CREATION_TIME Created On
changed_by /BOFU/USER_ID_CHANGED_BY Changed By
changed_on /BOFU/TSTMP_CHANGED_TIME Changed On
country LAND1 Country/Reg.
region REGIO Region
active /CPD/PWS_WS_ACTIVE Active
int_inspect_date /CPD/PWS_WS_INT_INSPECT_DATE Int. Inspection
ext_inspect_date /CPD/PWS_WS_EXT_INSPECT_DATE Ext. Inspection
work_type /CPD/PWS_WS_WORK_TYPE Type of Work
industry /CPD/PWS_WS_INDUSTRY Industry
proj_risk /CPD/PWS_WS_PROJ_RISK Project Risk
fin_risk /CPD/PWS_WS_FIN_RISK Financial Risk
tech_risk /CPD/PWS_WS_TECH_RISK Technical Risk
indic /CPD/PWS_WS_INDIC Progress
cr_relevant /CPD/PWS_WS_CR_REL Change Req. Relevant
overall_risk /CPD/PWS_WS_PROJ_RISK Project Risk
ey PS_PRART Proj.type
cost_center /CPD/PWS_WS_ORG_UNIT_KEY Org. Unit Key
profit_center /CPD/PWS_WS_PROFIT_CENTER Profit Center
template BOOLE_D TRUE
is_mpid_copied BOOLE_D TRUE
archiving_status /BOFU/ARCHIVING_STATUS_CODE Archiving Stat.
restrict_time_posting /CPD/RESTRICT_TIME_POSTING Restrict Unstaffed
use_project_billing /CPD/INVOICING_SOLUTION Invoicing Solution
data_model_version /CPD/DATA_MODEL_VERSION Data Model Version
pm_bupa_id /CPD/PWS_WS_BU_PARTNER Business Partner
pm_bupa_name abap.strg

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Master Project Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /CPD/D_MP_HDR (
    MANDT,                  -- Client [MANDT]
    DB_KEY,                 -- NodeID [/BOBF/CONF_KEY]
    MP_ID,                  -- Cust Project ID [/CPD/MP_ID]
    MP_TYPE,                -- Comm. Proj Type [/CPD/PWS_WS_MP_TYPE]
    MP_STAGE,               -- Stage [/CPD/PWS_WS_MP_STG]
    START_DATE,             -- Start Date [/CPD/MP_START_DATE]
    END_DATE,               -- End Date [/CPD/MP_END_DATE]
    CUSTOMER,               -- Customer [/CPD/PWS_MP_CUST_NO]
    ORG_ID,                 -- Service Org. [/CPD/PWS_WS_ORG_UNIT_ID]
    CONFIDENTIAL,           -- Confidential [/CPD/PWS_WS_CONFIDENTIAL_FLAG]
    PROJ_MANAGER_ID,        -- abap.numc
    PROJECT_TYPE,           -- Project Type [/CPD/SS_PROJ_TYPE]
    PROJ_MGR_BUPA_ID,       -- Business Partner [/CPD/PWS_WS_BU_PARTNER]
    PROJ_CURRENCY,          -- Currency [/CPD/PWS_WS_CURC]
    OVERALL_STATUS_ID,      -- Status [/CPD/PWS_WS_STATUS_KEY_FIG]
    CUT_OFF_DATE,           -- Cut-Off Date [/CPD/PWS_CUT_OFF_DATE]
    CREATED_BY,             -- Created By [/BOFU/USER_ID_CREATED_BY]
    CREATED_ON,             -- Created On [/BOFU/TSTMP_CREATION_TIME]
    CHANGED_BY,             -- Changed By [/BOFU/USER_ID_CHANGED_BY]
    CHANGED_ON,             -- Changed On [/BOFU/TSTMP_CHANGED_TIME]
    COUNTRY,                -- Country/Reg. [LAND1]
    REGION,                 -- Region [REGIO]
    ACTIVE,                 -- Active [/CPD/PWS_WS_ACTIVE]
    INT_INSPECT_DATE,       -- Int. Inspection [/CPD/PWS_WS_INT_INSPECT_DATE]
    EXT_INSPECT_DATE,       -- Ext. Inspection [/CPD/PWS_WS_EXT_INSPECT_DATE]
    WORK_TYPE,              -- Type of Work [/CPD/PWS_WS_WORK_TYPE]
    INDUSTRY,               -- Industry [/CPD/PWS_WS_INDUSTRY]
    PROJ_RISK,              -- Project Risk [/CPD/PWS_WS_PROJ_RISK]
    FIN_RISK,               -- Financial Risk [/CPD/PWS_WS_FIN_RISK]
    TECH_RISK,              -- Technical Risk [/CPD/PWS_WS_TECH_RISK]
    INDIC,                  -- Progress [/CPD/PWS_WS_INDIC]
    CR_RELEVANT,            -- Change Req. Relevant [/CPD/PWS_WS_CR_REL]
    OVERALL_RISK,           -- Project Risk [/CPD/PWS_WS_PROJ_RISK]
    EY,                     -- Proj.type [PS_PRART]
    COST_CENTER,            -- Org. Unit Key [/CPD/PWS_WS_ORG_UNIT_KEY]
    PROFIT_CENTER,          -- Profit Center [/CPD/PWS_WS_PROFIT_CENTER]
    TEMPLATE,               -- TRUE [BOOLE_D]
    IS_MPID_COPIED,         -- TRUE [BOOLE_D]
    ARCHIVING_STATUS,       -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
    RESTRICT_TIME_POSTING,  -- Restrict Unstaffed [/CPD/RESTRICT_TIME_POSTING]
    USE_PROJECT_BILLING,    -- Invoicing Solution [/CPD/INVOICING_SOLUTION]
    DATA_MODEL_VERSION,     -- Data Model Version [/CPD/DATA_MODEL_VERSION]
    PM_BUPA_ID,             -- Business Partner [/CPD/PWS_WS_BU_PARTNER]
    PM_BUPA_NAME,           -- abap.strg
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More