SAP ABAP Table RSRHIEDIR_OLAP (OLAP Relevant Information for the Hierarchies)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSR_HIER (Package) OLAP Hierarchy - Services

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	RSRHIEDIR_OLAP	Table Relationship Diagram
Short Description	OLAP Relevant Information for the Hierarchies

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	HIESID	☑	RSRHIESID	RSSID	INT4	10	0	SID for Hierarchy ID
2	OBJVERS	☑	RSOBJVERS	RSOBJVERS	CHAR	1	0	Object version
3	HDATE	☑	RSRHDATE	RSDATE	DATS	8	0	Key date for which the hierarchy structure is stored
4	TMPJOIN	☑	RRHITMPJOIN	RS_BOOL	CHAR	1	0	Hierarchy Version for "Temporal Join"
5	DELETETIMESTMP	☑	RSRDELTIMESTMP	TZNTSTMPS	DEC	15	0	Time from which the entry can be deleted
6	SVER	☐	RSRSVER	CHAR1	CHAR	1	0	Version in Inclusion Table Key
7	HIEID	☐	RSHIEID	SYSUUID_25	CHAR	25	0	Internal hierarchy ID (unique ID)
8	CHABASNM	☐	RSIOBJNM	RSIOBJNM	CHAR	30	0	InfoObject
9	ROOTSID	☐	RSSID	RSSID	INT4	10	0	Master data ID
10	RESTLEAFSID	☐	RSSID	RSSID	INT4	10	0	Master data ID
11	RESTTOPSID	☐	RSSID	RSSID	INT4	10	0	Master data ID
12	SIDRANGE	☐	RRHISIDRANGE	NUMC3	NUMC	3	0	Number Range Start for SIDs
13	.INCLUDE	☐				0	0	Technical attributes of the hierarchy
14	MAXTLEVEL	☐	RSRTLEVEL	RSRTLEVEL	INT4	10	0	Level of a Hierarchy Node (as Integer)
15	INTVLFL	☐	RSRINTVLFL	RSBOOL	CHAR	1	0	Flag: Hierarchy contains intervals
16	HIENDTFL	☐	RSHIENDTFL	XFELD	CHAR	1	0	Hierarchy structure is time-dependent
17	HIEUNIQUE	☐	RSHIEUNIQE	RSHIEUNIQE	NUMC	1	0	Uniqueness of a Hierarchy
18	READMODE	☐	RRHIREADMODE	RRHIREADMODE	CHAR	1	0	Hierarchy - Data selection on demand - Mode
19	USERDEFREADMODE	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
20	NORESTNODES	☐	RSHIERNOREST	RSBOOL	CHAR	1	0	Suppression of unassigned nodes
21	FILTERSID	☐	RSRFILTERSID	RSSID	INT4	10	0	Filter Node (SID) for the Hierarchy
22	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
23	ALEAFNODSP	☐	RSSHCRLEAFDSP	RSSHCRLEAFDSP	CHAR	1	0	Do Not Display Leaves for Inner-Nodes in the Query
24	ALEAFNODCH	☐	RSSHCLDSPCH	RSSHCLDSPCH	CHAR	1	0	Display for Generated Leaves Cannot Be Changed
25	VIRTUELL	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
26	DONTCOMPLETE	☐	RRHIDONTCOMPLETE	RSBOOL	CHAR	1	0	Do Not Complete Hierarchy (Remaining + Intervals)
27	HIERCLNM	☐	RRHICLNM	SEOCLSNAME	CHAR	30	0	Name of the Hierarchy Read Class
28	HIERCLPA	☐	RRHICLPA	CHAR100	CHAR	100	0	Parameter for Hierarhcy Read Class
29	TIMESTMP_SOURCE	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
30	CARDFIX	☐	RSRCARDEXACT	RSRCARDEXACT	INT4	10	0	Exact Cardinality
31	CARDREST	☐	RSRCARDEXACT	RSRCARDEXACT	INT4	10	0	Exact Cardinality
32	CARDINTVL	☐	RSRCARDEXACT	RSRCARDEXACT	INT4	10	0	Exact Cardinality
33	BIA_INDEX	☐	RSRHIERBIAINDEX	RSRHIERBIAINDEX	CHAR	1	0	Hierarchy Index in BWA
34	VALID_FROM	☐	RSDATEFROM	DATUM	DATS	8	0	Valid-From Date
35	VALID_TO	☐	RSDATETO	DATUM	DATS	8	0	Valid-to date

History

Last changed by/on	SAP	20130604
SAP Release Created in