CPD_PLANDATA_DFT

Transparent Table Application Table
40 Fields 1 CDS Views

I_ENGAGEMENTPROJECTPLANDATATP I_ENGAGEMENTPROJECTPLANDATATP

CPD_PLANDATA_DFT is an SAP database table in S/4HANA. I_ENGAGEMENTPROJECTPLANDATATP I_ENGAGEMENTPROJECTPLANDATATP. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EngmntProjPlanDrftData view from BASIC Engagement Project Plan Data With Draft

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
planlineitemuuid /CPD/PLANNING_LINE_GUID Planning Line GUID
engmtprojfinplanversion /CPD/PFP_VERSION_ID Plan Version ID
engagementproject /CPD/ENG_MP_ID Engmnt Project ID
workpackageuuid /CPD/WP_DB_KEY Work Package UUID
engagementprojectresourcetype /CPD/PFP_RES_TYPE_ID ResourceTypeID
engagementprojectresource /CPD/PFP_RESOURCE_ID Resource ID
fiscalperiod CO_PERIO Period
fiscalyear GJAHR Fiscal Year
employmentinternalid HROBJID Object ID
engmtprojemployeeisstaffed /CPD/SC_CONF Confirmation of staffed Employee
workitem /CPD/PFP_WORKITEM_ID Work Item ID
engagementprojectserviceorg /CPD/PWS_WS_ORG_UNIT_ID Service Org.
resourcedemanduuid /CPD/DEMAND_KEY Demand Key
engagementprojectuuid /CPD/ENG_DB_KEY Engmnt Project UUID
engagementprojfinplanuuid /CPD/ENG_PFP_DB_KEY Engagement Project
engmntprojplanlinetype /CPD/LINE_TYPE Line type
resourcedemand /CPD/DEMAND_ID Resource Demand
resourcesupply /CPD/SUPPLY_ID Resource Supply
billingcontrolcategory BILLGCTRLCAT Billing Category
sourceofsupply /CPD/SOURCE_OF_SUPPLY Source of Supply
workpackage /CPD/PLAN_ITEM_ID Plan Item
workpackagename /CPD/PLAN_ITEM_NAME Plan Item Desc.
workpackagestartdate /CPD/PFP_START_DATE Start Date
workpackageenddate /CPD/PFP_END_DATE End Date
currency /CPD/PFP_CURRENCY Plan Currency
unitofmeasure CO_MEINH Unit of Measure
plndcostamt /CPD/PFP_CURR Amount
plndeffortqty MEGXXX Total Quantity
plndrevnamt /CPD/PFP_CURR Amount
actualplandeviationcost /CPD/COST_DEVIATION Cost Deviation
actualplandeviationeffort /CPD/EFFORT_DEVIATION Effort Deviation
actualplandeviationrevenue /CPD/REVENUE_DEVIATION Revenue Deviation
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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.

-- I_ENGAGEMENTPROJECTPLANDATATP I_ENGAGEMENTPROJECTPLANDATATP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPD_PLANDATA_DFT (
    MANDT,                          -- Client [MANDT]
    DRAFTUUID,                      -- Key [/BOBF/UUID]
    PLANLINEITEMUUID,               -- Planning Line GUID [/CPD/PLANNING_LINE_GUID]
    ENGMTPROJFINPLANVERSION,        -- Plan Version ID [/CPD/PFP_VERSION_ID]
    ENGAGEMENTPROJECT,              -- Engmnt Project ID [/CPD/ENG_MP_ID]
    WORKPACKAGEUUID,                -- Work Package UUID [/CPD/WP_DB_KEY]
    ENGAGEMENTPROJECTRESOURCETYPE,  -- ResourceTypeID [/CPD/PFP_RES_TYPE_ID]
    ENGAGEMENTPROJECTRESOURCE,      -- Resource ID [/CPD/PFP_RESOURCE_ID]
    FISCALPERIOD,                   -- Period [CO_PERIO]
    FISCALYEAR,                     -- Fiscal Year [GJAHR]
    EMPLOYMENTINTERNALID,           -- Object ID [HROBJID]
    ENGMTPROJEMPLOYEEISSTAFFED,     -- Confirmation of staffed Employee [/CPD/SC_CONF]
    WORKITEM,                       -- Work Item ID [/CPD/PFP_WORKITEM_ID]
    ENGAGEMENTPROJECTSERVICEORG,    -- Service Org. [/CPD/PWS_WS_ORG_UNIT_ID]
    RESOURCEDEMANDUUID,             -- Demand Key [/CPD/DEMAND_KEY]
    ENGAGEMENTPROJECTUUID,          -- Engmnt Project UUID [/CPD/ENG_DB_KEY]
    ENGAGEMENTPROJFINPLANUUID,      -- Engagement Project [/CPD/ENG_PFP_DB_KEY]
    ENGMNTPROJPLANLINETYPE,         -- Line type [/CPD/LINE_TYPE]
    RESOURCEDEMAND,                 -- Resource Demand [/CPD/DEMAND_ID]
    RESOURCESUPPLY,                 -- Resource Supply [/CPD/SUPPLY_ID]
    BILLINGCONTROLCATEGORY,         -- Billing Category [BILLGCTRLCAT]
    SOURCEOFSUPPLY,                 -- Source of Supply [/CPD/SOURCE_OF_SUPPLY]
    WORKPACKAGE,                    -- Plan Item [/CPD/PLAN_ITEM_ID]
    WORKPACKAGENAME,                -- Plan Item Desc. [/CPD/PLAN_ITEM_NAME]
    WORKPACKAGESTARTDATE,           -- Start Date [/CPD/PFP_START_DATE]
    WORKPACKAGEENDDATE,             -- End Date [/CPD/PFP_END_DATE]
    CURRENCY,                       -- Plan Currency [/CPD/PFP_CURRENCY]
    UNITOFMEASURE,                  -- Unit of Measure [CO_MEINH]
    PLNDCOSTAMT,                    -- Amount [/CPD/PFP_CURR]
    PLNDEFFORTQTY,                  -- Total Quantity [MEGXXX]
    PLNDREVNAMT,                    -- Amount [/CPD/PFP_CURR]
    ACTUALPLANDEVIATIONCOST,        -- Cost Deviation [/CPD/COST_DEVIATION]
    ACTUALPLANDEVIATIONEFFORT,      -- Effort Deviation [/CPD/EFFORT_DEVIATION]
    ACTUALPLANDEVIATIONREVENUE,     -- Revenue Deviation [/CPD/REVENUE_DEVIATION]
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More