CPD_PLANDATA_DFT

Transparent Table Application Table
35 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 35 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 (35)

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

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]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More