Child pages
  • Hierarchy Tables
Skip to end of metadata
Go to start of metadata

Hierarchy Tables

Description

RSHIEDIR

Hierarchy Directory, Header Information

RSHIEDIRT

Hierarchy directory texts

/BI*/H<IOBJNM>

Hierarchy structure table

/BI*/J<IOBJNM>

Interval table

RSMHIERNODE

Master data table for text nodes

RSTHIERNODE

Text table for text nodes


 

SID Tables

Description

RSRHIEDIR_OLAP

OLAP table hierarchy directory

/BI*/K<IOBJNM>

Conversion of hierarchy nodes - SID

/BI*/I<IOBJNM>

SID table hierarchy structure

 

Important Fields for RSHIEDIR

Description

HIEID

Internal hierarchy ID (unique ID)

OBJVERS

Object version (M or A)

HIETYPE

Type BW hierarchies 1= master data hierarchy with ref to infoobject

HIENM

Hierarchy name

VERSION

Hierarchy version

DATETO

Date valid to

IOBJNM

InfoObject

DATEFROM

Date valid from

LOGSYS

Source system

REQUEST

Request number for data transfer

TSTPNM

Last changed by

TIMESTMP

UTC time stamp in abbreviated form (YYYYMMDDhhmmss)


 

Fields of Structure table /BI*/H<IOBJNM>

Description

HIEID

Internal hierarchy ID (unique ID)

OBJVERS

Object version

NODEID

Internal ID number for a hierarchy node

IOBJNM

InfoObject

NODENAME

Hierarchy node name

TLEVEL

Hierarchy node level

LINK

Link indicator for a hierarchy node

PARENTID

Parent ID for a hierarchy node

CHILDID

Child ID for a hierarchy node

NEXTID

Next ID for a hierarchy node

DATEFROM

Date valid from

DATETO

Date valid to

INTERVL

Flag: node is interval

SIGNCH

+/- sign reversal




 

Fields of Interval table /BI*/J<IOBJNM>

Description

HIEID

Internal hierarchy ID (unique ID)

OBJVERS

Object version

NODEID

Internal ID number for a hierarchy node

LEAFFROM

Hierarchy leaf from

LEAFTO

Hierarchy leaf to


Fields of Text Node Table RSMHIERNODE

Description

HIEID

Internal hierarchy ID (unique ID)

OBJVERS

Object version

NODENAME

Hierarchy nodes unable to be posted

 

Texts for text nodes RSTHIERNODE

Description

LANGU

Language key

HIEID

Internal hierarchy ID (unique ID)

OBJVERS

Object version

NODENAME

Hierarchy nodes unable to be posted

TXTSH

Short description

TXSTMD

Medium description

TXTLG

Long description

2 Comments

  1.  

    Really useful reference page Vincent!

    I have hierarchies on our BW Production system and want to access their Short Descriptions. When I access the RSTHIERNODE table above via SE16 it tells me the table isn't active in the directory.

    Any suggestions as to how I can see the text descriptions of nodes in a  hierarchy.

    With thanks

    Gill