I_EngmntProjFcstCube_2

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_2.
-- 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: IEPFCSTCUBE2
-- Parameters: P_Language : sylangu

CREATE VIEW I_EngmntProjFcstCube_2 AS
SELECT
  cast(EngmntProjWrkPckgPlanActual.EngagementProject as /cpd/project ) AS EngagementProject,
  EngagementProject.EngagementProjectName AS EngagementProjectName,
  EngmntProjWrkPckgPlanActual.CustomerProjectServiceOrg AS EngagementProjectServiceOrg,
  EngmntProjWrkPckgPlanActual.ProjectProfileCode AS ProjectProfileCode,
  EngmntProjWrkPckgPlanActual.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  EngmntProjWrkPckgPlanActual.LastChangeDateTime AS LastChangeDateTime,
  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.SupplyEffortQty as /cpd/planned_effort) AS SupplyEffortQty,
  case when EngmntProjWrkPckgPlanActual.EngagementProjectResourceType != '0SRV' then EngmntProjWrkPckgPlanActual.UnitOfMeasure end as UnitOfMeasure AS UnitOfMeasureendasUnitOfMeasure,
  EngmntProjWrkPckgPlanActual.ActualPlanDeviationCost AS ActualPlanDeviationCost,
  EngmntProjWrkPckgPlanActual.ActualPlanDeviationEffort AS ActualPlanDeviationEffort,
  EngmntProjWrkPckgPlanActual.EngagementProjectServiceOrg AS EngmntProjectDeliveryOrg,
  EngmntProjWrkPckgPlanActual.SalesOrder AS SalesOrder,
  EngmntProjWrkPckgPlanActual.SalesOrderItem AS SalesOrderItem,
  SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
  SalesOrderItem.WBSElement AS WBSElement,
  SalesOrderItem.WBSElementInternalID AS WBSElementInternalID,
  _WBSElementBasicData_2.WBSElementExternalID AS WBSElementExternalID,
  EngmntProjWrkPckgPlanActual.EngmntProjPlanLineType AS EngmntProjPlanLineType,
  case when WorkPackage.WorkPackageType = 'U' then WorkPackage.WorkPackageType else '' end as WorkPackageType AS WorkPackageTypeelseendasWorkPackageType,
  EngmntProjWrkPckgPlanActual.ProjectVisibility AS ProjectVisibility,
  EngmntProjWrkPckgPlanActual.IsMyProject AS IsMyProject,
  EngmntProjWrkPckgPlanActual.TotalNetAmount AS RevenueAsSoldAmount,
  EngmntProjWrkPckgPlanActual.EngagementProjectType AS EngagementProjectType,
  EngmntProjWrkPckgPlanActual.EngagementProjectStage AS EngagementProjectStage,
  EngmntProjWrkPckgPlanActual.EngagementProjectCategory AS EngagementProjectCategory,
  EngmntProjWrkPckgPlanActual.Customer AS Customer,
  EngmntProjWrkPckgPlanActual.ControllingArea AS ControllingArea,
  EngmntProjWrkPckgPlanActual.ProfitCenter AS ProfitCenter,
  cast(EngmntProjWrkPckgPlanActual.EngagementProjectCostCenter as kostl) AS CostCenter,
  EngmntProjWrkPckgPlanActual.EngmntProjectHeaderCompanyCode AS CompanyCode
FROM I_EngagementProject AS EngagementProject
INNER JOIN I_EngagementProjFinancialPlan AS EngagementProjFinancialPlan ON /* join condition not captured in parsed metadata */
INNER JOIN P_EngmntProjPlnActlAsSoldRevn AS EngmntProjWrkPckgPlanActual ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkPackage AS WorkPackage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngmntProjUnitCompltnPct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesOrderItem AS SalesOrderItem 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_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectStage AS _EngagementProjectStage ON EngagementProjectStage = _EngagementProjectStage.EngagementProjectStage  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- 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_UnitOfMeasure AS _WorkPackageUnitUoM ON WorkPackageUnitUoM = _WorkPackageUnitUoM.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]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElement = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData_2 ON WBSElementInternalID = _WBSElementBasicData_2.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_EngmntProjFinPlanStatus AS _EngmntProjFinPlanStatus ON EngagementProjectReviewStatus = _EngmntProjFinPlanStatus.EngagementProjectReviewStatus  -- association [0..1]
;