SAP ABAP Table HDB_TABLE_SELECTION (Screen: Table/view selection)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ HAN-DB (Application Component) SAP HANA Database
     ⤷ SDBA_HDB (Package) DBACOCKPIT for NewDB (HDB)

Basic Data

Table Category	INTTAB	Structure
Structure	HDB_TABLE_SELECTION	Table Relationship Diagram
Short Description	Screen: Table/view selection

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	ITAB_TABLES	☐	HDB_TABLES_TAB		TTYP	0	0
2	ITAB_VIEWS	☐	HDB_VIEWS_TAB		TTYP	0	0
3	ITAB_MONI	☐	HDB_M_MONITORS_TAB		TTYP	0	0
4	ITAB_SEL	☐	HDB_TABLES_VIEWS_TAB		TTYP	0	0
5	RB_TYPE	☐			STRG	0	0
6	R1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
7	R2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
8	R3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
9	SCHEMA_NAME	☐			STRG	0	0
10	TABLE_NAME	☐			STRG	0	0
11	LABEL_SCHEMA	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
12	LABEL_TABLE_VIEW	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
13	LABEL_TABLES	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
14	LABEL_VIEWS	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
15	LABEL_MONI	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
16	WA_TABLES	☐	HDB_TABLES		STRU	0	0
17	SCHEMA_NAME	☐			STRG	0	0
18	TABLE_NAME	☐			STRG	0	0
19	TABLE_OID	☐			STRG	0	0
20	COMMENTS	☐			STRG	0	0
21	FIXED_PART_SIZE	☐			STRG	0	0
22	IS_LOGGED	☐			STRG	0	0
23	IS_SYSTEM_TABLE	☐			STRG	0	0
24	IS_COLUMN_TABLE	☐			STRG	0	0
25	IS_INSERT_ONLY	☐			STRG	0	0
26	IS_TENANT_SHARED_DATA	☐			STRG	0	0
27	IS_TENANT_SHARED_METADATA	☐			STRG	0	0
28	SESSION_TYPE	☐			STRG	0	0
29	IS_TEMPORARY	☐			STRG	0	0
30	TEMPORARY_TABLE_TYPE	☐			STRG	0	0
31	IS_USER_DEFINED_TYPE	☐			STRG	0	0
32	PARTITION_SPEC	☐			STRG	0	0
33	WA_VIEWS	☐	HDB_VIEWS		STRU	0	0
34	SCHEMA_NAME	☐			STRG	0	0
35	VIEW_NAME	☐			STRG	0	0
36	VIEW_OID	☐			STRG	0	0
37	IS_UNICODE	☐			STRG	0	0
38	IS_READ_ONLY	☐			STRG	0	0
39	HAS_CHECK_OPTION	☐			STRG	0	0
40	HAS_COLUMN_ALIASES	☐			STRG	0	0
41	COMMENTS	☐			STRG	0	0
42	IS_COLUMN_VIEW	☐			STRG	0	0
43	IS_TENANT_SHARED_METADATA	☐			STRG	0	0
44	DEFINITION	☐			STRG	0	0
45	WA_MONI	☐	HDB_M_MONITORS		STRU	0	0
46	SCHEMA_NAME	☐			STRG	0	0
47	VIEW_NAME	☐			STRG	0	0
48	DESCRIPTION	☐			STRG	0	0
49	WA_SEL	☐	HDB_TABLES_VIEWS		STRU	0	0
50	SCHEMA_NAME	☐			STRG	0	0
51	OBJ_NAME	☐			STRG	0	0
52	TYP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
53	TYP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
54	ITAB_TABLE_COLS	☐	HDB_TABLE_COLUMNS_TAB		TTYP	0	0
55	ITAB_VIEW_COLS	☐	HDB_VIEW_COLUMNS_TAB		TTYP	0	0
56	ITAB_MONI_COLS	☐	HDB_M_MONITOR_COLUMNS_TAB		TTYP	0	0
57	ITAB_INDEXES	☐	HDB_INDEXES_TAB		TTYP	0	0
58	LABEL_OID	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
59	OID	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
60	ATTR	☐			STRG	0	0
61	TAB_PROP	☐			STRG	0	0
62	TAB_COL	☐			STRG	0	0
63	TAB_INDEX	☐			STRG	0	0
64	TAB_PART	☐			STRG	0	0
65	LABEL_COLUMN_TABLE	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
66	LABEL_FIXED_PART_SIZE	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
67	LABEL_LOGGED	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
68	LABEL_SYSTEM_TABLE	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
69	LABEL_INSERT_ONLY	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
70	LABEL_TENANT_SHARED_DATA	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
71	LABEL_TENANT_SHARED_METADATA	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
72	LABEL_SESSION_TYPE	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
73	LABEL_TEMPORARY	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
74	LABEL_TEMPORARY_TABLE_TYPE	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
75	LABEL_USER_DEFINED_TYPE	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
76	LABEL_READ_ONLY	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
77	LABEL_UNICODE	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
78	LABEL_CHECK_OPTION	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
79	LABEL_COLUMN_ALIASES	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
80	OUT_COLUMN_TABLE	☐			STRG	0	0
81	OUT_FIXED_PART_SIZE	☐			STRG	0	0
82	OUT_LOGGED	☐			STRG	0	0
83	OUT_SYSTEM_TABLE	☐			STRG	0	0
84	OUT_INSERT_ONLY	☐			STRG	0	0
85	OUT_TENANT_SHARED_DATA	☐			STRG	0	0
86	OUT_TENANT_SHARED_METADATA	☐			STRG	0	0
87	OUT_SESSION_TYPE	☐			STRG	0	0
88	OUT_TEMPORARY	☐			STRG	0	0
89	OUT_TEMPORARY_TABLE_TYPE	☐			STRG	0	0
90	OUT_USER_DEFINED_TYPE	☐			STRG	0	0
91	OUT_READ_ONLY	☐			STRG	0	0
92	OUT_UNICODE	☐			STRG	0	0
93	OUT_CHECK_OPTION	☐			STRG	0	0
94	OUT_COLUMN_ALIASES	☐			STRG	0	0
95	ROW_TABLE_SIZES	☐	HDB_M_RS_TABLES		STRU	0	0
96	SCHEMA_NAME	☐			STRG	0	0
97	TABLE_NAME	☐			STRG	0	0
98	RECORD_COUNT	☐			SSTR	40	0
99	ALLOCATED_FIXED_PART_SIZE	☐			SSTR	40	0
100	FIXED_PAGE_HEADER_SIZE	☐			SSTR	40	0
101	FIXED_PAGE_FRAGMENT_SIZE	☐			SSTR	40	0
102	USED_FIXED_PART_SIZE	☐			SSTR	40	0
103	FIXED_PART_FRAGMENT_SIZE	☐			SSTR	40	0
104	FIXED_PART_FREE_SIZE	☐			SSTR	40	0
105	ALLOCATED_VARIABLE_PART_SIZE	☐			SSTR	40	0
106	USED_VARIABLE_PART_SIZE	☐			SSTR	40	0
107	VARIABLE_PART_FRAGMENT_SIZE	☐			SSTR	40	0
108	COL_TABLE_SIZES	☐	HDB_M_CS_TABLES		STRU	0	0
109	HOST	☐	HDB_HOST	HDB_HOST	CHAR	64	0	Name of database host
110	PORT	☐			NUMC	10	0
111	SCHEMA_NAME	☐			STRG	0	0
112	TABLE_NAME	☐			STRG	0	0
113	PARTITION	☐			SSTR	10	0
114	SUBPARTITION	☐			SSTR	10	0
115	PART_ID	☐			SSTR	10	0
116	RANGE	☐			CHAR	64	0
117	MEMORY_SIZE_IN_TOTAL	☐			SSTR	40	0
118	MEMORY_SIZE_IN_MAIN	☐			SSTR	40	0
119	MEMORY_SIZE_IN_DELTA	☐			SSTR	40	0
120	RECORD_COUNT	☐			SSTR	40	0
121	RAW_RECORD_COUNT_IN_MAIN	☐			SSTR	40	0
122	RAW_RECORD_COUNT_IN_DELTA	☐			SSTR	40	0
123	LAST_COMPRESSED_RECORD_COUNT	☐			SSTR	40	0
124	MAX_UDIV	☐			SSTR	40	0
125	MAX_MERGE_CID	☐			SSTR	40	0
126	IS_DELTA2_ACTIVE	☐			SSTR	40	0
127	IS_DELTA_LOADED	☐			SSTR	40	0
128	IS_LOG_DELTA	☐			SSTR	40	0
129	CREATED_TIME	☐	HDB_TSTMP	HDB_TSTMP	CHAR	19	0	Time stamp (stored in format YYYY-MM-DD HH:MM:SS)
130	MODIFIED_TIME	☐	HDB_TSTMP	HDB_TSTMP	CHAR	19	0	Time stamp (stored in format YYYY-MM-DD HH:MM:SS)
131	LAST_MERGE_TIME	☐	HDB_TSTMP	HDB_TSTMP	CHAR	19	0	Time stamp (stored in format YYYY-MM-DD HH:MM:SS)
132	LAST_REPLAY_LOG_TIME	☐	HDB_TSTMP	HDB_TSTMP	CHAR	19	0	Time stamp (stored in format YYYY-MM-DD HH:MM:SS)
133	EST_MAX_MEMORY_SIZE_IN_TOTAL	☐			SSTR	40	0
134	LOADED	☐			SSTR	20	0
135	MEMORY_SIZE_IN_HISTORY_MAIN	☐			SSTR	40	0
136	MEMORY_SIZE_IN_HISTORY_DELTA	☐			SSTR	40	0
137	DISK_SIZES	☐	HDB_M_PERSISTENCE_STATISTICS		STRU	0	0
138	SCHEMA_NAME	☐			STRG	0	0
139	TABLE_NAME	☐			STRG	0	0
140	DISK_SIZE	☐			SSTR	40	0
141	LABEL_SIZE	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
142	SIZE	☐	DEC20_2	DEC20_2	DEC	20	2	Dec20 with 2 decimal places
143	LABEL_SIZE_USED	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
144	SIZE_USED	☐	DEC20_2	DEC20_2	DEC	20	2	Dec20 with 2 decimal places
145	LABEL_COUNT	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
146	COUNT	☐			STRG	0	0
147	LABEL_CREATED_TIME	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
148	LABEL_MODIFIED_TIME	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
149	LABEL_LAST_MERGE_TIME	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
150	LABEL_LAST_REPLAY_LOG_TIME	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
151	INDEX_SIZE	☐	DEC20_2	DEC20_2	DEC	20	2	Dec20 with 2 decimal places
152	LABEL_INDEX_SIZE	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
153	ALV	☐	CL_DB6_ALV		REF	0	0
154	LABEL_ESTIMATED_SIZE	☐			CHAR	60	0
155	ESTIMATED_SIZE	☐	DEC20_2	DEC20_2	DEC	20	2	Dec20 with 2 decimal places
156	LABEL_MAIN_SIZE	☐			CHAR	60	0
157	MAIN_SIZE	☐	DEC20_2	DEC20_2	DEC	20	2	Dec20 with 2 decimal places
158	LABEL_DELTA_SIZE	☐			CHAR	60	0
159	DELTA_SIZE	☐	DEC20_2	DEC20_2	DEC	20	2	Dec20 with 2 decimal places
160	LABEL_DISK_SIZE	☐			CHAR	60	0
161	DISK_SIZE	☐	DEC20_2	DEC20_2	DEC	20	2	Dec20 with 2 decimal places
162	LABEL_PARTITION_SPEC	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
163	PARTITION_SPEC	☐			STRG	0	0
164	ITAB_PARTITIONS	☐	HDB_M_CS_TABLES_TAB		TTYP	0	0

History

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