/CPD/PWSC_MPTYP

Transparent Table Customizing Table
30 Fields 6 CDS Views

CPD: Master Project Type Table

/CPD/PWSC_MPTYP is an SAP database table in S/4HANA. CPD: Master Project Type Table. It contains 30 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_Engprojstatustemplate view inner BASIC View on Status Template customizing
I_MasterProjectScope view from BASIC Master Project Scopes
I_MasterProjectType view from BASIC Master Project Type
I_MstrProjKeyMember view inner BASIC Master Project Key Member
P_Mpeacmonthly view left_outer BASIC cds private view for monthly EAC values excluding curr month
P_Mpsingleplan view inner BASIC Master Project with Single Plan

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mp_type /cpd/pws_ws_mp_type Comm. Proj Type
mp_type_desc /cpd/pws_ws_mp_type_desc Type Description
org_unit_profile /cpd/pws_ws_org_unit_profile Organization Prof.
stg_prf /cpd/pws_ws_stg_prf Stage Profile
grprf_id /cpd/pws_grprf_id Rep. AttrProf.
view_id /cpd/is_view_id View ID
role_prf /cpd/pws_ws_rol_prf Role Profile
coding_type sched Project ID
status_template /cpd/pws_ws_template_id Sts Template
status_period /cpd/mp_status_period Status Period
alert_personalization_enable /cpd/pws_ws_alrt_pers_enable Enable Alert Pers.
contact_person /cpd/pws_ws_mp_contact_person Navigate to Contact
contact_prf_id /cpd/pws_ws_con_prf Contact Profile
contact_on_fly /cpd/pws_ws_mp_contact_on_fly Create Contact
hdr_status_report_template /cpd/pws_hdr_status_rpt_temp Hdr. Template
team_status_report_template /cpd/pws_team_status_rpt_temp Team. Template
check_access_prf /cpd/pws_ws_check_access_prf ActivateAccCtrl
financial_plan /cpd/pws_ws_financial_plan Financial Plan Type
prfid /cpd/pws_rcb_prfid Rate Profile
project_profile_id /cpd/pws_ws_ps_proj_prof PS Project Profile
profile_id /cpd/rm_sc_profile_id Profile ID
periv periv FY Variant
check_sf_prf /cpd/pws_ws_check_sf_prf Activate Scaling Factor
threshold_limit /cpd/pws_ws_threshold_limit PoC Threshold
threshold_value /cpd/pws_ws_threshold_value Threshold Value
threshold_value_to /cpd/pws_ws_threshold_value Threshold Value
cut_off_date /cpd/pws_cod_options Cut-Off Date
act_sales_int /cpd/pws_act_sales_int Sales Integration
pd_profile_id /cpd/pws_pd_profile_id PD Profile ID

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.

-- CPD: Master Project Type Table
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /CPD/PWSC_MPTYP (
    MANDT,                         -- Client [mandt]
    MP_TYPE,                       -- Comm. Proj Type [/cpd/pws_ws_mp_type]
    MP_TYPE_DESC,                  -- Type Description [/cpd/pws_ws_mp_type_desc]
    ORG_UNIT_PROFILE,              -- Organization Prof. [/cpd/pws_ws_org_unit_profile]
    STG_PRF,                       -- Stage Profile [/cpd/pws_ws_stg_prf]
    GRPRF_ID,                      -- Rep. AttrProf. [/cpd/pws_grprf_id]
    VIEW_ID,                       -- View ID [/cpd/is_view_id]
    ROLE_PRF,                      -- Role Profile [/cpd/pws_ws_rol_prf]
    CODING_TYPE,                   -- Project ID [sched]
    STATUS_TEMPLATE,               -- Sts Template [/cpd/pws_ws_template_id]
    STATUS_PERIOD,                 -- Status Period [/cpd/mp_status_period]
    ALERT_PERSONALIZATION_ENABLE,  -- Enable Alert Pers. [/cpd/pws_ws_alrt_pers_enable]
    CONTACT_PERSON,                -- Navigate to Contact [/cpd/pws_ws_mp_contact_person]
    CONTACT_PRF_ID,                -- Contact Profile [/cpd/pws_ws_con_prf]
    CONTACT_ON_FLY,                -- Create Contact [/cpd/pws_ws_mp_contact_on_fly]
    HDR_STATUS_REPORT_TEMPLATE,    -- Hdr. Template [/cpd/pws_hdr_status_rpt_temp]
    TEAM_STATUS_REPORT_TEMPLATE,   -- Team. Template [/cpd/pws_team_status_rpt_temp]
    CHECK_ACCESS_PRF,              -- ActivateAccCtrl [/cpd/pws_ws_check_access_prf]
    FINANCIAL_PLAN,                -- Financial Plan Type [/cpd/pws_ws_financial_plan]
    PRFID,                         -- Rate Profile [/cpd/pws_rcb_prfid]
    PROJECT_PROFILE_ID,            -- PS Project Profile [/cpd/pws_ws_ps_proj_prof]
    PROFILE_ID,                    -- Profile ID [/cpd/rm_sc_profile_id]
    PERIV,                         -- FY Variant [periv]
    CHECK_SF_PRF,                  -- Activate Scaling Factor [/cpd/pws_ws_check_sf_prf]
    THRESHOLD_LIMIT,               -- PoC Threshold [/cpd/pws_ws_threshold_limit]
    THRESHOLD_VALUE,               -- Threshold Value [/cpd/pws_ws_threshold_value]
    THRESHOLD_VALUE_TO,            -- Threshold Value [/cpd/pws_ws_threshold_value]
    CUT_OFF_DATE,                  -- Cut-Off Date [/cpd/pws_cod_options]
    ACT_SALES_INT,                 -- Sales Integration [/cpd/pws_act_sales_int]
    PD_PROFILE_ID,                 -- PD Profile ID [/cpd/pws_pd_profile_id]
    PRIMARY KEY (MANDT, MP_TYPE)
);

Learn More