I_UniversalHierNode

DDL: I_UNIVERSALHIERNODE SQL: IUHNODE Type: view BASIC

Universal Hierarchy Node

I_UniversalHierNode is a Basic CDS View that provides data about "Universal Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (uhdt_node) and exposes 21 fields with key field UniversalHierNodeID. It has 3 associations to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
uhdt_node uhdt_node from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_UniversalHierNodeText _Text $projection.UniversalHierNodeID = _Text.UniversalHierNodeID
[1..1] I_UniversalHierVersion _Version $projection.UniversalHierarchyVersionID = _Version.UniversalHierarchyVersionID
[0..*] I_UniversalHierClassFieldVal _ClFdValue $projection.UniversalHierNodeID = _ClFdValue.UniversalHierObjectID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IUHNODE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Universal Hierarchy Node view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #BASIC view
ObjectModel.representativeKey UniversalHierNodeID view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY UniversalHierNodeID node_id
UniversalHierarchyVersionID ver_id
UniversalHierNodeParentID node_pid
UniversalHierNodeRefID node_rid
UniversalHierNodeType node_type
UniversalHierNodeEntity node_entity
UniversalHierNodeLevel node_level
UniversalHierNodeSequence node_seq
UniversalHierNodeDisplayOrder node_order
UniversalHierNodeSign node_sgn
UniversalHierNodeValidFrom node_vldfm
UniversalHierNodeValidTo node_vldto
UniversalHierNodeLowValue node_lval
UniversalHierNodeHighValue node_hval
UniversalHierNodeCreatedAt created_at
UniversalHierNodeCreatedBy created_by
UniversalHierNodeUpdatedAt updated_at
UniversalHierNodeUpdatedBy updated_by
_Text _Text
_Version _Version
_ClFdValue _ClFdValue 
@AbapCatalog.sqlViewName: 'IUHNODE'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Universal Hierarchy Node'

@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #B,
  sizeCategory: #XXL
}

@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'UniversalHierNodeID'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_UniversalHierNode as select from uhdt_node 

association [0..*] to I_UniversalHierNodeText as _Text on $projection.UniversalHierNodeID = _Text.UniversalHierNodeID
association [1..1] to I_UniversalHierVersion as _Version on $projection.UniversalHierarchyVersionID = _Version.UniversalHierarchyVersionID
association [0..*] to I_UniversalHierClassFieldVal as _ClFdValue on $projection.UniversalHierNodeID = _ClFdValue.UniversalHierObjectID
{
      @ObjectModel.text.association: '_Text'
  key node_id                       as  UniversalHierNodeID,
      ver_id                        as  UniversalHierarchyVersionID,
      node_pid                      as  UniversalHierNodeParentID,
      node_rid                      as  UniversalHierNodeRefID,
      node_type                     as  UniversalHierNodeType,
      node_entity                   as  UniversalHierNodeEntity,
      node_level                    as  UniversalHierNodeLevel,
      node_seq                      as  UniversalHierNodeSequence,
      node_order                    as  UniversalHierNodeDisplayOrder,
      node_sgn                      as  UniversalHierNodeSign,
      
      @Semantics.businessDate.from: true
      node_vldfm                    as  UniversalHierNodeValidFrom,
      
      @Semantics.businessDate.to: true
      node_vldto                    as  UniversalHierNodeValidTo,
      node_lval                     as  UniversalHierNodeLowValue,
      node_hval                     as  UniversalHierNodeHighValue,
      created_at                    as  UniversalHierNodeCreatedAt,
      created_by                    as  UniversalHierNodeCreatedBy,
      updated_at                    as  UniversalHierNodeUpdatedAt,
      updated_by                    as  UniversalHierNodeUpdatedBy,
      //ref_verid                     as  UniversalHierRefVersionID,

      _Text,
      _Version,
      _ClFdValue
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UHDT_NODE"
],
"ASSOCIATED":
[
"I_UNIVERSALHIERCLASSFIELDVAL",
"I_UNIVERSALHIERNODETEXT",
"I_UNIVERSALHIERVERSION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More