I_PubSecBdgtConsumableAnalysis

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_PubSecBdgtConsumableAnalysis.
-- 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: IPSBDGTCNSMBL

CREATE VIEW I_PubSecBdgtConsumableAnalysis AS
SELECT
  Ledger,
  Main.CompanyCode AS CompanyCode,
  Main.FinancialManagementArea AS FinancialManagementArea,
  Main.ControllingArea AS ControllingArea,
  Main.FiscalYear AS FiscalYear,
  Main.CtrlObjForFund AS CtrlObjForFund,
  Main.CtrlObjForFunctionalArea AS CtrlObjForFunctionalArea,
  Main.CtrlObjForBudgetPeriod AS CtrlObjForBudgetPeriod,
  Main.CtrlObjForCostCenter AS CtrlObjForCostCenter,
  Main.CtrlObjForWBSElement AS CtrlObjForWBSElement,
  Main.CtrlObjForBudgetAccount AS CtrlObjForBudgetAccount,
  Main.CtrlObjForGrant AS CtrlObjForGrant,
  Main.CtrlObjForSponsoredClass AS CtrlObjForSponsoredClass,
  Main.CtrlObjForSponsoredProgram AS CtrlObjForSponsoredProgram,
  Main.CtrlObjForBdgtValidityNmbr AS CtrlObjForBdgtValidityNmbr,
  Main.GlobalCurrency AS GlobalCurrency,
  Main.PubSecBudgetAccount AS PubSecBudgetAccount,
  Main.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  Main.AvailabilityControlProfile AS AvailabilityControlProfile,
  Main.Fund AS Fund,
  Main.CostCenter AS CostCenter,
  Main.BusinessArea AS BusinessArea,
  Main.Segment AS Segment,
  Main.GLAccount AS GLAccount,
  Main.Customer AS Customer,
  Main.ProfitCenter AS ProfitCenter,
  Main.FunctionalArea AS FunctionalArea,
  Main.GrantID AS GrantID,
  Main.SponsoredClass AS SponsoredClass,
  Main.SponsoredProgram AS SponsoredProgram,
  Main.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  Main.HierarchyIDForFund AS HierarchyIDForFund,
  Main.HierarchyIDForFunctionalArea AS HierarchyIDForFunctionalArea,
  Main.HierarchyIDForBudgetPeriod AS HierarchyIDForBudgetPeriod,
  Main.HierarchyIDForCostCenter AS HierarchyIDForCostCenter,
  Main.HierarchyIDForWBSElement AS HierarchyIDForWBSElement,
  Main.HierarchyIDForBudgetAccount AS HierarchyIDForBudgetAccount,
  Main.GrantHierarchy AS GrantHierarchy,
  Main.SponsoredClassHierarchy AS SponsoredClassHierarchy,
  Main.SponsoredProgramHierarchy AS SponsoredProgramHierarchy,
  Main._CtrlObjFund AS _CtrlObjFund,
  Main._CtrlObjFuncArea AS _CtrlObjFuncArea,
  Main._CtrlObjBdgtPeriod AS _CtrlObjBdgtPeriod,
  Main._CtrlObjCostCenter AS _CtrlObjCostCenter,
  Main._CtrlObjWBSElement AS _CtrlObjWBSElement,
  Main._CtrlObjBdgtAccount AS _CtrlObjBdgtAccount,
  Main._CtrlObjGrant AS _CtrlObjGrant,
  Main._CtrlObjSpnsrdClass AS _CtrlObjSpnsrdClass,
  Main._CtrlObjSpnsrdProg AS _CtrlObjSpnsrdProg,
  Main._PubSecFundHier AS _PubSecFundHier,
  Main._PubSecFunctionalAreaHier AS _PubSecFunctionalAreaHier,
  Main._PubSecBudgetPeriodHier AS _PubSecBudgetPeriodHier,
  Main._PubSecCostCenterHier AS _PubSecCostCenterHier,
  Main._PubSecWBSElementHier AS _PubSecWBSElementHier,
  Main._PubSecBudgetAccountHier AS _PubSecBudgetAccountHier,
  Main._PubSecGrantHier AS _PubSecGrantHier,
  Main._PubSecSpnsrdClassHier AS _PubSecSpnsrdClassHier,
  Main._PubSecSpnsrdProgHier AS _PubSecSpnsrdProgHier,
  Main._PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode,
  Main._PubSecAvailyCtrlProfile AS _PubSecAvailyCtrlProfile,
  Main._GlobalCurrency AS _GlobalCurrency,
  Main._PubSecBudgetAccount AS _PubSecBudgetAccount,
  Main._CompanyCode AS _CompanyCode,
  Main._ControllingArea AS _ControllingArea,
  Main._FinancialManagementArea AS _FinancialManagementArea,
  Main._FiscalYear AS _FiscalYear
FROM I_PubSecCtrlObjBudgetCube AS Main
;