/CPD/PWSC_ORGPID

Transparent Table Customizing Table
6 Fields 4 CDS Views

Table for ORg. Unit type, Key and ID

/CPD/PWSC_ORGPID is an SAP database table in S/4HANA. Table for ORg. Unit type, Key and ID. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CustprojsrvcOrgDetails view from BASIC Customer Project Service Org Details
I_EngagementProjectSrvcOrgDets view from BASIC Engagement Project Service Organization Details
I_EngmntProjSrvcOrgDetails view from BASIC Engagement Project Service Organization Details
R_ProjSrvcOrgCostCenter view_entity from BASIC Cost Center

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY org_unit_typ /CPD/PWS_WS_ORG_UNIT_TYP Org. Unit Type
KEY org_unit_key /CPD/PWS_WS_ORG_UNIT_KEY Org. Unit Key
KEY org_unit_id /CPD/PWS_WS_ORG_UNIT_ID Service Org.
org_unit_key_desc /CPD/PWS_WS_ORG_UNIT_KEY_DESC OrgUnit Desc.
default_val /CPD/PWS_WS_ORG_DEFAULT Default

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.

-- Table for ORg. Unit type, Key and ID
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /CPD/PWSC_ORGPID (
    MANDT,              -- Client [MANDT]
    ORG_UNIT_TYP,       -- Org. Unit Type [/CPD/PWS_WS_ORG_UNIT_TYP]
    ORG_UNIT_KEY,       -- Org. Unit Key [/CPD/PWS_WS_ORG_UNIT_KEY]
    ORG_UNIT_ID,        -- Service Org. [/CPD/PWS_WS_ORG_UNIT_ID]
    ORG_UNIT_KEY_DESC,  -- OrgUnit Desc. [/CPD/PWS_WS_ORG_UNIT_KEY_DESC]
    DEFAULT_VAL,        -- Default [/CPD/PWS_WS_ORG_DEFAULT]
    PRIMARY KEY (MANDT, ORG_UNIT_TYP, ORG_UNIT_KEY, ORG_UNIT_ID)
);

Learn More