I_EngmntProjectReviewDataCube

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_EngmntProjectReviewDataCube.
-- 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: IEPREVDATACUBE
-- Parameters: P_Language : sylangu, P_Date : sydatum, P_FiscalYearPeriod : fis_jahrper

CREATE VIEW I_EngmntProjectReviewDataCube AS
SELECT
  lookupEntity: 'I_FiscalCalendarDate' AS lookupEntityI_FiscalCalendarDate,
  resultElement: 'FiscalYearPeriod' AS resultElementFiscalYearPeriod,
  binding: [ { targetElement : 'CalendarDate' , type : #PARAMETER , value : 'P_Date' AS P_Language,
  P_Date : $parameters.P_Date AS P_Date,
  _EngagementProject.EngagementProjectName AS EngagementProjectName,
  ProjectReview.EngagementProjectType AS EngagementProjectType,
  ProjectReview.Customer AS Customer,
  ProjectReview.CustomerName AS CustomerName,
  ProjectReview.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  ProjectReview.AddressID AS AddressID,
  cast('' as ad_persnum ) AS AddressPersonID,
  cast('' as ad_nation ) AS AddressRepresentationCode,
  ProjectReview.ProjectStartDate AS ProjectStartDate,
  ProjectReview.ProjectEndDate AS ProjectEndDate,
  ProjectReview.ProjectLastChangedDateTime AS ProjectLastChangedDateTime,
  ProjectReview.EngagementProjectStage AS EngagementProjectStage,
  ProjectReview.EngagementProjectCategory AS EngagementProjectCategory,
  EngagementProjOverallStatus.EngagementProjectStatus AS EngagementProjectStatus,
  cast(EngagementProjOverallStatus.CreationDateTime as /cpd/cpm_createdon preserving type ) AS LastChangeDateTime,
  ProjectReview.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  ProjectReview.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  ProjectReview.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  cast(ProjectReview.EngmntProjReviewYearPeriod as /cpd/pfp_review_year_period ) AS EngmntProjReviewYearPeriod,
  ProjectReview.EngmntProjReviewYear AS EngmntProjReviewYear,
  ProjectReview.EngmntProjReviewPeriod AS EngmntProjReviewPeriod,
  ProjectReview.FiscalYearVariant AS FiscalYearVariant,
  ProjectReview.SalesOrder AS SalesOrder,
  ProjectReview.SalesOrderItem AS SalesOrderItem,
  ProjectReview.SalesDocumentItemText AS SalesOrderItemText,
  ProjectReview.SalesDocumentItemCategory AS SalesOrderItemCategory,
  ProjectReview.TotalNetAmount AS TotalNetAmount,
  ProjectReview.WorkPackage AS WorkPackage,
  ProjectReview.WorkItem AS WorkItem,
  ProjectReview.WorkPackageType AS WorkPackageType,
  ProjectReview.WorkPackageName AS WorkPackageName,
  ProjectReview.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  ProjectReview.WorkPackageStartDate AS WorkPackageStartDate,
  ProjectReview.WorkPackageEndDate AS WorkPackageEndDate,
  ProjectReview.IsDeleted AS IsDeleted,
  ProjectReview.WorkPackageUnit AS WorkPackageUnit,
  ProjectReview.WorkPackageUnitText AS WorkPackageUnitText,
  ProjectReview.EngagementProjectResourceType AS EngagementProjectResourceType,
  ProjectReview.EngagementProjectResource AS EngagementProjectResource,
  ProjectReview.EngmntProjectDeliveryOrg AS EngmntProjectDeliveryOrg,
  ProjectReview.Currency AS Currency,
  UnitOfMeasure,
  ProjectReview.WorkPackageUnitUoM AS WorkPackageUnitUoM,
  IsUnitBased,
  ResourceIsOfUnitWorkPackage,
  ActlEffortQty,
  ActualEffortUpToFsclYrPerd,
  ActualEffortUpToCurPerd,
  ActlEffortQtyUpToRevPerd,
  ActualUnitQty,
  AddlResourceActualQuantity,
  AddlRsceUpToCurPerdActlQty,
  AddlRsceUpToRevPerdActlQty,
  AddlRsceUpToFsclPerdActlQty,
  cast(ProjectReview.ActlCostAmt as /cpd/actual_cost preserving type ) AS ActlCostAmt,
  ActualCostUpToCurPerd,
  ActlCostAmtUpToRevPerd,
  ActualCostUpToFsclYrPerd,
  ActlUnitUpToFsclPerdQty,
  ActualExpenseCost,
  ActlExpCostUpToCurPerd,
  ActlExpenseCostUpToRevPerd,
  ActlExpenseCostUpToFsclYrPerd,
  ProjectReview.PlanUnitQuantity AS PlanUnitQuantity,
  SupplyEffortQty,
  PlndEffortQty,
  PlndEffortQtyUpToRevPerd,
  PlndEffortUpToCurPerd,
  PlndEffortUpToFsclYrPerd,
  cast(ProjectReview.ActualPlanDeviationEffort as /cpd/effort_deviation preserving type ) AS ActualPlanDeviationEffort,
  AddlResourcePlannedQuantity,
  AddlRsceActlPlanDeviationQty,
  cast(ProjectReview.PlndCostAmt as /cpd/plan_cost preserving type ) AS PlndCostAmt,
  cast(ProjectReview.ActualPlanDeviationCost as /cpd/cost_deviation preserving type ) AS ActualPlanDeviationCost,
  PlannedCostUpToFsclYrPerd,
  PlannedEffortCostAmt,
  PlannedCostUpToCurPerd,
  AddlResourcePlannedCostAmount,
  PlndCostAmtUpToRevPerd,
  cast(ProjectReview.PlndRevnAmt as /cpd/plan_revenue preserving type ) AS PlndRevnAmt,
  PlndRevnAmtUpToRevPerd,
  PlannedRevnUpToCurPerd,
  PlannedRevnUpToFsclYrPerd,
  PlannedExpenseCost,
  PlndExpenseCostUpToRevPerd,
  PlndExpCostUpToCurPerd,
  PlndExpenseCostUpToFsclYrPerd,
  ActualPlanDeviationExpnCost,
  BaselinePlndEffortQty,
  BaselinePlannedQuantity,
  BaselinePlndCostAmt,
  BaselinePlndRevnAmt,
  AdjustedRemainingExpnCost,
  AdjustedRemainingEffort,
  AdjustedRemainingEffortCost,
  AdjustedRemainingCostPlnAmt,
  AddlRsceEstToCmpltQty,
  AddlRsceEstToCmpltCostAmount,
  EstToCmpltCostUpToCurPerd,
  EstToCmpltCostUpToRevPerd,
  EstToCmpltUpToFsclPerdAmt,
  AddlRsceEtcUpToCurPerdQty,
  AddlRsceEtcUpToRevPerdQty,
  AddlRsceEstToCmpltUpToFsclQty,
  AddlRsceEtcCostUpToRevPerdAmt,
  AddlRsceEtcCostUpToCurPerdAmt,
  AddlRsceEstToCmpltUpToFsclAmt,
  EstToCmpltEffortUpToRevPerd,
  EstToCmpltEffortUpToCurPerd,
  EstToCmpltUpToFsclPerdQty,
  EstToCmpltEffCostUpToCurPerd,
  EstToCmpltEffCostUpToRevPerd,
  EstToCmpltEffUpToFsclPerdAmt,
  EstToCmpltExpnCostUpToCurPerd,
  EstToCmpltExpnCostUpToRevPerd,
  EstToCmpltExpnUpToFsclPerdAmt,
  EstimateAtCompletionCost,
  EstAtCompltnCostUpToCurPerd,
  EstAtCompltnCostUpToRevPerd,
  EstAtCompltnUpToFsclPerdAmt,
  EstAtCompltnEffortUpToCurPerd AS EstAtCmpltEffortUpToCurPerdQty,
  EstAtCompltnEffortUpToRevPerd AS EstAtCmpltEffortUpToRevPerdQty,
  EstAtCmpltUpToFsclPerdQty,
  EstimateAtCompletionEffort,
  AddlRsceEstAtCompltnQty,
  EstimateAtCompletionExpnCost,
  EstAtCmpltExpnUpToFsclPerdAmt,
  EstAtCmpltExpnUpToCurPerdAmt,
  EstAtCmpltExpnUpToRevPerdAmt,
  DerivedEstAtCompltnCostUpToCur,
  DerivedEstAtCompltnCostUpToRev,
  DerivdEstAtCompltnUpToFsclAmt,
  IsMyProject,
  ProjectReview.ProjectManager AS ProjectManager,
  ProjectReview.ProjectManagerName AS ProjectManagerName,
  ProjectReview.ProjectManagerExternalID AS ProjectManagerExternalID,
  ProjectReview.ProjectAccountant AS ProjectAccountant,
  ProjectReview.ProjectAccountantName AS ProjectAccountantName,
  ProjectReview.ProjectAccountantExternalID AS ProjectAccountantExternalID,
  ProjectReview.ProjectController AS ProjectController,
  ProjectReview.ProjectControllerName AS ProjectControllerName,
  ProjectReview.ProjectControllerExternalID AS ProjectControllerExternalID,
  ProjectReview.ProjectPartner AS ProjectPartner,
  ProjectReview.ProjectPartnerName AS ProjectPartnerName,
  ProjectReview.ProjectPartnerExternalID AS ProjectPartnerExternalID,
  ProjectReview.Ledger AS Ledger,
  ProjectReview.ProjectVisibility AS ProjectVisibility,
  ProjectReview.ProjectProfileCode AS ProjectProfileCode,
  ProjectReview.EngmntProjectHeaderCompanyCode AS EngmntProjectHeaderCompanyCode,
  ProjectReview.EngagementProjectCostCenter AS EngagementProjectCostCenter,
  ProjectReview.ProfitCenter AS ProfitCenter
FROM P_EngmntProjReviewDataWthSales
LEFT OUTER JOIN I_EngagementProjOverallStatus AS EngagementProjOverallStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngmtProjFinPlanVersion AS _EngmtProjFinPlanVersion ON EngagementProjFinPlanUUID = _EngmtProjFinPlanVersion.EngagementProjFinPlanUUID AND EngmtProjFinPlanVersion = _EngmtProjFinPlanVersion.EngmtProjFinPlanVersion  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectHeader AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- 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_SalesDocumentItemCategory AS _SalesDocumentItemCategory ON SalesOrderItemCategory = _SalesDocumentItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_EngmntProjCustInfo 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_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_EngmtProjStatusMaster AS _EngagementProjectStatus ON EngagementProjectStatus = _EngagementProjectStatus.EngagementProjectStatus  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- 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_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 E_CustomerProject AS _Extension ON EngagementProject = _Extension.CustomerProject  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYear AS _FiscalYear ON FiscalYearVariant = _FiscalYear.FiscalYearVariant AND EngmntProjReviewYear = _FiscalYear.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriod AS _FiscalYearPeriod ON EngmntProjReviewPeriod = _FiscalYearPeriod.FiscalPeriod AND EngmntProjReviewYear = _FiscalYearPeriod.FiscalYear AND FiscalYearVariant = _FiscalYearPeriod.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_EngmntProjFinPlanStatus AS _EngmntProjFinPlanStatus ON EngagementProjectReviewStatus = _EngmntProjFinPlanStatus.EngagementProjectReviewStatus  -- 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_EngmntProjResourceType AS _EngagementProjectResourceType ON EngagementProjectResourceType = _EngagementProjectResourceType.EngagementProjectResourceType  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EngagementProjectSrvcOrg ON EngagementProjectServiceOrg = _EngagementProjectSrvcOrg.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EngmntProjectDeliveryOrg ON EngmntProjectDeliveryOrg = _EngmntProjectDeliveryOrg.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _CustomerAddress ON AddressID = _CustomerAddress.AddressID AND AddressPersonID = _CustomerAddress.AddressPersonID AND AddressRepresentationCode = _CustomerAddress.AddressRepresentationCode  -- association [0..1]
LEFT OUTER JOIN I_AddressPersonName AS _AddressPersonName ON AddressPersonID = _AddressPersonName.AddressPersonID AND AddressRepresentationCode = _AddressPersonName.AddressRepresentationCode  -- association [0..1]
LEFT OUTER JOIN I_AddressRepresentation AS _AddressRepresentationCode ON AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode  -- association [0..1]
;