/CPD/D_WORK_ITEM

Transparent Table Application Table
14 Fields 1 CDS Views

Work Item - #GENERATED#

/CPD/D_WORK_ITEM is an SAP database table in S/4HANA. Work Item - #GENERATED#. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_WorkPackageWorkItem view from BASIC

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
root_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
work_item_id /CPD/PFP_WORKITEM_ID Work Item ID
work_item_name /CPD/PFP_WORKITEM_NAME Work Item Name
work_item_is_inactive /CPD/WORK_ITEM_IS_INACTIVE Is Inactive
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
work_item_is_standard /CPD/WORK_ITEM_IS_STANDARD Is Standard
mp_id /CPD/MP_ID Cust Project ID
wp_id /CPD/PLAN_ITEM_ID Plan Item

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.

-- Work Item - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /CPD/D_WORK_ITEM (
    MANDT,                  -- Client [MANDT]
    DB_KEY,                 -- NodeID [/BOBF/CONF_KEY]
    ROOT_KEY,               -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,             -- NodeID [/BOBF/CONF_KEY]
    WORK_ITEM_ID,           -- Work Item ID [/CPD/PFP_WORKITEM_ID]
    WORK_ITEM_NAME,         -- Work Item Name [/CPD/PFP_WORKITEM_NAME]
    WORK_ITEM_IS_INACTIVE,  -- Is Inactive [/CPD/WORK_ITEM_IS_INACTIVE]
    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]
    WORK_ITEM_IS_STANDARD,  -- Is Standard [/CPD/WORK_ITEM_IS_STANDARD]
    MP_ID,                  -- Cust Project ID [/CPD/MP_ID]
    WP_ID,                  -- Plan Item [/CPD/PLAN_ITEM_ID]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More