I_GLAcctWithGrpChartOfAccounts

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_GLAcctWithGrpChartOfAccounts.
-- 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: IFIGLGRPCOA

CREATE VIEW I_GLAcctWithGrpChartOfAccounts AS
SELECT
  ska1.ktopl AS ChartOfAccounts,
  ska1.saknr AS GLAccount,
  ska1.xbilk AS IsBalanceSheetAccount,
  ska1.ktoks AS GLAccountGroup,
  ska1.bilkt AS CorporateGroupAccount,
  ska1.gvtyp AS ProfitLossAccountType,
  ska1.mustr AS SampleGLAccount,
  ska1.xloev AS AccountIsMarkedForDeletion,
  ska1.xspea AS AccountIsBlockedForCreation,
  ska1.xspeb AS AccountIsBlockedForPosting,
  ska1.xspep AS AccountIsBlockedForPlanning,
  ska1.vbund AS PartnerCompany,
  ska1.func_area AS FunctionalArea,
  ska1.erdat AS CreationDate,
  ska1.ernam AS CreatedByUser,
  ska1.last_changed_ts AS LastChangeDateTime,
  ska1.glaccount_type AS GLAccountType,
  ska1.sakan AS GLAccountExternal,
  ska1.main_saknr AS BankReconciliationAccount,
  case when ska1.xbilk = 'X' then ' ' else 'X' end as IsProfitLossAccount AS xbilkXthenelseXendasIsProfitLossAccount,
  t004.kktpl AS CorporateGroupChartOfAccounts,
  _GLAcctInChartOfAcctsProdn.GLAccountIsNotProdnRelevant AS GLAccountIsNotProdnRelevant
LEFT OUTER JOIN t004 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChartOfAccounts AS _GroupChartOfAccounts ON CorporateGroupChartOfAccounts = _GroupChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _CorporateGroupAccountText ON CorporateGroupChartOfAccounts = _CorporateGroupAccountText.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _Text ON ChartOfAccounts = _Text.ChartOfAccounts AND GLAccount = _Text.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- 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_GLAccountHierarchyNode AS _GLAccountHierarchyNode ON GLAccount = _GLAccountHierarchyNode.GLAccount AND ChartOfAccounts = _GLAccountHierarchyNode.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [1..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 ChartOfAccounts = _GLAccountGroup.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAcctInChartOfAcctsProdn AS _GLAcctInChartOfAcctsProdn ON ChartOfAccounts = _GLAcctInChartOfAcctsProdn.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAcctsProdn.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAcctInCOAImplementStat AS _GLAcctInChartOfAcctsStatus ON ChartOfAccounts = _GLAcctInChartOfAcctsStatus.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAcctsStatus.GLAccount  -- association [0..1]
;