R_HIERRUNTIMERPRSTNNODEATTRIB

CDS View

Hierarchy Node Attribute

R_HIERRUNTIMERPRSTNNODEATTRIB is a CDS View in S/4HANA. Hierarchy Node Attribute. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FinStmntExpandedHierNode view left_outer COMPOSITE Financial Statement Expanded Hier Node
P_FSTMT_GLACCOUNT_ENH view left_outer CONSUMPTION

Fields (1)

KeyField CDS FieldsUsed in Views
HierNodeAttributeRangeFromVal AgingIncrement,SignIsInverted 2 
@AbapCatalog.sqlViewName: 'RHRRPATTRNOD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Hierarchy Node Attribute'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #B,
    sizeCategory: #XXL
   }
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'R_HierRtmeRprstnNdeAddlAttrib'

define view R_HierRuntimeRprstnNodeAttrib
  as select from hrrp_attr_node
  association [0..1] to R_HierRuntimeRepresentation as _Hierarchy on  $projection.HierarchyID      = _Hierarchy.HierarchyID
                                                                  and $projection.HierarchyVersion = _Hierarchy.HierarchyVersion
                                                                  and $projection.ValidityEndDate  = _Hierarchy.ValidityEndDate
{

  key       hryid                                                       as HierarchyID,
  key       cast( '000000000000001' as hryversn preserving type  )      as HierarchyVersion, //keep it for compatibility

            @Semantics.businessDate.to: true
  key       cast(hrrp_attr_node.hryvalto as fis_datbi preserving type ) as ValidityEndDate,
  key       hrrp_attr_node.hrynode                                      as HierarchyNode,
  key       hrrp_attr_node.nodecls                                      as HierarchyNodeClass,
  key       hrrp_attr_node.parnode                                      as ParentNode,
  key       hryattrname                                                 as HierarchyNodeAttributeName,
  key       hryattrvalue                                                as HierNodeAttributeRangeFromVal,
            hryattrhvalue                                               as HierNodeAttributeRangeToVal,
            _Hierarchy
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRRP_ATTR_NODE"
],
"ASSOCIATED":
[
"R_HIERRUNTIMEREPRESENTATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More