P_ProjOvrlBudgetConsAgg

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_ProjOvrlBudgetConsAgg.
-- 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: PPROJBDGTCONSA

CREATE VIEW P_ProjOvrlBudgetConsAgg AS
SELECT
  ProjCostLineItems.Project AS Project,
  ProjCostLineItems.CompanyCode AS CompanyCode,
  ProjCostLineItems.ProfitCenter AS ProfitCenter,
  ProjCostLineItems.ProjectUUID AS ProjectUUID,
  ProjCostLineItems.ProjectInternalID AS ProjectInternalID,
  ProjCostLineItems.ProjectDescription AS ProjectDescription,
  ProjCostLineItems.ControllingArea AS ControllingArea,
  ProjCostLineItems.BusinessPartnerFullName AS BusinessPartnerFullName,
  ProjCostLineItems.BusinessPartnerUUID AS BusinessPartnerUUID,
  ProjCostLineItems.BusinessPartner AS BusinessPartner,
  ProjCostLineItems.ProjectType AS ProjectType,
  ProjCostLineItems.GlobalCurrency AS GlobalCurrency,
  ProjCostLineItems.ControllingObjectCurrency AS ControllingObjectCurrency,
  ProjCostLineItems.BudgetCurrencyRole AS BudgetCurrencyRole,
  ProjCostLineItems.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  ProjCostLineItems.AvailabilityControlProfile AS AvailabilityControlProfile,
  '0' AS CriticalityCode,
  cast('%' as msehi) AS UnitOfMeasure,
  cast( '' as fins_sem_tag_name) AS PlanCostComponentName1,
  cast( '' as dpr_project_name) AS PlanCostComponentName2,
  sum(ProjCostLineItems.AmountInObjectCurrency) AS AmountInObjectCurrency,
  sum(ProjCostLineItems.AmountInGlobalCurrency) AS AmountInGlobalCurrency,
  cast(1 as abap.dec(28)) AS BudgetConsumption,
  sum(ProjCostLineItems.PlanAmountInGlobalCurrency) AS BudgetInGlobalCrcy,
  sum(ProjCostLineItems.ActlCmtmtCumltvAmtInGlobCrcy) AS ActlCmtmtCumltvAmtInGlobCrcy,
  sum(ProjCostLineItems.PlndCostAmtInProjCrcy) AS BudgetInProjCrcy,
  sum(ProjCostLineItems.AssgdValForBudgetInProjCrcy) AS AssgdValForBudgetInProjCrcy
FROM I_ProjectCostLineItemsOvw AS ProjCostLineItems
;