/CPD/D_PFP_PS

Transparent Table Application Table
29 Fields 8 CDS Views

Plan Structure

/CPD/D_PFP_PS is an SAP database table in S/4HANA. Plan Structure. It contains 29 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
E_CustomerProjectWorkPackage view from EXTENSION Customer Project Workpackage
E_PPM_EngagementProjElmnt view from EXTENSION Engagement project element - Extension
E_Workpackage view from EXTENSION WorkPackage Extension View
I_CustProjWrkPckgText view from BASIC Customer Project Work Packge Text
I_WorkPackage view from BASIC Work Package
I_WorkPackageAll view from BASIC All Work Package
P_WorkPackageWorkItem view inner BASIC
SHSM_WBS_WORK_PACK_V view inner cds view for search help H_WBS_WORK_PACKAGE

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
plan_item_id /CPD/PLAN_ITEM_ID Plan Item
plan_item_name /CPD/PLAN_ITEM_NAME Plan Item Desc.
object_type /CPD/PFP_OBJECT_TYPE Object Type
tree_parent_key /BOBF/CONF_KEY NodeID
is_deleted BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
is_leaf BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
expanded BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
children_loaded BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
mapped_item_id /CPD/OBJECT_ID Object ID
mapped_item_desc /CPD/NAME Object Name
node_id RSHIENODID HierNode ID
t_level RSTLEVEL Node level
parent_id RSPARENT ID superior node
child_id RSCHILD Child Node ID
next_id RSNEXT ID of the next node
start_date /CPD/PFP_START_DATE Start Date
end_date /CPD/PFP_END_DATE End Date
so_item_id POSNR_VA Item
sales_order_hdr VBELN_VA Sales Document
plan_item_bill_typ /CPD/PLAN_ITEM_BILL_TYP Plan Item Billing Type
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
ref_object_guid /BOBF/CONF_KEY NodeID
plan_item_type /CPD/PLAN_ITEM_TYPE Work Package Type

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.

-- Plan Structure
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /CPD/D_PFP_PS (
    MANDT,               -- Client [MANDT]
    DB_KEY,              -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,          -- NodeID [/BOBF/CONF_KEY]
    PLAN_ITEM_ID,        -- Plan Item [/CPD/PLAN_ITEM_ID]
    PLAN_ITEM_NAME,      -- Plan Item Desc. [/CPD/PLAN_ITEM_NAME]
    OBJECT_TYPE,         -- Object Type [/CPD/PFP_OBJECT_TYPE]
    TREE_PARENT_KEY,     -- NodeID [/BOBF/CONF_KEY]
    IS_DELETED,          -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    IS_LEAF,             -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    EXPANDED,            -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    CHILDREN_LOADED,     -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    MAPPED_ITEM_ID,      -- Object ID [/CPD/OBJECT_ID]
    MAPPED_ITEM_DESC,    -- Object Name [/CPD/NAME]
    NODE_ID,             -- HierNode ID [RSHIENODID]
    T_LEVEL,             -- Node level [RSTLEVEL]
    PARENT_ID,           -- ID superior node [RSPARENT]
    CHILD_ID,            -- Child Node ID [RSCHILD]
    NEXT_ID,             -- ID of the next node [RSNEXT]
    START_DATE,          -- Start Date [/CPD/PFP_START_DATE]
    END_DATE,            -- End Date [/CPD/PFP_END_DATE]
    SO_ITEM_ID,          -- Item [POSNR_VA]
    SALES_ORDER_HDR,     -- Sales Document [VBELN_VA]
    PLAN_ITEM_BILL_TYP,  -- Plan Item Billing Type [/CPD/PLAN_ITEM_BILL_TYP]
    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]
    REF_OBJECT_GUID,     -- NodeID [/BOBF/CONF_KEY]
    PLAN_ITEM_TYPE,      -- Work Package Type [/CPD/PLAN_ITEM_TYPE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More