FIISAL_GR_GLAcctGlobHier

DDL: FIISAL_GR_GLACCTGLOBHIER Type: view_entity
42 Fields 1 Data Sources

Greece GLAccount hierarchy

FIISAL_GR_GLAcctGlobHier is a CDS View that provides data about "Greece GLAccount hierarchy" in SAP S/4HANA. It reads from 1 data source (I_UniversalHierNode) and exposes 42 fields with key field UniversalHierNodeID.

Data Sources (1)

SourceAliasJoin Type
I_UniversalHierNode UniversalHierNode from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY 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 (42)

KeyFieldSource TableSource FieldDescription
KEY UniversalHierNodeID I_UniversalHierNode UniversalHierNodeID Workflow Step
UniversalHierarchyVersionID I_UniversalHierNode UniversalHierarchyVersionID Version ID
UniversalHierNodeLevel I_UniversalHierNode UniversalHierNodeLevel Node Level
UniversalHierNodeType I_UniversalHierNode UniversalHierNodeType Type
UniversalHierNodeValidFrom I_UniversalHierNode UniversalHierNodeValidFrom Node Valid From
UniversalHierNodeValidTo I_UniversalHierNode UniversalHierNodeValidTo Node Valid To
UniversalHierNodeLowValue I_UniversalHierNode UniversalHierNodeLowValue Node Low Value
UniversalHierNodeParentID I_UniversalHierNode UniversalHierNodeParentID Node Parent ID
UniversalHierHierarchyType
UniversalHierHierarchyID
NodeIDStage1 level1 UniversalHierNodeID Workflow Step
NodeLevelStage1 level1 UniversalHierNodeLevel Node Level
NodeTypeStage1 level1 UniversalHierNodeType Type
NodeLowValueStage1 level1 UniversalHierNodeLowValue Node Low Value
HierNodeParentID1 level1 UniversalHierNodeParentID Node Parent ID
NodeIDStage2 level2 UniversalHierNodeID Workflow Step
NodeLevelStage2 level2 UniversalHierNodeLevel Node Level
NodeTypeStage2 level2 UniversalHierNodeType Type
NodeLowValueStage2 level2 UniversalHierNodeLowValue Node Low Value
HierNodeParentID2 level2 UniversalHierNodeParentID Node Parent ID
NodeIDStage3 level3 UniversalHierNodeID Workflow Step
NodeLevelStage3 level3 UniversalHierNodeLevel Node Level
NodeTypeStage3 level3 UniversalHierNodeType Type
NodeLowValueStage3 level3 UniversalHierNodeLowValue Node Low Value
HierNodeParentID3 level3 UniversalHierNodeParentID Node Parent ID
NodeIDStage4 level4 UniversalHierNodeID Workflow Step
NodeLevelStage4 level4 UniversalHierNodeLevel Node Level
NodeTypeStage4 level4 UniversalHierNodeType Type
NodeLowValueStage4 level4 UniversalHierNodeLowValue Node Low Value
HierNodeParentID4 level4 UniversalHierNodeParentID Node Parent ID
NodeIDStage5 level5 UniversalHierNodeID Workflow Step
NodeLevelStage5 level5 UniversalHierNodeLevel Node Level
NodeTypeStage5 level5 UniversalHierNodeType Type
NodeLowValueStage5 level5 UniversalHierNodeLowValue Node Low Value
HierNodeParentID5 level5 UniversalHierNodeParentID Node Parent ID
NodeIDStage6 level6 UniversalHierNodeID Workflow Step
NodeLevelStage6 level6 UniversalHierNodeLevel Node Level
NodeTypeStage6 level6 UniversalHierNodeType Type
NodeLowValueStage6 level6 UniversalHierNodeLowValue Node Low Value
HierNodeParentID6 level6 UniversalHierNodeParentID Node Parent ID
_Version I_UniversalHierNode _Version
_Text I_UniversalHierNode _Text

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_GLAcctGlobHier.
-- 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_GLAcctGlobHier AS
SELECT
  UniversalHierNode.UniversalHierNodeID AS UniversalHierNodeID,
  UniversalHierNode.UniversalHierarchyVersionID AS UniversalHierarchyVersionID,
  UniversalHierNode.UniversalHierNodeLevel AS UniversalHierNodeLevel,
  UniversalHierNode.UniversalHierNodeType AS UniversalHierNodeType,
  UniversalHierNode.UniversalHierNodeValidFrom AS UniversalHierNodeValidFrom,
  UniversalHierNode.UniversalHierNodeValidTo AS UniversalHierNodeValidTo,
  UniversalHierNode.UniversalHierNodeLowValue AS UniversalHierNodeLowValue,
  UniversalHierNode.UniversalHierNodeParentID AS UniversalHierNodeParentID,
  UniversalHierNode._Version.UniversalHierHierarchyType AS UniversalHierHierarchyType,
  UniversalHierNode._Version.UniversalHierHierarchyID AS UniversalHierHierarchyID,
  level1.UniversalHierNodeID AS NodeIDStage1,
  level1.UniversalHierNodeLevel AS NodeLevelStage1,
  level1.UniversalHierNodeType AS NodeTypeStage1,
  level1.UniversalHierNodeLowValue AS NodeLowValueStage1,
  level1.UniversalHierNodeParentID AS HierNodeParentID1,
  level2.UniversalHierNodeID AS NodeIDStage2,
  level2.UniversalHierNodeLevel AS NodeLevelStage2,
  level2.UniversalHierNodeType AS NodeTypeStage2,
  level2.UniversalHierNodeLowValue AS NodeLowValueStage2,
  level2.UniversalHierNodeParentID AS HierNodeParentID2,
  level3.UniversalHierNodeID AS NodeIDStage3,
  level3.UniversalHierNodeLevel AS NodeLevelStage3,
  level3.UniversalHierNodeType AS NodeTypeStage3,
  level3.UniversalHierNodeLowValue AS NodeLowValueStage3,
  level3.UniversalHierNodeParentID AS HierNodeParentID3,
  level4.UniversalHierNodeID AS NodeIDStage4,
  level4.UniversalHierNodeLevel AS NodeLevelStage4,
  level4.UniversalHierNodeType AS NodeTypeStage4,
  level4.UniversalHierNodeLowValue AS NodeLowValueStage4,
  level4.UniversalHierNodeParentID AS HierNodeParentID4,
  level5.UniversalHierNodeID AS NodeIDStage5,
  level5.UniversalHierNodeLevel AS NodeLevelStage5,
  level5.UniversalHierNodeType AS NodeTypeStage5,
  level5.UniversalHierNodeLowValue AS NodeLowValueStage5,
  level5.UniversalHierNodeParentID AS HierNodeParentID5,
  level6.UniversalHierNodeID AS NodeIDStage6,
  level6.UniversalHierNodeLevel AS NodeLevelStage6,
  level6.UniversalHierNodeType AS NodeTypeStage6,
  level6.UniversalHierNodeLowValue AS NodeLowValueStage6,
  level6.UniversalHierNodeParentID AS HierNodeParentID6,
  UniversalHierNode._Version AS _Version,
  UniversalHierNode._Text AS _Text
FROM I_UniversalHierNode AS UniversalHierNode
;

Learn More