/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
P_Mpsingleplan view inner BASIC

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