I_PubSecBdgtCnsmpnAnalysisCube

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_PubSecBdgtCnsmpnAnalysisCube.
-- 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: IPSBDGTCNSMPNC

CREATE VIEW I_PubSecBdgtCnsmpnAnalysisCube 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.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.GrantID AS GrantID,
  Main.SponsoredClass AS SponsoredClass,
  Main.SponsoredProgram AS SponsoredProgram,
  Main.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  Main.FunctionalArea AS FunctionalArea,
  Main.BdgtConsumableAmtInGlobalCrcy AS BdgtConsumableAmtInGlobalCrcy,
  Main.BdgtConsumedAmtInGlobalCrcy AS BdgtConsumedAmtInGlobalCrcy,
  Main.BdgtAvailableAmtInGlobalCrcy AS BdgtAvailableAmtInGlobalCrcy,
  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._FinancialManagementArea AS _FinancialManagementArea,
  Main._ControllingArea AS _ControllingArea,
  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._Ledger AS _Ledger,
  Main._CompanyCode AS _CompanyCode,
  Main._Fund AS _Fund,
  Main._Grant AS _Grant,
  Main._CostCenter AS _CostCenter,
  Main._CurrentCostCenter AS _CurrentCostCenter,
  Main._FinancialAccountType AS _FinancialAccountType,
  Main._BusinessArea AS _BusinessArea,
  Main._Segment AS _Segment,
  Main._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  Main._Supplier AS _Supplier,
  Main._Customer AS _Customer,
  Main._AccountingDocumentType AS _AccountingDocumentType,
  Main._ProfitCenter AS _ProfitCenter,
  Main._CurrentProfitCenter AS _CurrentProfitCenter,
  Main._FunctionalArea AS _FunctionalArea,
  Main._FiscalYear AS _FiscalYear,
  Main._GlobalCurrency AS _GlobalCurrency
FROM I_PubSecBdgtCnsmpnAnalysis AS Main
;