RSRHIEDIR_OLAP - OLAP Relevant Information for the Hierarchies
OLAP Relevant Information for the Hierarchies information is stored in SAP table RSRHIEDIR_OLAP.
It is part of development package RSR_HIER in software component BW-BEX-OT. This development package consists of objects that can be grouped under "OLAP Hierarchy - Services".
It is part of development package RSR_HIER in software component BW-BEX-OT. This development package consists of objects that can be grouped under "OLAP Hierarchy - Services".
Fields for table RSRHIEDIR_OLAP
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| HIESID | SID for Hierarchy ID | X | RSRHIESID | INT4 | 4 | |
| OBJVERS | Object version | X | RSOBJVERS | CHAR | 2 | |
| HDATE | Key date for which the hierarchy structure is stored | X | RSRHDATE | DATS | 16 | |
| TMPJOIN | Hierarchy Version for "Temporal Join" | X | RRHITMPJOIN | CHAR | 2 | |
| DELETETIMESTMP | Time from which the entry can be deleted | X | RSRDELTIMESTMP | DEC | 8 | |
| SVER | Version in Inclusion Table Key | RSRSVER | CHAR | 2 | ||
| HIEID | Internal hierarchy ID (unique ID) | RSHIEID | CHAR | 50 | ||
| CHABASNM | InfoObject | RSIOBJNM | CHAR | 60 | ||
| ROOTSID | Master data ID | RSSID | INT4 | 4 | ||
| RESTLEAFSID | Master data ID | RSSID | INT4 | 4 | ||
| RESTTOPSID | Master data ID | RSSID | INT4 | 4 | ||
| SIDRANGE | Number Range Start for SIDs | RRHISIDRANGE | NUMC | 6 | ||
| .INCLUDE | RSRHIEFLAGS | 0 | ||||
| MAXTLEVEL | Level of a Hierarchy Node (as Integer) | RSRTLEVEL | INT4 | 4 | ||
| INTVLFL | Flag: Hierarchy contains intervals | RSRINTVLFL | CHAR | 2 | ||
| HIENDTFL | Hierarchy structure is time-dependent | RSHIENDTFL | CHAR | 2 | ||
| HIEUNIQUE | Uniqueness of a Hierarchy | RSHIEUNIQE | NUMC | 2 | ||
| READMODE | Hierarchy - Data selection on demand - Mode | RRHIREADMODE | CHAR | 2 | ||
| USERDEFREADMODE | Boolean | RS_BOOL | CHAR | 2 | ||
| NORESTNODES | Suppression of unassigned nodes | RSHIERNOREST | CHAR | 2 | ||
| FILTERSID | Filter Node (SID) for the Hierarchy | RSRFILTERSID | INT4 | 4 | ||
| TIMESTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 8 | ||
| ALEAFNODSP | Do Not Display Leaves for Inner-Nodes in the Query | RSSHCRLEAFDSP | CHAR | 2 | ||
| ALEAFNODCH | Display for Generated Leaves Cannot Be Changed | RSSHCLDSPCH | CHAR | 2 | ||
| VIRTUELL | Boolean | RS_BOOL | CHAR | 2 | ||
| DONTCOMPLETE | Do Not Complete Hierarchy (Remaining + Intervals) | RRHIDONTCOMPLETE | CHAR | 2 | ||
| HIERCLNM | Name of the Hierarchy Read Class | RRHICLNM | CHAR | 60 | ||
| HIERCLPA | Parameter for Hierarhcy Read Class | RRHICLPA | CHAR | 200 | ||
| TIMESTMP_SOURCE | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 8 | ||
| CARDFIX | Exact Cardinality | RSRCARDEXACT | INT4 | 4 | ||
| CARDREST | Exact Cardinality | RSRCARDEXACT | INT4 | 4 | ||
| CARDINTVL | Exact Cardinality | RSRCARDEXACT | INT4 | 4 | ||
| BIA_INDEX | Hierarchy Index in BWA | RSRHIERBIAINDEX | CHAR | 2 | ||
| VALID_FROM | Valid-From Date | RSDATEFROM | DATS | 16 | ||
| VALID_TO | Valid-to date | RSDATETO | DATS | 16 | ||
| VALID4RS2HANA | Valid for Hierarchy External HANA View? (0 = no, 1 = yes) | RS2HANA_CHECKED | CHAR | 2 | ||
| DONTBUFFER | Boolean | RS_BOOL | CHAR | 2 |