I_GLAcctInChtAcctsTP

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_GLAcctInChtAcctsTP.
-- 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_GLAcctInChtAcctsTP AS
SELECT
  I_GLAccountInChartOfAccounts.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountInChartOfAccounts.GLAccount AS GLAccount,
  I_GLAccountInChartOfAccounts.ChartOfAccounts AS ChartOfAccountsForEdit,
  I_GLAccountInChartOfAccounts.GLAccount AS GLAccountForEdit,
  I_GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  I_GLAccountInChartOfAccounts.GLAccountGroup AS GLAccountGroup,
  I_GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  I_GLAccountInChartOfAccounts.ProfitLossAccountType AS ProfitLossAccountType,
  I_GLAccountInChartOfAccounts.SampleGLAccount AS SampleGLAccount,
  I_GLAccountInChartOfAccounts.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  I_GLAccountInChartOfAccounts.AccountIsBlockedForCreation AS AccountIsBlockedForCreation,
  I_GLAccountInChartOfAccounts.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  I_GLAccountInChartOfAccounts.AccountIsBlockedForPlanning AS AccountIsBlockedForPlanning,
  I_GLAccountInChartOfAccounts.PartnerCompany AS PartnerCompany,
  I_GLAccountInChartOfAccounts.FunctionalArea AS FunctionalArea,
  I_GLAccountInChartOfAccounts.CreationDate AS CreationDate,
  I_GLAccountInChartOfAccounts.CreatedByUser AS CreatedByUser,
  I_GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  I_GLAccountInChartOfAccounts.GLAccountSubtype AS GLAccountSubtype,
  I_GLAccountInChartOfAccounts.BankReconciliationAccount AS BankReconciliationAccount,
  I_GLAccountInChartOfAccounts.GLAccountExternal AS GLAccountExternal,
  I_GLAccountInChartOfAccounts._GLAcctInChartOfAcctsProdn.GLAccountIsNotProdnRelevant AS GLAccountIsNotProdnRelevant,
  chtaccts.MaintenanceLanguage AS MaintenanceLanguage,
  cast ('' as ktopl) AS DraftReferenceChartOfAccounts,
  cast ('' as saknr) AS DraftReferenceGLAccount,
  _GLAcctTxtInMaintLang.GLAccountName AS GLAccountName,
  _GLAcctTxtInMaintLang.GLAccountLongName AS GLAccountLongName,
  _ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  case when I_GLAccountInChartOfAccounts.CorporateGroupAccount is not null and _GroupAccount.sakan is null then cast ( I_GLAccountInChartOfAccounts.CorporateGroupAccount as sakan ) else _GroupAccount.sakan end as CorporateGroupAccountExternal AS sakanendasCorporateGroupAccountExternal
FROM I_GLAccountInChartOfAccounts
LEFT OUTER JOIN I_GLAcctTextTP AS _Text ON ChartOfAccounts = _Text.ChartOfAccounts AND GLAccount = _Text.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAcctInCoCodeTP AS _GLAcctInCoCodeTP ON ChartOfAccounts = _GLAcctInCoCodeTP.ChartOfAccounts AND GLAccount = _GLAcctInCoCodeTP.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_CostElementTP AS _CostElementTP ON ChartOfAccounts = _CostElementTP.ChartOfAccounts AND GLAccount = _CostElementTP.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountForPublicSectorTP AS _PublicSectorTP ON ChartOfAccounts = _PublicSectorTP.ChartOfAccounts AND GLAccount = _PublicSectorTP.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccountsForEdit = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [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 ChartOfAccountsForEdit = _BankRecnclnAcct.ChartOfAccounts AND BankReconciliationAccount = _BankRecnclnAcct.BankReconciliationAccount  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _Globalcompany ON PartnerCompany = _Globalcompany.Company  -- association [1..1]
LEFT OUTER JOIN I_GLAccountGroup AS _Glaccountgroup ON GLAccountGroup = _Glaccountgroup.GLAccountGroup AND ChartOfAccountsForEdit = _Glaccountgroup.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CorporateGroupAccount ON corporategroupchartofaccounts = _CorporateGroupAccount.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ProfitLossAccountType_Vh AS _ProfitLossAccountType_Vh ON ChartOfAccountsForEdit = _ProfitLossAccountType_Vh.ChartOfAccounts AND ProfitLossAccountType = _ProfitLossAccountType_Vh.ProfitLossAccountType  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CorpGroupChartOfAccounts ON corporategroupchartofaccounts = _CorpGroupChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAcctInDefaultLanguageText AS _GLAcctTxtInMaintLang ON ChartOfAccounts = _GLAcctTxtInMaintLang.ChartOfAccounts AND GLAccount = _GLAcctTxtInMaintLang.GLAccount AND MaintenanceLanguage = _GLAcctTxtInMaintLang.Language  -- association [0..1]
LEFT OUTER JOIN I_RetainedEarningsGLAccount AS _RetainedEarningsGLAccount ON ChartOfAccountsForEdit = _RetainedEarningsGLAccount.ChartOfAccounts AND ProfitLossAccountType = _RetainedEarningsGLAccount.ProfitLossAccountType  -- association [0..1]
;