R_FinStmntHierInOperatingCOATP

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 R_FinStmntHierInOperatingCOATP.
-- 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: RFSVOPCOATP

CREATE VIEW R_FinStmntHierInOperatingCOATP AS
SELECT
  fss.FinancialStatementHierarchy AS FinancialStatementHierarchy,
  fss.ChartOfAccounts AS ChartOfAccounts,
  fss.ParentNodeUniqueID AS ParentNodeUniqueID,
  fss.SiblingNode AS SiblingNode,
  HierarchyNodeUniqueID,
  HierarchyNode,
  fss.ValidityEndDate AS ValidityEndDate,
  fss.GLAccount AS GLAccount,
  fss.GLAccountType AS GLAccountType,
  _GLAccountInChartOfAccounts._GLAccountType._GLAccountTypeText[1: Language = $session.system_language].GLAccountTypeName AS GLAccountTypeName,
  fss.GLAccountGroup AS GLAccountGroup,
  _GLAccountInChartOfAccounts._GLAccountGroup._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName AS AccountGroupName,
  fss.CorporateGroupAccount AS CorporateGroupAccount,
  fss.CorporateGroupAccountName AS CorporateGroupAccountName,
  fss.GLAccountName AS GLAccountName,
  fss.GLAccountLongName AS GLAccountLongName,
  fss.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  fss.GLAccountExternal AS GLAccountExternal,
  fss.GLAccountSubtype AS GLAccountSubtype,
  fss.BankReconciliationAccount AS BankReconciliationAccount,
  fss.ProfitLossAccountType AS ProfitLossAccountType,
  GLAcctCOAImplementStatus,
  _ImpStatusText[1: Language = $session.system_language].GLAcctCOAImplementStatusName AS GLAcctCOAImplementStatusName,
  fss.FunctionalArea AS FunctionalArea,
  cast(fss.HierarchyLevel as abap.int8 ) - 1 AS FinStatementHierarchyLevelVal,
  fss.NodeType AS NodeType
FROM P_GLAccountInCOAHierarchy AS fss
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_GLACCTINCOAIMPSTATTYPETEXT AS _ImpStatusText ON GLAcctCOAImplementStatus = _ImpStatusText.GLAcctCOAImplementStatus  -- association [0..1]
;