FIISAL_GR_GLAcctGlobHier2

DDL: FIISAL_GR_GLACCTGLOBHIER2 Type: view_entity
40 Fields 2 Data Sources

Greece GLAccount hierarchy

FIISAL_GR_GLAcctGlobHier2 is a CDS View that provides data about "Greece GLAccount hierarchy" in SAP S/4HANA. It reads from 2 data sources (uhdt_node, uhdt_vrsn) and exposes 40 fields with key field UniversalHierNodeID.

Data Sources (2)

SourceAliasJoin Type
uhdt_node UniversalHierNode from
uhdt_vrsn version inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Greece GLAccount hierarchy view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY UniversalHierNodeID uhdt_node node_id Workflow Step
UniversalHierarchyVersionID uhdt_node ver_id Version ID
UniversalHierNodeLevel uhdt_node node_level Node Level
UniversalHierNodeType uhdt_node node_type Type
UniversalHierNodeValidFrom uhdt_node node_vldfm Node Valid From
UniversalHierNodeValidTo uhdt_node node_vldto Node Valid To
UniversalHierNodeLowValue uhdt_node node_lval Node Low Value
UniversalHierNodeParentID uhdt_node node_pid Node Parent ID
UniversalHierHierarchyType uhdt_vrsn hier_catg Type
UniversalHierHierarchyID uhdt_vrsn hier_hid Hierarchy ID
NodeIDStage1 level1 node_id Workflow Step
NodeLevelStage1 level1 node_level Node Level
NodeTypeStage1 level1 node_type Type
NodeLowValueStage1 level1 node_lval Node Low Value
HierNodeParentID1 level1 node_pid Node Parent ID
NodeIDStage2 level2 node_id Workflow Step
NodeLevelStage2 level2 node_level Node Level
NodeTypeStage2 level2 node_type Type
NodeLowValueStage2 level2 node_lval Node Low Value
HierNodeParentID2 level2 node_pid Node Parent ID
NodeIDStage3 level3 node_id Workflow Step
NodeLevelStage3 level3 node_level Node Level
NodeTypeStage3 level3 node_type Type
NodeLowValueStage3 level3 node_lval Node Low Value
HierNodeParentID3 level3 node_pid Node Parent ID
NodeIDStage4 level4 node_id Workflow Step
NodeLevelStage4 level4 node_level Node Level
NodeTypeStage4 level4 node_type Type
NodeLowValueStage4 level4 node_lval Node Low Value
HierNodeParentID4 level4 node_pid Node Parent ID
NodeIDStage5 level5 node_id Workflow Step
NodeLevelStage5 level5 node_level Node Level
NodeTypeStage5 level5 node_type Type
NodeLowValueStage5 level5 node_lval Node Low Value
HierNodeParentID5 level5 node_pid Node Parent ID
NodeIDStage6 level6 node_id Workflow Step
NodeLevelStage6 level6 node_level Node Level
NodeTypeStage6 level6 node_type Type
NodeLowValueStage6 level6 node_lval Node Low Value
HierNodeParentID6 level6 node_pid Node Parent ID

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 FIISAL_GR_GLAcctGlobHier2.
-- 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 FIISAL_GR_GLAcctGlobHier2 AS
SELECT
  UniversalHierNode.node_id AS UniversalHierNodeID,
  UniversalHierNode.ver_id AS UniversalHierarchyVersionID,
  UniversalHierNode.node_level AS UniversalHierNodeLevel,
  UniversalHierNode.node_type AS UniversalHierNodeType,
  UniversalHierNode.node_vldfm AS UniversalHierNodeValidFrom,
  UniversalHierNode.node_vldto AS UniversalHierNodeValidTo,
  UniversalHierNode.node_lval AS UniversalHierNodeLowValue,
  UniversalHierNode.node_pid AS UniversalHierNodeParentID,
  version.hier_catg AS UniversalHierHierarchyType,
  version.hier_hid AS UniversalHierHierarchyID,
  level1.node_id AS NodeIDStage1,
  level1.node_level AS NodeLevelStage1,
  level1.node_type AS NodeTypeStage1,
  level1.node_lval AS NodeLowValueStage1,
  level1.node_pid AS HierNodeParentID1,
  level2.node_id AS NodeIDStage2,
  level2.node_level AS NodeLevelStage2,
  level2.node_type AS NodeTypeStage2,
  level2.node_lval AS NodeLowValueStage2,
  level2.node_pid AS HierNodeParentID2,
  level3.node_id AS NodeIDStage3,
  level3.node_level AS NodeLevelStage3,
  level3.node_type AS NodeTypeStage3,
  level3.node_lval AS NodeLowValueStage3,
  level3.node_pid AS HierNodeParentID3,
  level4.node_id AS NodeIDStage4,
  level4.node_level AS NodeLevelStage4,
  level4.node_type AS NodeTypeStage4,
  level4.node_lval AS NodeLowValueStage4,
  level4.node_pid AS HierNodeParentID4,
  level5.node_id AS NodeIDStage5,
  level5.node_level AS NodeLevelStage5,
  level5.node_type AS NodeTypeStage5,
  level5.node_lval AS NodeLowValueStage5,
  level5.node_pid AS HierNodeParentID5,
  level6.node_id AS NodeIDStage6,
  level6.node_level AS NodeLevelStage6,
  level6.node_type AS NodeTypeStage6,
  level6.node_lval AS NodeLowValueStage6,
  level6.node_pid AS HierNodeParentID6
FROM uhdt_node AS UniversalHierNode
INNER JOIN uhdt_vrsn AS version ON /* join condition not captured in parsed metadata */
;

Learn More