I_GLAccountForPublicSectorTP

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_GLAccountForPublicSectorTP.
-- 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.

CREATE VIEW I_GLAccountForPublicSectorTP AS
SELECT
  _PublicSector.ChartOfAccounts AS ChartOfAccounts,
  _PublicSector.GLAccount AS GLAccount,
  _PublicSector.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  _PublicSector.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  _PublicSector.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  _PublicSector.PubSecBdgtAcctIsPostgAllowed AS PubSecBdgtAcctIsPostgAllowed,
  _PublicSector.PubSecBdgtAcctIsBdgtAllowed AS PubSecBdgtAcctIsBdgtAllowed,
  _PublicSector.PubSecBdgtAcctIsCarryFwd AS PubSecBdgtAcctIsCarryFwd,
  _PublicSector.PubSecBdgtAcctCarryFwdTo AS PubSecBdgtAcctCarryFwdTo,
  _PublicSector.CashLedgerAccount AS CashLedgerAccount,
  _PublicSector.SponsoredClass AS SponsoredClass,
  _PublicSector._ChartOfAccounts AS _ChartOfAccounts,
  _PublicSector._GLAccountHierarchyNode AS _GLAccountHierarchyNode,
  _PublicSector._PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType,
  _PublicSector._PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode,
  _PublicSector._PubSecBdgtAcctCarryFwdTo AS _PubSecBdgtAcctCarryFwdTo,
  _PublicSector._CarryForwardBudgetAccount AS _CarryForwardBudgetAccount,
  _PublicSector._CashLedgerAccount AS _CashLedgerAccount,
  _PublicSector._Text AS _Text
FROM I_GLAccountForPublicSector AS _PublicSector
LEFT OUTER JOIN I_PubSecBdgtCnsmpnTypeText AS _BudgetCnsmpnTypeText ON PubSecBudgetCnsmpnType = _BudgetCnsmpnTypeText.PubSecBudgetCnsmpnType  -- association [0..*]
LEFT OUTER JOIN I_PubSecBdgtAcctRevnExpnText AS _BdgtAcctRevnExpnText ON PubSecBdgtAcctRevnExpnCode = _BdgtAcctRevnExpnText.PubSecBdgtAcctRevnExpnCode  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _CashLedgerAccountText ON ChartOfAccounts = _CashLedgerAccountText.ChartOfAccounts AND CashLedgerAccount = _CashLedgerAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _BdgtAcctCarryFwdToText ON ChartOfAccounts = _BdgtAcctCarryFwdToText.ChartOfAccounts AND PubSecBdgtAcctCarryFwdTo = _BdgtAcctCarryFwdToText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAcctInChtAcctsTP AS _GLAcctInChtAcctsTP ON ChartOfAccounts = _GLAcctInChtAcctsTP.ChartOfAccounts AND GLAccount = _GLAcctInChtAcctsTP.GLAccount  -- association [1..1]
;