C_PubSecBdgtAnalysis

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 C_PubSecBdgtAnalysis.
-- 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: CPSMBDGTANLYS

CREATE VIEW C_PubSecBdgtAnalysis AS
SELECT
  Bdgt.FinancialManagementArea AS FinancialManagementArea,
  Bdgt.Ledger AS Ledger,
  Bdgt.CompanyCode AS CompanyCode,
  Bdgt.PlanningCategory AS PlanningCategory,
  Bdgt.FiscalYear AS FiscalYear,
  Bdgt.Fund AS Fund,
  Bdgt.BudgetPeriod AS BudgetPeriod,
  Bdgt.FunctionalArea AS FunctionalArea,
  Bdgt.BudgetingType AS BudgetingType,
  Bdgt.BudgetDocWorkFlowStatus AS BudgetDocWorkFlowStatus,
  Bdgt.GrantID AS GrantID,
  Bdgt._Grant.GrantLifecycleStatus AS GrantLifecycleStatus,
  Bdgt.WBSElementExternalID AS WBSElementExternalID,
  Bdgt.WBSElementInternalID AS WBSElementInternalID,
  Bdgt.ChartOfAccounts AS ChartOfAccounts,
  Bdgt.ProfitCenter AS ProfitCenter,
  Bdgt.Segment AS Segment,
  Bdgt._PubSecBudgetAccount.PubSecBudgetAccount AS PubSecBudgetAccount,
  Bdgt._PubSecBudgetAccount.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  Bdgt.ReferenceDocument AS ReferenceDocument,
  Bdgt.ReferenceDocumentContext AS ReferenceDocumentContext,
  Bdgt.ReferenceDocumentType AS ReferenceDocumentType,
  Bdgt.CostCenter AS CostCenter,
  Bdgt.GLAccount AS GLAccount,
  _Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  _BudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  _FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  _Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  _BudgetProcess._Text[1:Language = $session.system_language].BudgetProcessText AS BudgetProcessText,
  _BudgetingType._Text[1:Language = $session.system_language].BudgetingTypeText AS BudgetingTypeText,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CostCenter._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  _WBSElementExternalIDText.WBSDescription AS WBSDescription,
  Bdgt._PubSecBudgetAccount._BudgetAccountText[1:Language = $session.system_language].BudgetAccountName AS GLAccountName,
  Bdgt.GlobalCurrency AS GlobalCurrency,
  Bdgt.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  Bdgt.BudgetProcess AS BudgetProcess,
  Bdgt._Fund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  Bdgt._Grant.GrantLfcycStatusForAuthzn AS GrantLfcycStatusForAuthzn,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _BudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  Bdgt._PlanningCategory AS _PlanningCategory
FROM I_PubSecBdgtLineItemCube AS Bdgt
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BudgetProcess AS _BudgetProcess ON BudgetProcess = _BudgetProcess.BudgetProcess  -- association [0..1]
LEFT OUTER JOIN I_BudgetingType AS _BudgetingType ON BudgetingType = _BudgetingType.BudgetingType  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON pubsecbudgetaccount = _PubSecBudgetAccount.PubSecBudgetAccount AND pubsecbudgetaccountcocode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode  -- association [0..1]
LEFT OUTER JOIN I_BudgetDocWorkFlowStatus AS _BudgetDocWorkFlowStatus ON BudgetDocWorkFlowStatus = _BudgetDocWorkFlowStatus.BudgetDocWorkFlowStatus  -- association [0..1]
;