SAP table RSHIEDIR (Hierarchy Catalog)

SAP table RSHIEDIR has 2 primary key fields being HIEID,OBJVERS.

Field Description Data Type Length Decimals Checktable Data Element
HIEID Internal hierarchy ID (unique ID) CHAR 25 0 RSHIEID
OBJVERS Object version CHAR 1 0 RSOBJVERS
A Active
D Content
H Historic
M Revised
N New
T Transport
HIETYPE BW Hierarchy Types CHAR 1 0 RSHITYPE
HIENM Hierarchy name CHAR 30 0 RSHIENM
VERSION Hierarchy version CHAR 3 0 RSVERSION
DATETO Valid-to date DATS 8 0 RSDATETO
IOBJNM InfoObject CHAR 30 0 RSDIOBJ RSIOBJNM
DATEFROM Valid-From Date DATS 8 0 RSDATEFROM
LOGSYS Source system CHAR 10 0 TBDLS RSSLOGSYS
REQUEST Request number for the data transfer CHAR 30 0 RSREQUNR
OBJSTAT Object Status CHAR 3 0 RSOBJSTAT
ACT Active, executable
INA Inactive, not executable
OFF Switched off
PRO Production
ACTIVFL Active and revised version do not agree CHAR 1 0 RSACTIVFL
CONTREL Content release CHAR 6 0 RSCONTREL
OWNER Owner (Person Responsible) CHAR 12 0 * RSOWNER
DBPART DB partition CHAR 16 0 RSDBPART
HIENDTFL Hierarchy structure is time-dependent CHAR 1 0 RSHIENDTFL
NORESTNODES Suppression of unassigned nodes CHAR 1 0 RSHIERNOREST
STARTLEVEL Level on which the hierarchy is first expanded NUMC 2 0 RSSTARTLEVEL
NUMBERLEVEL Number of levels in a hierarchy NUMC 2 0 RSNUMBERLEV
MAXNODEID Largest Node ID of Hierarchy NUMC 8 0 RSMAXNODEID
LEVELTABTYPE Level table type for hierarchies in BW NUMC 1 0 RSLEVELTABTYPE
0 No level table available
1 Level table with description
2 Levels are restricted to certain InfoObjects
3 Levels are restricted with description and to certain IOs
NODEPOSITION Positions of the nodes in reference to their leaves CHAR 1 0 RRXHRYNODEPOSIT
Above
0 Default
1 Below
2 Above
ALEAFNODSP Do Not Display Leaves for Inner-Nodes in the Query CHAR 1 0 RSSHCRLEAFDSP
Created Sheets are Displayed in the Query
X Created Sheets are not Displayed in the Query
ALEAFNODCH Display for Generated Leaves Cannot Be Changed CHAR 1 0 RSSHCLDSPCH
Display Behavior of Sheets Created Can Be Changed
X Display Behavior of Sheets Created Cannot Be Changed
TSTPNM Last Changed By CHAR 12 0 USR02 RSTSTPNM
TIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 RSTIMESTMP
CONSISTENT Indicator: hierarchy is consistent CHAR 1 0 RSCHECKED2
SIGNCHEXIST Reverse Sign Set for at Least one Node CHAR 1 0 RSSHSIGNCHEXIST
Reverse of Sign not Set for any Node
X Reverse of Sign Set for at Least one Node
LINKEXIST Link Nodes Exist CHAR 1 0 RSSHLINKEXIST
ROOTID Hierarchy Root Node Id NUMC 8 0 RSSHROOTID
INTERVALLEXIST Flag: Hierarchy contains intervals CHAR 1 0 RSRINTVLFL
HIERCLNM Name of the Hierarchy Read Class CHAR 30 0 RRHICLNM
SOURCE_TIMESTMP UTC Time Stamp of Last Change to Data in Source DEC 15 0 RSSH_SOURCE_TIMESTMP
IS_REMOTE_HIER Hierarchy Data Only Returned by Remote DTP (Indicator) CHAR 1 0 RSSH_IS_REMOTE_HIER
DTP_ID Data Transfer Process ID CHAR 30 0 RSBKDTPNM

RSHIEDIR foreign key relationships

Table Field Check Table Check Field
0 RSHIEDIR IOBJNM RSDIOBJ Directory of all InfoObjects OBJVERS
1 RSHIEDIR LOGSYS TBDLS Logical system LOGSYS
0 RSHIEDIR TSTPNM USR02 Logon Data (Kernel-Side Use) BNAME