SAP ABAP Table BICS_PROV_HIERARCHY (Hierarchy Information (Catalog, Meta data and state))

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-ET (Application Component) End User Technology
     ⤷ RSBOLAP_BICS_PROVIDER (Package) BICS Provider

Basic Data

Table Category	INTTAB	Structure
Structure	BICS_PROV_HIERARCHY	Table Relationship Diagram
Short Description	Hierarchy Information (Catalog, Meta data and state)

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	CHAR_ID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
2	CATALOG_ENTRY	☐	BICS_PROV_META_HIERARCHY_CAT		STRU	0	0
3	NAME	☐	RSBOLAP_OBJECT_NAME	RSBOLAP_OBJECT_NAME	CHAR	40	0	Object Name
4	TEXT	☐	RSBOLAP_OBJECT_TEXT	RSBOLAP_OBJECT_TEXT	CHAR	60	0	Charact. text
5	VERSION	☐	RSBOLAP_VERSION	RSVERSION	CHAR	3	0	Version
6	DATE_FROM	☐	RSBOLAP_DATE	DATUM	DATS	8	0	Date
7	DATE_TO	☐	RSBOLAP_DATE	DATUM	DATS	8	0	Date
8	SUPPORTS_NONE_UNIQUE_LEAVES	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
9	DEFAULT_DRILL_LEVEL	☐	BICS_PROV_HIERARCHY_LEVEL_NUM		INT2	5	0	Level Number in a Hierarchy
10	DEFAULT_ALEAFNODSP	☐	RSSHCRLEAFDSP	RSSHCRLEAFDSP	CHAR	1	0	Do Not Display Leaves for Inner-Nodes in the Query
11	DEFAULT_NODE_ALIGNMENT	☐	RSBOLAP_ALIGNMENT	RSBOLAP_ALIGNMENT	CHAR	1	0	Alignment of Objects (top/left, bottom/right, default)
12	ALEAFNODCH	☐	RSSHCLDSPCH	RSSHCLDSPCH	CHAR	1	0	Display for Generated Leaves Cannot Be Changed
13	SUPPORTS_AD_HOC_MEMBER_ACCESS	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
14	LINKEXIST	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
15	META	☐	BICS_PROV_META_HIERARCHY		STRU	0	0
16	ID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
17	SVER	☐	RSRSVER	CHAR1	CHAR	1	0	Version in Inclusion Table Key
18	NAME	☐	RSBOLAP_OBJECT_NAME	RSBOLAP_OBJECT_NAME	CHAR	40	0	Object Name
19	TEXT	☐	RSBOLAP_OBJECT_TEXT	RSBOLAP_OBJECT_TEXT	CHAR	60	0	Charact. text
20	VERSION	☐	RSBOLAP_VERSION	RSVERSION	CHAR	3	0	Version
21	DUEDATE	☐	RSBOLAP_DATE	DATUM	DATS	8	0	Date
22	HIEID	☐	RSHIEID	SYSUUID_25	CHAR	25	0	Internal hierarchy ID (unique ID)
23	START_DRILL_LEVEL	☐	BICS_PROV_HIERARCHY_LEVEL_NUM		INT2	5	0	Level Number in a Hierarchy
24	RESTTOPSID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
25	ROOT_SID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
26	NOREST_NODES	☐	RSHIERNOREST	RSBOOL	CHAR	1	0	Suppression of unassigned nodes
27	NOREST_FILTERSID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
28	MAX_LEVEL	☐	BICS_PROV_HIERARCHY_LEVEL_NUM		INT2	5	0	Level Number in a Hierarchy
29	NODE_ALIGNMENT	☐	RSBOLAP_ALIGNMENT	RSBOLAP_ALIGNMENT	CHAR	1	0	Alignment of Objects (top/left, bottom/right, default)
30	NODE_VISIBILITY	☐	RSBOLAP_NODE_VISIBILITY	RSBOLAP_VISIBILITY	CHAR	1	0	Visibility of Hierarchy Nodes
31	ALEAFNODSP	☐	RSSHCRLEAFDSP	RSSHCRLEAFDSP	CHAR	1	0	Do Not Display Leaves for Inner-Nodes in the Query
32	ALEAFNODCH	☐	RSSHCLDSPCH	RSSHCLDSPCH	CHAR	1	0	Display for Generated Leaves Cannot Be Changed
33	LEVEL_TEXT	☐	BICS_PROV_META_TS_HRY_LEVEL		TTYP	0	0
34	NODE_TYPES	☐	BICS_PROV_META_TH_NODE_TYPES		TTYP	0	0
35	STATE	☐	BICS_PROV_STATE_HIERARCHY		STRU	0	0
36	ID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
37	ACTIVE	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
38	START_DRILL_LEVEL	☐	BICS_PROV_HIERARCHY_LEVEL_NUM		INT2	5	0	Level Number in a Hierarchy
39	NODE_ALIGNMENT	☐	RSBOLAP_ALIGNMENT	RSBOLAP_ALIGNMENT	CHAR	1	0	Alignment of Objects (top/left, bottom/right, default)
40	NODE_VISIBILITY	☐	RSBOLAP_NODE_VISIBILITY	RSBOLAP_VISIBILITY	CHAR	1	0	Visibility of Hierarchy Nodes
41	MEMBER_ACCESS_MODE	☐	RSMD_RS_READ_MODE	RSMD_RS_READ_MODE	CHAR	1	0	Read Mode(F4) for Master Data Read Services
42	MEMBER_ACCESS_MODES	☐	RSMD_RS_T_READ_MODES		TTYP	0	0
43	ALEAFNODSP	☐	RSSHCRLEAFDSP	RSSHCRLEAFDSP	CHAR	1	0	Do Not Display Leaves for Inner-Nodes in the Query
44	RESULT_SET_SORTING	☐	BICS_PROV_STATE_SORTING		STRU	0	0
45	TYPE	☐	RSBOLAP_SORTING_TYPE	RROSART	CHAR	1	0	Sort Type
46	DIRECTION	☐	RSBOLAP_SORTING_DIRECTION	RROSDIR	CHAR	1	0	Sort Direction
47	ATTRIBUTE_ID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
48	DATA_CELL_ID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
49	PREDEFINED_MEMBERS_ORDER	☐	RSBOLAP_T_OBJECT_ID		TTYP	0	0
50	MEMBER_ACCESS_SORTING	☐	BICS_PROV_STATE_SORTING		STRU	0	0
51	TYPE	☐	RSBOLAP_SORTING_TYPE	RROSART	CHAR	1	0	Sort Type
52	DIRECTION	☐	RSBOLAP_SORTING_DIRECTION	RROSDIR	CHAR	1	0	Sort Direction
53	ATTRIBUTE_ID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
54	DATA_CELL_ID	☐	RSBOLAP_OBJECT_ID	RSBOLAP_OBJECT_ID	INT4	10	0	Object ID
55	PREDEFINED_MEMBERS_ORDER	☐	RSBOLAP_T_OBJECT_ID		TTYP	0	0
56	NODE_TYPES	☐	BICS_PROV_STATE_TH_NODE_TYPE		TTYP	0	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	740