SAP ABAP Table RRT_HIERARCHIES (Information about the hierarchies available in a dimension)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSR_MDX_BASE (Package) MDX: Basis

Basic Data

Table Category	INTTAB	Structure
Structure	RRT_HIERARCHIES	Table Relationship Diagram
Short Description	Information about the hierarchies available in a dimension

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	CAT_NAM	☐	RRTCATALOG	CHAR32	CHAR	32	0	CATALOG to which the CUBE belongs
2	CUBE_NAM	☐	RRTCUBE	RRTCUBE	CHAR	70	0	Cube name
3	DIM_UNAM	☐	RRTDIMUNAM	RRTDIMUNAM	CHAR	32	0	Unique name of dimension (dimension unique name)
4	HRY_NAM	☐	RRTHRYNAM	CHAR41	CHAR	41	0	Name of a hierarchy (hienm30, version3, dateto8)
5	HRY_UNAM	☐	RRTHRYUNAM	CHAR65	CHAR	65	0	Hierarchy Unique Name
6	HRY_UID	☐	SYSUUID_25	SYSUUID_25	CHAR	25	0	UUID in compressed form
7	HRY_CAP	☐	RSTXTLG	TEXT60	CHAR	60	0	Long description
8	DIM_TYPE	☐	RRTDIMENSIONTYPE	RRTDIMENSIONTYPE	NUMC	1	0	Type of dimension (TIME, MEASURE)
9	HRY_CARDINALITY	☐	RRTDIMCARDINAL	NUMC6	NUMC	6	0	Cardinality of the dimension (Approx. number of members)
10	DFLT_MEM	☐	RRTMEMUNAM	RRTMEMUNAM	CHAR	143	0	Unique name of a member
11	ALL_MEM	☐	RRTMEMUNAM	RRTMEMUNAM	CHAR	143	0	Unique name of a member
12	DSCRPTN	☐	RSTXTLG	TEXT60	CHAR	60	0	Long description

History

Last changed by/on	SAP	20130604
SAP Release Created in