I_EngmntProjFcstCube

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EngmntProjFcstCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IEPFCSTCUBE

CREATE VIEW I_EngmntProjFcstCube AS
SELECT
  cast(EngagementProject.EngagementProject as /cpd/project ) AS EngagementProject,
  EngagementProject.EngagementProjectName AS EngagementProjectName,
  EngagementProject.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  EngmntProjWrkPckgPlanActual.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  cast (WorkPackage.WorkPackage as /cpd/workpackage) AS WorkPackage,
  WorkPackage.WorkPackageName AS WorkPackageName,
  WorkPackage.WorkPackageStartDate AS WorkPackageStartDate,
  WorkPackage.WorkPackageEndDate AS WorkPackageEndDate,
  cast(EngmntProjWrkPckgPlanActual.WorkItem as /cpd/workitem ) AS WorkItem,
  EngmntProjWrkPckgPlanActual.EngagementProjectResourceType AS EngagementProjectResourceType,
  cast (EngmntProjWrkPckgPlanActual.EngagementProjectResource as /cpd/resource) AS EngagementProjectResource,
  EngmntProjWrkPckgPlanActual.FiscalPeriod AS FiscalPeriod,
  EngmntProjWrkPckgPlanActual.FiscalYear AS FiscalYear,
  EngmntProjWrkPckgPlanActual.FiscalYearPeriod AS FiscalYearPeriod,
  EngmntProjWrkPckgPlanActual.Currency AS Currency,
  cast(EngmntProjWrkPckgPlanActual.PlndCostAmt as /cpd/plan_cost) AS PlndCostAmt,
  cast(EngmntProjWrkPckgPlanActual.ActlCostAmt as /cpd/actual_cost) AS ActlCostAmt,
  cast(EngmntProjWrkPckgPlanActual.SupplyEffortQty as /cpd/planned_effort) AS SupplyEffortQty,
  EngmntProjWrkPckgPlanActual.UnitOfMeasure AS UnitOfMeasure,
  cast(EngmntProjWrkPckgPlanActual.PlndEffortQty as /cpd/planned_effort) AS PlndEffortQty,
  cast(EngmntProjWrkPckgPlanActual.ActlEffortQty as /cpd/actual_effort) AS ActlEffortQty,
  EngmntProjWrkPckgPlanActual.ActualPlanDeviationCost AS ActualPlanDeviationCost,
  EngmntProjWrkPckgPlanActual.ActualPlanDeviationEffort AS ActualPlanDeviationEffort,
  EngmntProjWrkPckgPlanActual.EngagementProjectServiceOrg AS EngmntProjectDeliveryOrg,
  WorkPackage.SalesOrder AS SalesOrder,
  WorkPackage.SalesOrderItem AS SalesOrderItem,
  _SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
  EngmntProjWrkPckgPlanActual.EngmntProjPlanLineType AS EngmntProjPlanLineType
FROM I_EngagementProject AS EngagementProject
INNER JOIN I_EngagementProjFinancialPlan AS EngagementProjFinancialPlan ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkPackage AS WorkPackage ON /* join condition not captured in parsed metadata */
INNER JOIN I_WrkPckgPlnActlMappg AS EngmntProjWrkPckgPlanActual ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrderItem = _SalesOrderItem.SalesOrderItem AND SalesOrder = _SalesOrderItem.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectResource AS _EngagementProjectResource ON EngagementProjectResource = _EngagementProjectResource.EngagementProjectResource AND EngagementProjectResourceType = _EngagementProjectResource.EngagementProjectResourceType  -- association [0..1]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkItem ON WorkItem = _WorkItem.WorkItem AND WorkPackage = _WorkItem.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EngmntProjectDeliveryOrg ON EngmntProjectDeliveryOrg = _EngmntProjectDeliveryOrg.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EngagementProjectSrvcOrg ON EngagementProjectServiceOrg = _EngagementProjectSrvcOrg.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN I_EngmntProjResourceType AS _EngagementProjectResourceType ON EngagementProjectResourceType = _EngagementProjectResourceType.EngagementProjectResourceType  -- association [0..1]
;