I_ENGMNTPROJECTPLNDATAVERSION

CDS View
32 Fields 13 CDS Views

Engagement Project Plan Data Version

I_ENGMNTPROJECTPLNDATAVERSION is a CDS View in S/4HANA. Engagement Project Plan Data Version. It contains 32 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_EngmntProjStaffedResource view from CONSUMPTION Engagement Project Staffed Resource
I_CustomerProjectPlanData view from COMPOSITE Customer Project Planning Data
I_EngmntProjDmndSup view from COMPOSITE Engagement Project Demand Supply
I_EngmntProjNumberOfStaffRes view from COMPOSITE Number of Staffed Resource
P_EngmntProjDemands view inner CONSUMPTION Engagement Project Demands
P_EngmntProjPlnDataDrftUnion view from COMPOSITE
P_EngmntProjSupEmplDelivOrg view inner COMPOSITE
P_EngmtProjStaffedResource view from COMPOSITE
P_EngmtProjSuppliedUnsupplied view inner COMPOSITE
P_ExtSrvcProjWrkPckgDemdByPerd view from COMPOSITE
P_ExtSrvcProjWrkPckgPlnByPerd view from COMPOSITE
P_RSHBscStaffReqData view from CONSUMPTION Staffing Request Data Distributed
P_RSHStaffingRequestData view from COMPOSITE

Fields (32)

KeyField CDS FieldsUsed in Views
KEY EmploymentInternalID EmploymentInternalID,PersonnelNumber 8
KEY EngagementProjectResource EngagementProjectResource 6
KEY EngmtProjEmployeeIsStaffed Confirmed,CustProjWorkPckgEmplIsStaffed,EmployeeRequestIsStaffed,EngmtProjEmployeeIsStaffed 6
KEY FiscalPeriod FiscalPeriod 7
KEY FiscalYear FiscalYear 7
KEY ResourceDemandUUID ResourceDemandUUID 7
KEY WorkItem WorkItem 6
KEY WorkPackageUUID WorkPackageUUID 4
_EngagementProjectResource _EngagementProjectResource 1
_EngagementProjectServiceOrg _EngagementProjectServiceOrg 1
_EngmntProjResourceType _EngmntProjResourceType 1
_WorkItem _WorkItem 1
_WorkPackage _WorkPackage 1
ActualPlanDeviationCost ActualPlanDeviationCost 1
ActualPlanDeviationEffort ActualPlanDeviationEffort 1
ActualPlanDeviationRevenue ActualPlanDeviationRevenue 1
BillingControlCategory BillingControlCategory 4
Currency Currency 7
EngagementProject EngagementProject 6
EngagementProjectResourceType EngagementProjectResourceType 6
EngagementProjectServiceOrg EmployeeRequestDelivOrg,EngagementProjectServiceOrg 7
EngagementProjFinPlanUUID EngagementProjFinPlanUUID 4
EngmntProjPlanLineType EngmntProjPlanLineType 3
EngmtProjFinPlanVersion EngmtProjFinPlanVersion 5
PlndCostAmt CustProjWrkPckgPlanCost,PlndCostAmt 2
PlndEffortQty CustProjWrkPckgPlanEffortQty,EmployeeRequestDuration,PlndEffortQty 4
PlndRevnAmt CustProjWrkPckgPlanRevenue,PlndRevnAmt 2
ResourceDemand ResourceDemand 4
ResourceSupply ResourceSupply 2
SupplySource SourceOfSupply 1
UnitOfMeasure UnitOfMeasure 6
WorkPackage WorkPackage 9

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 Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ENGMNTPROJECTPLNDATAVERSION (
    EMPLOYMENTINTERNALID,
    ENGAGEMENTPROJECTRESOURCE,
    ENGMTPROJEMPLOYEEISSTAFFED,
    FISCALPERIOD,
    FISCALYEAR,
    RESOURCEDEMANDUUID,
    WORKITEM,
    WORKPACKAGEUUID,
    _ENGAGEMENTPROJECTRESOURCE,
    _ENGAGEMENTPROJECTSERVICEORG,
    _ENGMNTPROJRESOURCETYPE,
    _WORKITEM,
    _WORKPACKAGE,
    ACTUALPLANDEVIATIONCOST,
    ACTUALPLANDEVIATIONEFFORT,
    ACTUALPLANDEVIATIONREVENUE,
    BILLINGCONTROLCATEGORY,
    CURRENCY,
    ENGAGEMENTPROJECT,
    ENGAGEMENTPROJECTRESOURCETYPE,
    ENGAGEMENTPROJECTSERVICEORG,
    ENGAGEMENTPROJFINPLANUUID,
    ENGMNTPROJPLANLINETYPE,
    ENGMTPROJFINPLANVERSION,
    PLNDCOSTAMT,
    PLNDEFFORTQTY,
    PLNDREVNAMT,
    RESOURCEDEMAND,
    RESOURCESUPPLY,
    SUPPLYSOURCE,
    UNITOFMEASURE,
    WORKPACKAGE,
    PRIMARY KEY (EMPLOYMENTINTERNALID, ENGAGEMENTPROJECTRESOURCE, ENGMTPROJEMPLOYEEISSTAFFED, FISCALPERIOD, FISCALYEAR, RESOURCEDEMANDUUID, WORKITEM, WORKPACKAGEUUID)
);

Learn More