I_PubSecBdgtConsumedAnalysis

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_PubSecBdgtConsumedAnalysis.
-- 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: IPSBDGTCNSMD

CREATE VIEW I_PubSecBdgtConsumedAnalysis AS
SELECT
  Main.Ledger AS 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.FinancialAccountType AS FinancialAccountType,
  Main.BusinessArea AS BusinessArea,
  Main.Segment AS Segment,
  Main.GLAccount AS GLAccount,
  Main.Supplier AS Supplier,
  Main.Customer AS Customer,
  Main.AccountingDocumentType AS AccountingDocumentType,
  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._CompanyCode AS _CompanyCode,
  Main._ControllingArea AS _ControllingArea,
  Main._FinancialManagementArea AS _FinancialManagementArea,
  Main._GlobalCurrency AS _GlobalCurrency,
  Main._PubSecBudgetAccount AS _PubSecBudgetAccount,
  Main._Fund AS _Fund,
  Main._CostCenter AS _CostCenter,
  Main._CurrentCostCenter AS _CurrentCostCenter,
  Main._FiscalYear AS _FiscalYear,
  Main._Grant AS _Grant
FROM I_PubSecCtrlObjCmtmtActlCube AS Main
;