I_ActiveGLAcctInCOAListItem

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_ActiveGLAcctInCOAListItem.
-- 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: IFIGLCOALIST

CREATE VIEW I_ActiveGLAcctInCOAListItem AS
SELECT
  ActiveDocument.ChartOfAccounts AS ChartOfAccounts,
  ActiveDocument.GLAccount AS GLAccount,
  ActiveDocument.GLAccountExternal AS GLAccountExternal,
  ActiveDocument.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  ActiveDocument.GLAccountGroup AS GLAccountGroup,
  ActiveDocument.CorporateGroupAccount AS CorporateGroupAccount,
  ActiveDocument.ProfitLossAccountType AS ProfitLossAccountType,
  ActiveDocument.SampleGLAccount AS SampleGLAccount,
  ActiveDocument.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  ActiveDocument.AccountIsBlockedForCreation AS AccountIsBlockedForCreation,
  ActiveDocument.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  ActiveDocument.AccountIsBlockedForPlanning AS AccountIsBlockedForPlanning,
  ActiveDocument.PartnerCompany AS PartnerCompany,
  ActiveDocument.FunctionalArea AS FunctionalArea,
  ActiveDocument.CreationDate AS CreationDate,
  ActiveDocument.CreatedByUser AS CreatedByUser,
  ActiveDocument.GLAccountType AS GLAccountType,
  ActiveDocument.GLAccountSubtype AS GLAccountSubtype,
  ActiveDocument.BankReconciliationAccount AS BankReconciliationAccount,
  ActiveDocument.IsProfitLossAccount AS IsProfitLossAccount,
  ActiveDocument._PublicSector.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  ActiveDocument._PublicSector.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  ActiveDocument._PublicSector.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  ActiveDocument._PublicSector.PubSecBdgtAcctIsPostgAllowed AS PubSecBdgtAcctIsPostgAllowed,
  ActiveDocument._PublicSector.PubSecBdgtAcctIsBdgtAllowed AS PubSecBdgtAcctIsBdgtAllowed,
  ActiveDocument._PublicSector.PubSecBdgtAcctIsCarryFwd AS PubSecBdgtAcctIsCarryFwd,
  ActiveDocument._PublicSector.PubSecBdgtAcctCarryFwdTo AS PubSecBdgtAcctCarryFwdTo,
  ActiveDocument._PublicSector.CashLedgerAccount AS CashLedgerAccount,
  ActiveDocument._PublicSector.SponsoredClass AS SponsoredClass,
  ActiveDocument._PublicSector._PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType,
  ActiveDocument._PublicSector._PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode,
  _ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  DraftAdmin.DraftIsProcessedByMe AS DraftIsProcessedByMe,
  DraftAdmin.InProcessByUser AS InProcessByUser,
  DraftAdmin.InProcessByUserDescription AS InProcessByUserDescription,
  ActiveDocument.LastChangeDateTime AS LastChangeDateTime
FROM I_GLAccountInChartOfAccounts AS ActiveDocument
LEFT OUTER JOIN I_DraftAdministrativeData AS DraftAdmin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAcctInDefaultLanguageText AS _Text ON ChartOfAccounts = _Text.ChartOfAccounts AND GLAccount = _Text.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAcctInDefaultLanguageText AS _BankRecnclnText ON ChartOfAccounts = _BankRecnclnText.ChartOfAccounts AND BankReconciliationAccount = _BankRecnclnText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_GLAccountType AS _Glaccounttype ON GLAccountType = _Glaccounttype.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountSubtype AS _GLAccountSubtype ON GLAccountSubtype = _GLAccountSubtype.GLAccountSubtype  -- association [0..1]
LEFT OUTER JOIN I_BankRecnclnAccount AS _BankRecnclnAcct ON ChartOfAccounts = _BankRecnclnAcct.ChartOfAccounts AND BankReconciliationAccount = _BankRecnclnAcct.BankReconciliationAccount  -- association [0..1]
LEFT OUTER JOIN I_RetainedEarningsGLAccount AS _RetainedEarningsGLAccount ON ChartOfAccounts = _RetainedEarningsGLAccount.ChartOfAccounts AND ProfitLossAccountType = _RetainedEarningsGLAccount.ProfitLossAccountType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountGroup AS _Glaccountgroup ON GLAccountGroup = _Glaccountgroup.GLAccountGroup AND ChartOfAccounts = _Glaccountgroup.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_GLAcctTxtInMaintLang AS _GLAcctTxtInMaintLang ON ChartOfAccounts = _GLAcctTxtInMaintLang.ChartOfAccounts AND GLAccount = _GLAcctTxtInMaintLang.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAcctTxtInMaintLang AS _BankRecnclnMaintLang ON ChartOfAccounts = _BankRecnclnMaintLang.ChartOfAccounts AND BankReconciliationAccount = _BankRecnclnMaintLang.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ProfitLossAccountType_Vh AS _ProfitLossAccountType_Vh ON ChartOfAccounts = _ProfitLossAccountType_Vh.ChartOfAccounts AND ProfitLossAccountType = _ProfitLossAccountType_Vh.ProfitLossAccountType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CorporateGroupAccount ON ChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _PubSecBdgtAcctCarryFwdTo ON ChartOfAccounts = _PubSecBdgtAcctCarryFwdTo.ChartOfAccounts AND pubsecbdgtacctcarryfwdto = _PubSecBdgtAcctCarryFwdTo.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CashLedgerAccount ON ChartOfAccounts = _CashLedgerAccount.ChartOfAccounts AND cashledgeraccount = _CashLedgerAccount.GLAccount  -- association [0..1]
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_GLAcctInDefaultLanguageText AS _CashLedgerAccountText ON ChartOfAccounts = _CashLedgerAccountText.ChartOfAccounts AND cashledgeraccount = _CashLedgerAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAcctInDefaultLanguageText AS _BdgtAcctCarryFwdToText ON ChartOfAccounts = _BdgtAcctCarryFwdToText.ChartOfAccounts AND pubsecbdgtacctcarryfwdto = _BdgtAcctCarryFwdToText.GLAccount  -- association [0..*]
;