R_HIERRUNTIMERPRSTNDPLLEAFNODE

CDS View

Hierarchy Duplicated Leaf Values

R_HIERRUNTIMERPRSTNDPLLEAFNODE is a CDS View in S/4HANA. Hierarchy Duplicated Leaf Values. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_HierRuntimeRprstnDplLeafNode view_entity from CONSUMPTION Hierarchy Duplicated Leaf Values 
@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