P_PROJECTFINBUDGETSMMRY

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 P_PROJECTFINBUDGETSMMRY.
-- 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: PPROJFBUDGETSMRY

CREATE VIEW P_PROJECTFINBUDGETSMMRY AS
SELECT
  _ProjectCostLineItems.ProjectUUID AS ProjectUUID,
  _ProjectCostLineItems.ProjectInternalID AS ProjectInternalID,
  _ProjectCostLineItems.SourceLedger AS SourceLedger,
  _ProjectCostLineItems.Ledger AS Ledger,
  _ProjectCostLineItems.CompanyCode AS CompanyCode,
  _ProjectCostLineItems.FiscalYear AS FiscalYear,
  _ProjectCostLineItems.AccountingDocument AS AccountingDocument,
  _ProjectCostLineItems.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _ProjectCostLineItems.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  _ProjectCostLineItems.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  _ProjectCostLineItems.Project AS Project,
  _ProjectCostLineItems.ProjectDescription AS ProjectDescription,
  _ProjectCostLineItems.ProcessingStatus AS ProcessingStatus,
  _ProjectCostLineItems.ProjectProfileCode AS ProjectProfileCode,
  _ProjectCostLineItems.PlannedStartDate AS PlannedStartDate,
  _ProjectCostLineItems.PlannedEndDate AS PlannedEndDate,
  _ProjectCostLineItems.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  _ProjectCostLineItems.ProjectCategory AS ProjectCategory,
  _ProjectCostLineItems.ProfitCenter AS ProfitCenter,
  _ProjectCostLineItems.ProjectType AS ProjectType,
  _ProjectCostLineItems.ProjectObject AS ProjectObject,
  _ProjectCostLineItems.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  _ProjectCostLineItems.AvailabilityControlProfile AS AvailabilityControlProfile,
  _ProjectCostLineItems.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  _ProjectCostLineItems.BudgetCurrencyRole AS BudgetCurrencyRole,
  $session.system_date AS CurrentDate,
  _ProjectCostLineItems.ControllingArea AS ControllingArea,
  _ProjectCostLineItems.FunctionalArea AS FunctionalArea,
  _ProjectCostLineItems.ResponsibleCostCenter AS ResponsibleCostCenter,
  _ProjectCostLineItems.PlanningCategory AS PlanningCategory,
  _ProjectCostLineItems.SemanticTag AS SemanticTag,
  _ProjectCostLineItems.PostingDate AS PostingDate,
  _ProjectCostLineItems.CreationDate AS CreationDate,
  _ProjPredict.CreationDate AS PredictedCostCreationDate,
  '00000000' AS PredictedCostPostingDate,
  _ProjectSummary.ProjectProcessingStatus AS ProjectProcessingStatus,
  _ProjectCostLineItems.IsSettled AS IsSettled,
  _ProjectCostLineItems.GlobalCurrency AS GlobalCurrency,
  _ProjectCostLineItems.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  ActualAmountInGlobalCurrency,
  CmtmtCostInGlobalCurrency,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  _ProjectCostLineItems.ActlCostInProjCrcy AS ActlCostInProjCrcy,
  CmtmtCostInProjCrcy,
  0 AS ActlCmtmtCumltvAmtInGlobCrcy,
  0 AS PredictedAmtInGlobalCurrency,
  0 AS LowerPredictionAmtInGlobCrcy,
  0 AS UpperPredictionAmtInGlobCrcy,
  0 AS AssgdValForBudgetInProjCrcy
FROM P_EnterpriseProjectCosts AS _ProjectCostLineItems
INNER JOIN I_ProjectBasicData AS _projBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ProjectLastPredictedOn AS _ProjPredict ON ProjectInternalID = _ProjPredict.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_PPM_ProjectSummaryTask AS _ProjectSummary ON _ProjectSummary.ProjectInternalID = ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON _proj.ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
-- UNION ALL with additional select branch(es): I_EnterpriseProject
;