I_GLAcctHierNodeSemanticTag

DDL: I_GLACCTHIERNODESEMANTICTAG SQL: IFIGLHIERNODESEM Type: view BASIC Package: FINS_FIS_FICO_MD
5 Fields 2 Data Sources

GL Account Hierarchy Node with Semantic Tag

I_GLAcctHierNodeSemanticTag is a Basic CDS View that provides data about "GL Account Hierarchy Node with Semantic Tag" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountHierarchy, P_SemTagNode) and exposes 5 fields. Part of development package FINS_FIS_FICO_MD.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountHierarchy _Hierarchy inner
P_SemTagNode P_SemTagNode from

Annotations (8)

NameValueLevelField
EndUserText.label GL Account Hierarchy Node with Semantic Tag view
AbapCatalog.sqlViewName IFIGLHIERNODESEM view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
GLAccountHierarchy hryid Hierarchy ID
HierarchyNode hrynode Node
ValidityEndDate hryvalto Valid To
SemanticTag fins_sem_tag Semantic Tag
NodeType nodetype Object Type

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_GLAcctHierNodeSemanticTag.
-- 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: IFIGLHIERNODESEM

CREATE VIEW I_GLAcctHierNodeSemanticTag AS
SELECT
  hryid AS GLAccountHierarchy,
  hrynode AS HierarchyNode,
  hryvalto AS ValidityEndDate,
  fins_sem_tag AS SemanticTag,
  NodeType
FROM P_SemTagNode
INNER JOIN I_GLAccountHierarchy AS _Hierarchy ON /* join condition not captured in parsed metadata */
;

Learn More