SAP Table RSHIEDIR

Hierarchy Catalog

RSHIEDIR (Hierarchy Catalog) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RSHIEDIR to other SAP tables.

RSHIEDIR table fields

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

RSHIEDIR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RSHIEDIR IOBJNM RSHIEDIR IOBJNM RSDIOBJ Directory of all InfoObjects IOBJNM
RSHIEDIR IOBJNM * RSDIOBJ Directory of all InfoObjects OBJVERS
RSHIEDIR LOGSYS RSHIEDIR LOGSYS TBDLS Logical system LOGSYS
RSHIEDIR TSTPNM RSHIEDIR TSTPNM USR02 Logon Data (Kernel-Side Use) BNAME
RSHIEDIR TSTPNM * USR02 Logon Data (Kernel-Side Use) MANDT