RSHIEDIR - Hierarchy Catalog
Hierarchy Catalog information is stored in SAP table RSHIEDIR.
It is part of development package RSSH in software component BW-WHM-DBA. This development package consists of objects that can be grouped under "BW: Hierarchy Processing - General".
It is part of development package RSSH in software component BW-WHM-DBA. This development package consists of objects that can be grouped under "BW: Hierarchy Processing - General".
Fields for table RSHIEDIR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| HIEID | Internal hierarchy ID (unique ID) | X | RSHIEID | CHAR | 25 | |
| OBJVERS | Object version | X | RSOBJVERS | CHAR | 1 | |
| HIETYPE | BW Hierarchy Types | RSHITYPE | CHAR | 1 | ||
| HIENM | Hierarchy name | RSHIENM | CHAR | 30 | ||
| VERSION | Hierarchy version | RSVERSION | CHAR | 3 | ||
| DATETO | Valid-to date | RSDATETO | DATS | 8 | ||
| IOBJNM | InfoObject | RSIOBJNM | CHAR | 30 | RSDIOBJ | |
| DATEFROM | Valid-From Date | RSDATEFROM | DATS | 8 | ||
| LOGSYS | Source system | RSSLOGSYS | CHAR | 10 | TBDLS | |
| REQUEST | Request number for the data transfer | RSREQUNR | CHAR | 30 | ||
| OBJSTAT | Object Status | RSOBJSTAT | CHAR | 3 | ||
| ACTIVFL | Active and revised version do not agree | RSACTIVFL | CHAR | 1 | ||
| CONTREL | Content release | RSCONTREL | CHAR | 6 | ||
| OWNER | Owner (Person Responsible) | RSOWNER | CHAR | 12 | * | |
| DBPART | DB partition | RSDBPART | CHAR | 16 | ||
| HIENDTFL | Hierarchy structure is time-dependent | RSHIENDTFL | CHAR | 1 | ||
| NORESTNODES | Suppression of unassigned nodes | RSHIERNOREST | CHAR | 1 | ||
| STARTLEVEL | Level on which the hierarchy is first expanded | RSSTARTLEVEL | NUMC | 2 | ||
| NUMBERLEVEL | Number of levels in a hierarchy | RSNUMBERLEV | NUMC | 2 | ||
| MAXNODEID | Largest Node ID of Hierarchy | RSMAXNODEID | NUMC | 8 | ||
| LEVELTABTYPE | Level table type for hierarchies in BW | RSLEVELTABTYPE | NUMC | 1 | ||
| NODEPOSITION | Positions of the nodes in reference to their leaves | RRXHRYNODEPOSIT | CHAR | 1 | ||
| ALEAFNODSP | Do Not Display Leaves for Inner-Nodes in the Query | RSSHCRLEAFDSP | CHAR | 1 | ||
| ALEAFNODCH | Display for Generated Leaves Cannot Be Changed | RSSHCLDSPCH | CHAR | 1 | ||
| .INCLUDE | RSTSTPINT | 0 | ||||
| TSTPNM | Last Changed By | RSTSTPNM | CHAR | 12 | USR02 | |
| TIMESTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 8 | ||
| CONSISTENT | Indicator: hierarchy is consistent | RSCHECKED2 | CHAR | 1 | ||
| SIGNCHEXIST | Reverse Sign Set for at Least one Node | RSSHSIGNCHEXIST | CHAR | 1 | ||
| LINKEXIST | Link Nodes Exist | RSSHLINKEXIST | CHAR | 1 | ||
| ROOTID | Hierarchy Root Node Id | RSSHROOTID | NUMC | 8 | ||
| INTERVALLEXIST | Flag: Hierarchy contains intervals | RSRINTVLFL | CHAR | 1 | ||
| HIERCLNM | Name of the Hierarchy Read Class | RRHICLNM | CHAR | 30 | ||
| SOURCE_TIMESTMP | UTC Time Stamp of Last Change to Data in Source | RSSH_SOURCE_TIMESTMP | DEC | 8 | ||
| IS_REMOTE_HIER | Hierarchy Data Only Returned by Remote DTP (Indicator) | RSSH_IS_REMOTE_HIER | CHAR | 1 | ||
| DTP_ID | Data Transfer Process ID | RSBKDTPNM | CHAR | 30 |