C_ChartOfAccountsListItem

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_ChartOfAccountsListItem.
-- 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: CGLCOALIST
-- Parameters: P_Language : spras, P_GLAcctOriginalRecordIsUsed : fac_is_show_old_value

CREATE VIEW C_ChartOfAccountsListItem AS
SELECT
  PublicUnion.ChartOfAccounts AS ChartOfAccounts,
  PublicUnion.GLAccount AS GLAccount,
  cast ( '' as fac_is_show_old_value ) AS GLAcctOriginalRecordIsUsed,
  coalesce( _Text[1:Language = $parameters.P_Language].GLAccountName, _GLAcctTxtInMaintLang.GLAccountName ) as GLAccountName AS GLAccountNameasGLAccountName,
  coalesce( _Text[1:Language = $parameters.P_Language].GLAccountLongName, _GLAcctTxtInMaintLang.GLAccountLongName ) as GLAccountLongName AS GLAccountLongNameasGLAccountLongName,
  PublicUnion.GLAccountExternal AS GLAccountExternal,
  PublicUnion.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  PublicUnion.CorporateGroupAccount AS CorporateGroupAccount,
  PublicUnion.ProfitLossAccountType AS ProfitLossAccountType,
  _RetainedEarningsGLAccount._GLAccountInChartOfAccounts._Text[1:Language = $session.system_language].GLAccountName AS RetainedEarningsGLAccountName,
  PublicUnion.SampleGLAccount AS SampleGLAccount,
  PublicUnion.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  PublicUnion.AccountIsBlockedForCreation AS AccountIsBlockedForCreation,
  PublicUnion.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  PublicUnion.AccountIsBlockedForPlanning AS AccountIsBlockedForPlanning,
  PublicUnion.GLAccountIsNotProdnRelevant AS GLAccountIsNotProdnRelevant,
  PublicUnion.GLAcctCOAImplementStatus AS GLAcctCOAImplementStatus,
  PublicUnion.GLAccountCOAIsDeliveredBySAP AS GLAccountCOAIsDeliveredBySAP,
  PublicUnion.PartnerCompany AS PartnerCompany,
  PublicUnion.FunctionalArea AS FunctionalArea,
  _FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  PublicUnion.CreationDate AS CreationDate,
  PublicUnion.CreatedByUser AS CreatedByUser,
  PublicUnion.GLAccountType AS GLAccountType,
  _Glaccounttype._GLAccountTypeText[1: Language = $session.system_language].GLAccountTypeName AS GLAccountTypeName,
  PublicUnion.GLAccountSubtype AS GLAccountSubtype,
  _GLAccountSubtype._GLAccountSubtypeText[1: Language = $session.system_language].GLAccountSubtypeName AS GLAccountSubtypeName,
  PublicUnion.BankReconciliationAccount AS BankReconciliationAccount,
  PublicUnion.GLAccountGroup AS GLAccountGroup,
  _Glaccountgroup._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName AS AccountGroupName,
  PublicUnion.IsProfitLossAccount AS IsProfitLossAccount,
  PublicUnion.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  _User.UserDescription AS CreatedByUserName,
  PublicUnion.InProcessByUser AS InProcessByUser,
  PublicUnion.InProcessByUserDescription AS InProcessByUserDescription,
  PublicUnion.DraftIsProcessedByMe AS DraftIsProcessedByMe,
  PublicUnion.HasDraftEntity AS HasDraftEntity,
  $parameters.P_Language AS Language,
  cast ( '' as char32 ) AS ActiveDocumentETag,
  PublicUnion.LastChangeDateTime AS LastChangeDateTime,
  PublicUnion.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  PublicUnion.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  PublicUnion.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  PublicUnion.PubSecBdgtAcctIsPostgAllowed AS PubSecBdgtAcctIsPostgAllowed,
  PublicUnion.PubSecBdgtAcctIsBdgtAllowed AS PubSecBdgtAcctIsBdgtAllowed,
  PublicUnion.PubSecBdgtAcctIsCarryFwd AS PubSecBdgtAcctIsCarryFwd,
  PublicUnion.PubSecBdgtAcctCarryFwdTo AS PubSecBdgtAcctCarryFwdTo,
  PublicUnion.CashLedgerAccount AS CashLedgerAccount,
  PublicUnion.SponsoredClass AS SponsoredClass,
  PublicUnion._ChartOfAccounts AS _ChartOfAccounts,
  PublicUnion._Text AS _Text,
  PublicUnion._Glaccountgroup AS _Glaccountgroup,
  PublicUnion._FunctionalArea AS _FunctionalArea,
  PublicUnion._User AS _User,
  PublicUnion._Glaccounttype AS _Glaccounttype,
  PublicUnion._GLAccountSubtype AS _GLAccountSubtype,
  PublicUnion._BankRecnclnAcct AS _BankRecnclnAcct,
  PublicUnion._GLAcctTxtInMaintLang AS _GLAcctTxtInMaintLang,
  PublicUnion._ProfitLossAccountType_Vh AS _ProfitLossAccountType_Vh,
  PublicUnion._CorporateGroupAccount AS _CorporateGroupAccount
FROM I_ActiveGLAcctInCOAListItem AS PublicUnion
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _CorporateGroupAccountText ON CorporateGroupChartOfAccounts = _CorporateGroupAccountText.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GroupGLAccountExternal ON CorporateGroupChartOfAccounts = _GroupGLAccountExternal.ChartOfAccounts AND CorporateGroupAccount = _GroupGLAccountExternal.GLAccount  -- association [0..1]
;