R_HierRuntimeRprstnDplLeafNode

DDL: R_HIERRUNTIMERPRSTNDPLLEAFNODE Type: view_entity BASIC

Hierarchy Duplicated Leaf Values

R_HierRuntimeRprstnDplLeafNode is a Basic CDS View that provides data about "Hierarchy Duplicated Leaf Values" in SAP S/4HANA. It reads from 1 data source (hrrp_node_n) and exposes 14 fields with key fields UniversalHierarchy, HierarchyVersion, ValidityEndDate, HierarchyNode, HierarchyNodeClass. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
hrrp_node_n hrrp_node_n from

Associations (2)

CardinalityTargetAliasCondition
[0..1] R_HierRuntimeRprstnNodeText _Text $projection.UniversalHierarchy = _Text.HierarchyID and $projection.HierarchyVersion = _Text.HierarchyVersion and $projection.ValidityEndDate = _Text.ValidityEndDate and $projection.HierarchyNode = _Text.HierarchyNode and $projection.HierarchyNodeClass = _Text.HierarchyNodeClass and $projection.HierarchyParentNode = _Text.ParentNode and _Text.Language = $session.system_language
[0..1] R_HierRuntimeRepresentation _Hierarchy $projection.UniversalHierarchy = _Hierarchy.HierarchyID and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate and $projection.HierarchyVersion = _Hierarchy.HierarchyVersion

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Hierarchy Duplicated Leaf Values view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY UniversalHierarchy hryid_42
KEY HierarchyVersion
KEY ValidityEndDate
KEY HierarchyNode hrynode
KEY HierarchyNodeClass nodecls
KEY HierarchyParentNode parnode
ValidityStartDate
UnivHierarchyBusinessEntity leafvalue
NodeType nodetype
HierarchyNodeVal nodevalue
HierarchyNodeLevel hrylevel
HierarchyType hrytyp
_Text _Text
_Hierarchy _Hierarchy 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Hierarchy Duplicated Leaf Values'

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #XXL
}

define view entity R_HierRuntimeRprstnDplLeafNode
  as select from hrrp_node_n

  association [0..1] to R_HierRuntimeRprstnNodeText as _Text      on  $projection.UniversalHierarchy  = _Text.HierarchyID
                                                                  and $projection.HierarchyVersion    = _Text.HierarchyVersion
                                                                  and $projection.ValidityEndDate     = _Text.ValidityEndDate
                                                                  and $projection.HierarchyNode       = _Text.HierarchyNode
                                                                  and $projection.HierarchyNodeClass  = _Text.HierarchyNodeClass
                                                                  and $projection.HierarchyParentNode = _Text.ParentNode
                                                                  and _Text.Language                  = $session.system_language
  association [0..1] to R_HierRuntimeRepresentation as _Hierarchy on  $projection.UniversalHierarchy = _Hierarchy.HierarchyID
                                                                  and $projection.ValidityEndDate    = _Hierarchy.ValidityEndDate
                                                                  and $projection.HierarchyVersion   = _Hierarchy.HierarchyVersion
{

  key hryid_42                                              as UniversalHierarchy,
  key cast( '000000000000001' as hryversn preserving type ) as HierarchyVersion,
      @Semantics.businessDate.to: true
  key cast(hryvalto as fis_datbi preserving type )          as ValidityEndDate,
      @ObjectModel.text.association: '_Text'
  key hrynode                                               as HierarchyNode,
  key nodecls                                               as HierarchyNodeClass,
  key parnode                                               as HierarchyParentNode,

      @Semantics.businessDate.from: true
      cast(hryvalfrom as fis_datab preserving type )        as ValidityStartDate,
      leafvalue                                             as UnivHierarchyBusinessEntity,
      nodetype                                              as NodeType,
      nodevalue                                             as HierarchyNodeVal,
      hrylevel                                              as HierarchyNodeLevel,
      hrytyp                                                as HierarchyType,
      _Text,
      _Hierarchy

}
where
     nodetype = 'D'
  or nodetype = 'L'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRRP_NODE_N"
],
"ASSOCIATED":
[
"R_HIERRUNTIMEREPRESENTATION",
"R_HIERRUNTIMERPRSTNNODETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More