I_ENGMNTPROJPLANDATAWITHDRAFT

CDS View
31 Fields 2 CDS Views

Engagement Project Plan Data with Draft

I_ENGMNTPROJPLANDATAWITHDRAFT is a CDS View in S/4HANA. Engagement Project Plan Data with Draft. It contains 31 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EngmntProjPlnDataUnitVers view from BASIC Enagagement Project Plan Data Unit Version
P_EngmntProjPlanDataWithDraft view inner COMPOSITE

Fields (31)

KeyField CDS FieldsUsed in Views
KEY EmploymentInternalID EmploymentInternalID 2
KEY EngagementProject EngagementProject 1
KEY EngagementProjectResource EngagementProjectResource 2
KEY EngagementProjectResourceType EngagementProjectResourceType 2
KEY EngagementProjFinPlanUUID EngagementProjFinPlanUUID 2
KEY EngmtProjEmployeeIsStaffed EngmtProjEmployeeIsStaffed 2
KEY EngmtProjFinPlanVersion EngmtProjFinPlanVersion 2
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 2
KEY PlanLineItemUUID PlanLineItemUUID 1
KEY ResourceDemandUUID ResourceDemandUUID 2
KEY WorkItem WorkItem 2
KEY WorkPackage WorkPackage 2
KEY WorkPackageUUID WorkPackageUUID 2
ActualPlanDeviationCost ActualPlanDeviationCost 1
ActualPlanDeviationEffort ActualPlanDeviationEffort 1
ActualPlanDeviationRevenue ActualPlanDeviationRevenue 1
BillingControlCategory BillingControlCategory 2
Currency Currency 2
EngagementProjectServiceOrg EngagementProjectServiceOrg 2
EngmntProjPlanLineType EngmntProjPlanLineType 2
IsUnitBased IsUnitBased 2
ParentUnitDemandUUID ParentUnitDemandUUID 1
PlndCostAmt PlndCostAmt 1
PlndEffortQty PlndEffortQty 1
PlndRevnAmt PlndRevnAmt 1
ResourceDemand ResourceDemand 2
ResourceSupply ResourceSupply 1
SourceOfSupply SourceOfSupply 1
SupplySource SupplySource 1
UnitOfMeasure UnitOfMeasure 2

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.

-- Engagement Project Plan Data with Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ENGMNTPROJPLANDATAWITHDRAFT (
    EMPLOYMENTINTERNALID,
    ENGAGEMENTPROJECT,
    ENGAGEMENTPROJECTRESOURCE,
    ENGAGEMENTPROJECTRESOURCETYPE,
    ENGAGEMENTPROJFINPLANUUID,
    ENGMTPROJEMPLOYEEISSTAFFED,
    ENGMTPROJFINPLANVERSION,
    FISCALPERIOD,
    FISCALYEAR,
    PLANLINEITEMUUID,
    RESOURCEDEMANDUUID,
    WORKITEM,
    WORKPACKAGE,
    WORKPACKAGEUUID,
    ACTUALPLANDEVIATIONCOST,
    ACTUALPLANDEVIATIONEFFORT,
    ACTUALPLANDEVIATIONREVENUE,
    BILLINGCONTROLCATEGORY,
    CURRENCY,
    ENGAGEMENTPROJECTSERVICEORG,
    ENGMNTPROJPLANLINETYPE,
    ISUNITBASED,
    PARENTUNITDEMANDUUID,
    PLNDCOSTAMT,
    PLNDEFFORTQTY,
    PLNDREVNAMT,
    RESOURCEDEMAND,
    RESOURCESUPPLY,
    SOURCEOFSUPPLY,
    SUPPLYSOURCE,
    UNITOFMEASURE,
    PRIMARY KEY (EMPLOYMENTINTERNALID, ENGAGEMENTPROJECT, ENGAGEMENTPROJECTRESOURCE, ENGAGEMENTPROJECTRESOURCETYPE, ENGAGEMENTPROJFINPLANUUID, ENGMTPROJEMPLOYEEISSTAFFED, ENGMTPROJFINPLANVERSION, FISCALPERIOD, FISCALYEAR, PLANLINEITEMUUID, RESOURCEDEMANDUUID, WORKITEM, WORKPACKAGE, WORKPACKAGEUUID)
);

Learn More