December 5, 2011

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

1 comment: