I_HierRuntimeRprstnNodeText

DDL: I_HIERRUNTIMERPRSTNNODETEXT SQL: IHRRPNODET Type: view BASIC Package: FINS_FI_HRRP

Hierarchy Node - Text

I_HierRuntimeRprstnNodeText is a Basic CDS View that provides data about "Hierarchy Node - Text" in SAP S/4HANA. It reads from 1 data source (hrrp_nodet_n) and exposes 21 fields with key fields RuntimeHierarchy, ValidityEndDate, HierarchyNode, HierarchyNodeClass, ParentNode. It has 2 associations to related views. Part of development package FINS_FI_HRRP.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
hrrp_nodet_n hrrp_nodet_n from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_HierRuntimeRepresentation _Hierarchy $projection.RuntimeHierarchy = _Hierarchy.RuntimeHierarchy and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IHRRPNODET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Hierarchy Node - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY RuntimeHierarchy hryid
KEY ValidityEndDate
KEY HierarchyNode hrynode
KEY HierarchyNodeClass nodecls
KEY ParentNode parnode
KEY Language spras
HierarchyType hrytyp
ValidityStartDate
HierarchyNodeText nodetxt
ControllingArea kokrs
ChartOfAccounts ktopl
ConsolidationChartOfAccounts itclg
SubItemCategory sityp
ValidationScenarioID scen_id
FinancialManagementArea fikrs
FinMgmtAreaFiscalYear fma_fisyear
HierarchyNodeIsTimeDependent node_timedep
UniversalHierNodeID uhnodeid
UniversalHierNodeParentID par_uhnodeid
_Hierarchy _Hierarchy
_Language _Language 
@AbapCatalog.sqlViewName: 'IHRRPNODET'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Hierarchy Node - Text'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#PUBLIC_LOCAL_API
@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #B,
    sizeCategory: #XXL
   }
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.dataCategory: #TEXT
define view I_HierRuntimeRprstnNodeText
  as select from hrrp_nodet_n
  association [0..1] to I_Language                  as _Language  on  $projection.Language = _Language.Language
  association [0..1] to I_HierRuntimeRepresentation as _Hierarchy on  $projection.RuntimeHierarchy = _Hierarchy.RuntimeHierarchy
                                                                  and $projection.ValidityEndDate  = _Hierarchy.ValidityEndDate
{

  key       hryid                                         as RuntimeHierarchy,
            @Semantics.businessDate.to: true
  key       cast(hryvalto as fis_datbi preserving type )  as ValidityEndDate,
  key       hrynode                                       as HierarchyNode,
  key       nodecls                                       as HierarchyNodeClass,
  key       parnode                                       as ParentNode,
            @ObjectModel.foreignKey.association: '_Language'
            @Semantics.language:true
  key       spras                                         as Language,
            hrytyp                                        as HierarchyType,
            @Semantics.businessDate.from: true
            cast(hryvalfrom as fis_datab preserving type) as ValidityStartDate,

            @Semantics.text: true
            nodetxt                                       as HierarchyNodeText,
            //HRRP_SI_CLFD

            kokrs                                         as ControllingArea, //FIS_KOKRS

            ktopl                                         as ChartOfAccounts, //FIS_KTOPL

            itclg                                         as ConsolidationChartOfAccounts,
            sityp                                         as SubItemCategory,
            scen_id                                       as ValidationScenarioID,
            fikrs                                         as FinancialManagementArea,
            fma_fisyear                                   as FinMgmtAreaFiscalYear,
            node_timedep                                  as HierarchyNodeIsTimeDependent,
            uhnodeid                                      as UniversalHierNodeID,
            par_uhnodeid                                  as UniversalHierNodeParentID,
            _Hierarchy,
            _Language
}
where hrytyp not like 'C$%'

Learn More