C_ProjectCostPrediction

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 C_ProjectCostPrediction.
-- 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: CPROJCOSTPREDICT
-- Parameters: P_PlanningCategory : fcom_category

CREATE VIEW C_ProjectCostPrediction AS
SELECT
  name: 'C_CostCategoryVH' AS nameC_CostCategoryVH,
  element: 'PlanningCategory' AS Project,
  _Proj.ProjectUUID AS ProjectUUID,
  _Proj.ProjectInternalID AS ProjectInternalID,
  _Proj.CompanyCode AS CompanyCode,
  _Responsible.BusinessPartnerFullName AS BusinessPartnerFullName,
  _Responsible.BusinessPartnerUUID AS BusinessPartnerUUID,
  _ProjCostLineItems.GlobalCurrency AS GlobalCurrency,
  _Proj.ProjectDescription AS ProjectDescription,
  _Proj.PlannedStartDate AS PlannedStartDate,
  _Proj.PlannedEndDate AS PlannedEndDate,
  _Proj.ControllingArea AS ControllingArea,
  _Proj.ProfitCenter AS ProfitCenter,
  $parameters.P_PlanningCategory AS ComparisonPlanningCategory,
  sum(_ProjCostLineItems.ActualAmountInGlobalCurrency) AS ActualAmountInGlobalCurrency,
  sum(_ProjCostLineItems.CmtmtCostInGlobalCurrency) AS CmtmtCostInGlobalCurrency,
  sum(_ProjCostLineItems.PlanAmountInGlobalCurrency) AS PlanAmountInGlobalCurrency,
  sum(_ProjCostLineItems.PredictedAmtInGlobalCurrency) AS PredictedAmtInGlobalCurrency,
  sum(_ProjCostLineItems.LowerPredictionAmtInGlobCrcy) AS LowerPredictionAmtInGlobCrcy,
  sum(_ProjCostLineItems.UpperPredictionAmtInGlobCrcy) AS UpperPredictionAmtInGlobCrcy,
  sum(_ProjCostLineItems.ActlCmtmtCumltvAmtInGlobCrcy) AS ActlCmtmtCumltvAmtInGlobCrcy,
  _PredictedOnFlag.CreationDate AS PredictedCostCreationDate,
  cast(' ' as fins_sem_tag_name) AS PlanCostComponentName1,
  cast(' ' as fins_sem_tag_name) AS PlanCostComponentName2,
  cast(' ' as fins_sem_tag_name) AS PlanCostComponentName3,
  cast(0 as abap.curr( 23, 2 ) ) AS PlanCostForCostComponent1,
  cast(0 as abap.curr( 23, 2 ) ) AS PlanCostForCostComponent2,
  cast(0 as abap.curr( 23, 2 ) ) AS PlanCostForCostComponent3
FROM I_ProjectByProjMgrVH AS _Proj
LEFT OUTER JOIN I_EnterpriseProjectCosts AS _ProjCostLineItems ON _Proj.ProjectInternalID = _ProjCostLineItems.ProjectInternalID AND( _ProjCostLineItems.PlanningCategory = $parameters.P_PlanningCategory OR _ProjCostLineItems.PlanningCategory = 'ACT01' OR _ProjCostLineItems.PlanningCategory = 'PREDICT01' OR _ProjCostLineItems.PlanningCategory = 'CMTMT' OR _ProjCostLineItems.PlanningCategory = 'PREDICT02' OR _ProjCostLineItems.PlanningCategory = 'PREDICT03' ) AND _ProjCostLineItems.IsSettled = 'X'  -- association [0..*]
LEFT OUTER JOIN I_EntProjSimilarProjBscData AS _SimProjCostLineItemData ON _SimProjCostLineItemData.ProjectInternalID = _Proj.ProjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_SingleResponsibleForProj AS _Responsible ON _Proj.ProjectSummaryTaskUUID = _Responsible.ReferencedObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON BusinessPartnerUUID = _UserContactCard.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN P_ProjectLastPredictedOn AS _PredictedOnFlag ON _Proj.ProjectInternalID = _PredictedOnFlag.ProjectInternalID  -- association [0..1]
;