SAP ABAP Table RROSH (Hierarchies)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSROA_MISC (Package) OLAP: Various

Basic Data

Table Category	INTTAB	Structure
Structure	RROSH	Table Relationship Diagram
Short Description	Hierarchies

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SHID	☐	RRHID	INT4	INT4	10	0	Internal ID for linking to a hierarchy
2	CHABASID	☐	RRCHANMID	RSSID	INT4	10	0	Internal ID of the CHANM
3	CHANMID	☐	RRCHANMID	RSSID	INT4	10	0	Internal ID of the CHANM
4	CHANM	☐	RSCHANM	RSIOBJNM	CHAR	30	0	Characteristic
5	SIDRETURNNM	☐	RSALIAS		CHAR	18	0	BW-DM field alias (cannot be longer than 18)
6	.INCLUDE	☐				0	0	External key of a hierarchy
7	HIENM	☐	RSHIENM	RSHIENM	CHAR	30	0	Hierarchy name
8	VERSION	☐	RSVERSION	RSVERSION	CHAR	3	0	Hierarchy version
9	DATETO	☐	RSDATETO	DATUM	DATS	8	0	Valid-to date
10	HIESID	☐	RSRHIESID	RSSID	INT4	10	0	SID for Hierarchy ID
11	SVER	☐	RSRSVER	CHAR1	CHAR	1	0	Version in Inclusion Table Key
12	HDATE	☐	RSRHDATE	RSDATE	DATS	8	0	Key date for which the hierarchy structure is stored
13	HIENM_VRNID	☐	RRID_NUMC4	NUMC4	NUMC	4	0	Internal ID referenced to other table
14	VERS_VRNID	☐	RRID_NUMC4	NUMC4	NUMC	4	0	Internal ID referenced to other table
15	DATE_VRNID	☐	RRID_NUMC4	NUMC4	NUMC	4	0	Internal ID referenced to other table
16	THJT	☐	RSRHIERTHJT	CHAR10	CHAR	10	0	Key Date Derivation Type
17	VARFL	☐	RRVARIABL	BOOLE	CHAR	1	0	BW: Hierarchy is variable
18	SPDEP	☐	RRSPDEP	RS_BOOL	CHAR	1	0	This Entry Influences the SP
19	ROOTSID	☐	RSSID	RSSID	INT4	10	0	Master data ID
20	RESTLEAFSID	☐	RSSID	RSSID	INT4	10	0	Master data ID
21	RESTTOPSID	☐	RSSID	RSSID	INT4	10	0	Master data ID
22	.INCLUDE	☐				0	0	Technical attributes of the hierarchy
23	MAXTLEVEL	☐	RSRTLEVEL	RSRTLEVEL	INT4	10	0	Level of a Hierarchy Node (as Integer)
24	INTVLFL	☐	RSRINTVLFL	RSBOOL	CHAR	1	0	Flag: Hierarchy contains intervals
25	HIENDTFL	☐	RSHIENDTFL	XFELD	CHAR	1	0	Hierarchy structure is time-dependent
26	HIEUNIQUE	☐	RSHIEUNIQE	RSHIEUNIQE	NUMC	1	0	Uniqueness of a Hierarchy
27	READMODE	☐	RRHIREADMODE	RRHIREADMODE	CHAR	1	0	Hierarchy - Data selection on demand - Mode
28	USERDEFREADMODE	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
29	NORESTNODES	☐	RSHIERNOREST	RSBOOL	CHAR	1	0	Suppression of unassigned nodes
30	FILTERSID	☐	RSRFILTERSID	RSSID	INT4	10	0	Filter Node (SID) for the Hierarchy
31	FREE	☐	RRFREE	BOOLE	CHAR	1	0	BW: Hierarchy is drilldown hierarchy
32	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

History

Last changed by/on	SAP	20130604
SAP Release Created in