P_ProjectFinBdgtSummary

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_ProjectFinBdgtSummary.
-- 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: PPROJFBDGTSMRY

CREATE VIEW P_ProjectFinBdgtSummary AS
SELECT
  _Project.Project AS Project,
  SourceLedger,
  Ledger,
  _Project.CompanyCode AS CompanyCode,
  _ProjectCostLineItems.FiscalYear AS FiscalYear,
  AccountingDocument,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  ActualPlanJournalEntryItem,
  _Project.ProjectUUID AS ProjectUUID,
  _Project.ProjectDescription AS ProjectDescription,
  _Project.ProjectInternalID AS ProjectInternalID,
  _Project.ProjectObject AS ProjectObject,
  _Project.ProjectProfileCode AS ProjectProfileCode,
  _Project.PlannedStartDate AS PlannedStartDate,
  _Project.PlannedEndDate AS PlannedEndDate,
  _Project.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  _Project.ProjectCategory AS ProjectCategory,
  _Project.ProfitCenter AS ProfitCenter,
  _ProjectSummary.EnterpriseProjectType AS ProjectType,
  _Project.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  _Project.AvailabilityControlProfile AS AvailabilityControlProfile,
  _Project.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  _Project.BudgetCurrencyRole AS BudgetCurrencyRole,
  $session.system_date AS CurrentDate,
  _Project.ControllingArea AS ControllingArea,
  PS_RootWBS.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,
  _Project.ProjectProcessingStatus AS ProjectProcessingStatus,
  IsSettled,
  _ProjectCostLineItems.GlobalCurrency AS GlobalCurrency,
  _ProjectCostLineItems.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ProjectCostLineItems.ControllingObjectCurrency AS ControllingObjectCurrency,
  _ProjectCostLineItems.AmountInObjectCurrency AS AmountInObjectCurrency
FROM I_ProjectByProjMgr AS _Project
INNER JOIN I_WBSElementBasicData AS PS_RootWBS ON /* join condition not captured in parsed metadata */
INNER JOIN I_EnterpriseProject AS _ProjectSummary ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ProjFinSmmryLnItems AS _ProjectCostLineItems ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ProjectLastPredictedOn AS _ProjPredict ON ProjectInternalID = _ProjPredict.ProjectInternalID  -- association [0..1]
;