P_GLAccountInCOAHierarchy

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 P_GLAccountInCOAHierarchy.
-- 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 P_GLAccountInCOAHierarchy AS
SELECT
  h.FinancialStatementHierarchy AS FinancialStatementHierarchy,
  cast(h.ChartOfAccounts as fis_ktopl) AS ChartOfAccounts,
  case n.FinancialStatementNodeType when 'G' then cast( concat( n.ParentNode, n.HierarchyNode ) as uhnid ) else n.HierarchyNode end as HierarchyNodeUniqueID AS HierarchyNodeendasHierarchyNodeUniqueID,
  h.ValidityEndDate AS ValidityEndDate,
  n.HierarchyNode AS HierarchyNode,
  n.ParentNode AS ParentNodeUniqueID,
  n.HierarchyNode AS FinancialStatementItem,
  cast(n.HierarchyLevel as abap.int8 ) AS FinStatementHierarchyLevelVal,
  case n.FinancialStatementNodeType when 'G' then c.GLAccount else '' end as GLAccount AS GLAccountelseendasGLAccount,
  n.FinancialStatementNodeType AS FinancialStatementNodeType,
  case n.HierarchyNodeVal when '0ASSETS' then case when h.FinancialStatementAssetsItem is not null then h.FinancialStatementAssetsItem else 'ASSETS' end when '0LIABILITS' then case when h.FinStatementLiabilitiesItem is not null then h.FinStatementLiabilitiesItem else 'LIABILITS' end when '0BSLOSS' then case when h.FinancialStatementNetLossItem is not null then h.FinancialStatementNetLossItem else 'BSLOSS' end when '0BSPROFIT' then case when h.FinStatementNetProfitItem is not null then h.FinStatementNetProfitItem else 'BSPROFIT' end when '0PLPROFIT' then case when h.FinStatementProfitAndLossItem is not null then h.FinStatementProfitAndLossItem else 'PLPROFIT' end when '0BSNOTES' then case when h.FinancialStatementNotesItem is not null then h.FinancialStatementNotesItem else 'BSNOTES' end when '0NOTASSGND' then case when h.FinancialStatementOrphansItem is not null then h.FinancialStatementOrphansItem else 'NOTASSGND' end else n.HierarchyNodeVal end as HierarchyNodeVal AS HierarchyNodeValendasHierarchyNodeVal,
  h.ValidityStartDate AS ValidityStartDate,
  c.CorporateGroupAccount AS CorporateGroupAccount,
  corp_gl_text.GLAccountName AS CorporateGroupAccountName,
  c.GLAccountType AS GLAccountType,
  c.GLAccountGroup AS GLAccountGroup,
  gl_text.GLAccountName AS GLAccountName,
  gl_text.GLAccountLongName AS GLAccountLongName,
  c.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  c.GLAccountExternal AS GLAccountExternal,
  c.GLAccountSubtype AS GLAccountSubtype,
  c.BankReconciliationAccount AS BankReconciliationAccount,
  c.ProfitLossAccountType AS ProfitLossAccountType,
  n.FinancialStatementNodeType AS NodeType,
  n.HierarchyLevel AS HierarchyLevel,
  n.HierarchyNodeSequence AS SiblingNode,
  n.DebitCreditCode AS DebitCreditCode,
  c._GLAcctInChartOfAcctsStatus.GLAcctCOAImplementStatus AS GLAcctCOAImplementStatus,
  h._Text AS _HierText
FROM I_FinancialStatementHier AS h
INNER JOIN I_FinancialStatementHierNode AS n ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialStatementHierNode AS _FinancialStatementItem ON FinancialStatementHierarchy = _FinancialStatementItem.FinancialStatementHierarchy AND HierarchyNode = _FinancialStatementItem.HierarchyNode AND _FinancialStatementItem.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementHier AS _FinancialStatementHier ON FinancialStatementHierarchy = _FinancialStatementHier.FinancialStatementHierarchy AND _FinancialStatementHier.ValidityEndDate = '99991231'  -- association [0..1]
;