C_Fsvhierincoa

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 C_Fsvhierincoa.
-- 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: CFSVHIERCOA
-- Parameters: P_Language : sylangu, P_MaintenanceLanguage : spras, P_FinancialStatementVariant : versn_011, P_ChartOfAccounts : ktopl, P_GLAcctHierarchyNodeCategory : glacchiercateg

CREATE VIEW C_Fsvhierincoa AS
SELECT
  HierarchyNodeUniqueID,
  ParentNodeUniqueID,
  FinStatementHierarchyLevelVal,
  FinancialStatementVariant,
  FinancialStatementItem,
  ChartOfAccounts,
  _GLAccountInChartOfAccounts.GLAccount AS GLAccount,
  _FunctionalArea.FunctionalArea AS FunctionalArea,
  _GLAccountInChartOfAccounts._Text[1: Language = $parameters.P_MaintenanceLanguage].GLAccountLongName AS GLAccountLongName,
  _FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  _FinancialStatementItem._Text[1: Language = $parameters.P_MaintenanceLanguage].FinStatementItemDescription AS FinStatementItemDescription,
  _GLAccountInChartOfAccounts.GLAccountExternal AS GLAccountExternal,
  _GroupAccountExternal.GLAccountExternal AS CorporateGroupAccountExternal,
  NodeType,
  DrillDownIsImpossible,
  IsDebitBalanceRelevant,
  IsCreditBalanceRelevant,
  OffsettingItem,
  GLAcctHierarchyNodeCategory,
  HierarchyNode,
  SiblingNode,
  _GLAccountInChartOfAccounts.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  _GLAccountInChartOfAccounts.AccountIsBlockedForCreation AS AccountIsBlockedForCreation,
  _GLAccountInChartOfAccounts.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  _GLAccountInChartOfAccounts.AccountIsBlockedForPlanning AS AccountIsBlockedForPlanning,
  _GLAccountInChartOfAccounts.PartnerCompany AS PartnerCompany,
  _GLAccountInChartOfAccounts.GLAccountGroup AS GLAccountGroup,
  _GLAccountInChartOfAccounts._GLAccountGroup._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName AS AccountGroupName,
  _GLAccountInChartOfAccounts.ProfitLossAccountType AS ProfitLossAccountType,
  CorporateGroupAccount,
  _GLAccountInGrpChartOfAccounts._CorporateGroupAccountText[1: Language = $session.system_language].GLAccountLongName AS CorporateGroupAccountLongName,
  _GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  _GLAccountInChartOfAccounts.CreatedByUser AS CreatedByUser,
  _GLAccountInChartOfAccounts._User.UserDescription AS CreatedByUserName,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  cast(_GLAccountInChartOfAccounts._GLAccountType._GLAccountTypeText[1: Language = $session.system_language].GLAccountTypeName as fac_gl_acct_type_name) AS GLAccountTypeName,
  cast( _GLAccountInChartOfAccounts.CreationDate as abap.char(8) ) AS CreationDate,
  _GLAccountInChartOfAccounts._RetainedEarningsGLAccount.RetainedEarningsGLAccount AS RetainedEarningsGLAccount,
  CorporateGroupChartOfAccounts,
  SemanticTag
FROM I_FsvHierarchyInCoa AS _GLAccount
;