Hierarchy Tables in SAP BI

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