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.
-- SQL view name: IGLACOATP

CREATE VIEW I_GLAcctInChtAcctsTP AS
SELECT
  I_GLAccountInChartOfAccounts.ChartOfAccounts AS ChartOfAccounts,
  GLAccount,
  I_GLAccountInChartOfAccounts.ChartOfAccounts AS ChartOfAccountsForEdit,
  GLAccount AS GLAccountForEdit,
  IsBalanceSheetAccount,
  GLAccountGroup,
  CorporateGroupAccount,
  ProfitLossAccountType,
  SampleGLAccount,
  AccountIsMarkedForDeletion,
  AccountIsBlockedForCreation,
  AccountIsBlockedForPosting,
  AccountIsBlockedForPlanning,
  PartnerCompany,
  FunctionalArea,
  CreationDate,
  CreatedByUser,
  GLAccountType,
  GLAccountSubtype,
  BankReconciliationAccount,
  GLAccountExternal,
  _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 CorporateGroupAccount is not null and _GroupAccount.sakan is null then cast ( 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]
;