I_ENGMNTPROJPLANDRFTDATA

CDS View

Engagement Project Plan Data With Draft

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EngmntProjPlnDataDrftUnion view left_outer COMPOSITE
P_EngmntProjPlnDataDrftUnion view union_all COMPOSITE

Fields (27)

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

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_ENGMNTPROJPLANDRFTDATA (
    ACTUALPLANDEVIATIONCOST,
    ACTUALPLANDEVIATIONEFFORT,
    ACTUALPLANDEVIATIONREVENUE,
    BILLINGCONTROLCATEGORY,
    CURRENCY,
    EMPLOYMENTINTERNALID,
    ENGAGEMENTPROJECTRESOURCE,
    ENGAGEMENTPROJECTRESOURCETYPE,
    ENGAGEMENTPROJECTSERVICEORG,
    ENGAGEMENTPROJFINPLANUUID,
    ENGMNTPROJPLANLINETYPE,
    ENGMTPROJEMPLOYEEISSTAFFED,
    ENGMTPROJFINPLANVERSION,
    FISCALPERIOD,
    FISCALYEAR,
    HASACTIVEENTITY,
    PLNDCOSTAMT,
    PLNDEFFORTQTY,
    PLNDREVNAMT,
    RESOURCEDEMAND,
    RESOURCEDEMANDUUID,
    RESOURCESUPPLY,
    SUPPLYSOURCE,
    UNITOFMEASURE,
    WORKITEM,
    WORKPACKAGE,
    WORKPACKAGEUUID
);