SAP ABAP Table DB6_VIEW_TABLE_DETAIL (DB6: View Data of Table Details)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6_VIEW_TABLE_DETAIL	Table Relationship Diagram
Short Description	DB6: View Data of Table Details

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	IT_IDX_REORGCHK	☐	DB6PMREORGCHK_IDX_TAB		TTYP	0	0
2	IT_IDX_INFO	☐	DB6ADM_INDEX_INFO_TAB		TTYP	0	0
3	IT_IDX_COMPRESS	☐	DB6ADM_INDCOMPR_INFO_TAB		TTYP	0	0
4	IT_IDX_COLUMNS	☐	DB6PMCIST_LIST		TTYP	0	0
5	IT_TAB_COLUMNS	☐	DB6PMCTST_LIST		TTYP	0	0
6	IT_TAB_INDEXES	☐	DB6CATIX_TAB		TTYP	0	0
7	IT_TAB_INFO	☐	DB6PMTAB_INFO_TAB		TTYP	0	0
8	IT_TAB_COMPRESS	☐	DB6PMINSPECT_TAB		TTYP	0	0
9	IT_TAB_REORGCHK	☐	DB6PMREORGCHK_TAB_TAB		TTYP	0	0
10	IT_TAB_DATAPARTITIONS	☐	DB6CATDATAPARTITIONS_TAB		TTYP	0	0
11	IT_TAB_COLDIST	☐	DB6XPLCOLDIST_TAB		TTYP	0	0
12	TAB_SYSCAT	☐	DB6CATTAB		STRU	0	0
13	TABSCHEMA	☐			CHAR	128	0
14	TABNAME	☐			CHAR	128	0
15	DEFINER	☐			CHAR	128	0
16	TYPE	☐			CHAR	1	0
17	STATUS	☐			CHAR	1	0
18	BASE_TABSCHEMA	☐			CHAR	128	0
19	BASE_TABNAME	☐			CHAR	128	0
20	ROWTYPESCHEMA	☐			CHAR	128	0
21	ROWTYPENAME	☐			CHAR	128	0
22	CREATE_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
23	STATS_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
24	COLCOUNT	☐			INT4	10	0
25	TABLEID	☐			INT4	10	0
26	TBSPACEID	☐			INT4	10	0
27	CARD	☐			DEC	22	0
28	NPAGES	☐			DEC	22	0
29	FPAGES	☐			DEC	22	0
30	OVERFLOW	☐			DEC	22	0
31	TBSPACE	☐			CHAR	128	0
32	INDEX_TBSPACE	☐			CHAR	128	0
33	LONG_TBSPACE	☐			CHAR	128	0
34	PARENTS	☐			INT4	10	0
35	CHILDREN	☐			INT4	10	0
36	SELFREFS	☐			INT4	10	0
37	KEYCOLUMNS	☐			INT4	10	0
38	KEYINDEXID	☐			INT4	10	0
39	KEYUNIQUE	☐			INT4	10	0
40	CHECKCOUNT	☐			INT4	10	0
41	DATACAPTURE	☐			CHAR	1	0
42	CONST_CHECKED	☐			CHAR	32	0
43	PMAP_ID	☐			INT4	10	0
44	PARTITION_MODE	☐			CHAR	1	0
45	LOG_ATTRIBUTE	☐			CHAR	1	0
46	PCTFREE	☐			INT4	10	0
47	APPEND_MODE	☐			CHAR	1	0
48	REFRESH	☐			CHAR	1	0
49	REFRESH_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
50	LOCKSIZE	☐			CHAR	1	0
51	VOLATILE	☐			CHAR	3	0
52	REMARKS	☐			STRG	0	0
53	ROW_FORMAT	☐			CHAR	1	0
54	PROPERTY	☐			CHAR	32	0
55	STATISTICS_PROFILE	☐			STRG	0	0
56	COMPRESSION	☐			CHAR	13	0
57	ACCESS_MODE	☐			CHAR	1	0
58	CLUSTERED	☐			CHAR	30	0
59	ACTIVE_BLOCKS	☐			DEC	22	0
60	DROPRULE	☐			CHAR	1	0
61	MAXFREESPACESEARCH	☐			INT4	10	0
62	AVGCOMPRESSEDROWSIZE	☐			INT2	5	0
63	AVGROWCOMPRESSIONRATIO	☐			DEC	5	2
64	AVGROWSIZE	☐			INT2	5	0
65	PCTROWSCOMPRESSED	☐			DEC	5	0
66	PCTPAGESSAVED	☐			INT4	10	0
67	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
68	ROWCOMPMODE	☐			STRG	0	0
69	TABLEORG	☐			STRG	0	0
70	TAB_REORGCHK	☐	DB6PMREORGCHK_TAB		STRU	0	0
71	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
72	TABSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
73	TABNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
74	DATAPARTITIONNAME	☐			STRG	0	0
75	CARD	☐			DEC	22	0
76	OVERFLOW	☐			DEC	22	0
77	NPAGES	☐			DEC	22	0
78	FPAGES	☐			DEC	22	0
79	ACTIVE_BLOCKS	☐			DEC	22	0
80	TSIZE	☐			DEC	22	0
81	F1	☐			INT4	10	0
82	F2	☐			INT4	10	0
83	F3	☐			INT4	10	0
84	REORG	☐			CHAR	3	0
85	F1_ICON	☐			STRG	0	0
86	F2_ICON	☐			STRG	0	0
87	F3_ICON	☐			STRG	0	0
88	TAB_INFO	☐	DB6PMTAB_INFO		STRU	0	0
89	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
90	TABSCHEMA	☐			STRG	0	0
91	TABNAME	☐			STRG	0	0
92	TABTYPE	☐			STRG	0	0
93	PARTITN	☐			INT4	10	0
94	DATA_PARTITION_ID	☐			INT4	10	0
95	AVAILABLE	☐			STRG	0	0
96	DATA_OBJECT_L_SIZE	☐			DEC	22	0
97	DATA_OBJECT_P_SIZE	☐			DEC	22	0
98	INDEX_OBJECT_L_SIZE	☐			DEC	22	0
99	INDEX_OBJECT_P_SIZE	☐			DEC	22	0
100	LONG_OBJECT_L_SIZE	☐			DEC	22	0
101	LONG_OBJECT_P_SIZE	☐			DEC	22	0
102	LOB_OBJECT_L_SIZE	☐			DEC	22	0
103	LOB_OBJECT_P_SIZE	☐			DEC	22	0
104	XML_OBJECT_L_SIZE	☐			DEC	22	0
105	XML_OBJECT_P_SIZE	☐			DEC	22	0
106	INDEX_TYPE	☐			STRG	0	0
107	REORG_PENDING	☐			STRG	0	0
108	INPLACE_REORG_STATUS	☐			STRG	0	0
109	LOAD_STATUS	☐			STRG	0	0
110	READ_ACCESS_ONLY	☐			STRG	0	0
111	NO_LOAD_RESTART	☐			STRG	0	0
112	NUM_REORG_REC_ALTERS	☐			INT4	10	0
113	INDEXES_REQUIRE_REBUILD	☐			STRG	0	0
114	LARGE_RIDS	☐			STRG	0	0
115	LARGE_SLOTS	☐			STRG	0	0
116	DICTIONARY_SIZE	☐			DEC	22	0
117	BLOCKS_PENDING_CLEANUP	☐			DEC	22	0
118	STATSTYPE	☐			STRG	0	0
119	XML_RECORD_TYPE	☐			STRG	0	0
120	RECLAIMABLE_SPACE	☐			DEC	22	0
121	XML_DICTIONARY_SIZE	☐			DEC	22	0
122	AMT_STATUS	☐			STRG	0	0
123	COL_OBJECT_L_SIZE	☐			DEC	22	0
124	COL_OBJECT_P_SIZE	☐			DEC	22	0
125	TAB_COMPRESSION	☐	DB6PMINSPECT		STRU	0	0
126	TABSCHEMA	☐			STRG	0	0
127	TABNAME	☐			STRG	0	0
128	PARTITN	☐			INT4	10	0
129	DATA_PARTITION_ID	☐			INT4	10	0
130	COMPRESS_ATTR	☐			STRG	0	0
131	DICT_BUILDER	☐			STRG	0	0
132	SAVED_PAGES_PCT	☐			INT4	10	0
133	SAVED_BYTES_PCT	☐			INT4	10	0
134	ROWS_TOO_SMALL_PCT	☐			INT4	10	0
135	COMPRESSION_DICT_SIZE	☐			DEC	22	0
136	EXPANSION_DICT_SIZE	☐			DEC	22	0
137	ROWS_SAMPLED	☐			DEC	22	0
138	AVG_COMPRESS_REC_LENGTH	☐			INT4	10	0
139	OBJECT_TYPE	☐			STRG	0	0
140	DICT_BUILD_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
141	CHECK_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
142	ROWCOMPMODE	☐			STRG	0	0
143	PCTPAGESSAVED_ADAPTIVE	☐			INT4	10	0
144	AVGROWSIZE_ADAPTIVE	☐			INT4	10	0
145	IDX_SYSCAT	☐	DB6CATIX		STRU	0	0
146	INDSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
147	INDNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
148	DEFINER	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
149	TABSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
150	TABNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
151	COLNAMES	☐			CHAR	640	0
152	UNIQUERULE	☐			CHAR	1	0
153	MADE_UNIQUE	☐			CHAR	1	0
154	COLCOUNT	☐			INT2	5	0
155	UNIQUE_COLCOUNT	☐			INT2	5	0
156	INDEXTYPE	☐			CHAR	4	0
157	ENTRYTYPE	☐			CHAR	1	0
158	PCTFREE	☐			INT2	5	0
159	IID	☐			INT2	5	0
160	NLEAF	☐			DEC	22	0
161	NLEVELS	☐			INT2	5	0
162	FIRSTKEYCARD	☐			DEC	22	0
163	FIRST2KEYCARD	☐			DEC	22	0
164	FIRST3KEYCARD	☐			DEC	22	0
165	FIRST4KEYCARD	☐			DEC	22	0
166	FULLKEYCARD	☐			DEC	22	0
167	CLUSTERRATIO	☐			INT2	5	0
168	CLUSTERFACTOR	☐			DEC	5	0
169	SEQUENTIAL_PAGES	☐			DEC	22	0
170	DENSITY	☐			INT4	10	0
171	USER_DEFINED	☐			INT2	5	0
172	SYSTEM_REQUIRED	☐			INT2	5	0
173	CREATE_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
174	STATS_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
175	MINPCTUSED	☐			INT2	5	0
176	REVERSE_SCANS	☐			CHAR	1	0
177	INTERNAL_FORMAT	☐			INT2	5	0
178	REMARKS	☐			CHAR	254	0
179	INDEX_OBJECTID	☐			INT4	10	0
180	NUMRIDS	☐			DEC	22	0
181	NUMRIDS_DELETED	☐			DEC	22	0
182	NUM_EMPTY_LEAFS	☐			DEC	22	0
183	AVERAGE_RANDOM_FETCH_PAGES	☐			DEC	22	0
184	AVERAGE_RANDOM_PAGES	☐			DEC	22	0
185	AVERAGE_SEQUENCE_GAP	☐			DEC	22	0
186	AVERAGE_SEQUENCE_FETCH_GAP	☐			DEC	22	0
187	AVERAGE_SEQUENCE_PAGES	☐			DEC	22	0
188	AVERAGE_SEQUENCE_FETCH_PAGES	☐			DEC	22	0
189	TBSPACEID	☐			INT4	10	0
190	PCTPAGESSAVED	☐			INT4	10	0
191	COMPRESSION	☐			CHAR	1	0
192	INDCARD	☐			DEC	22	0
193	AVGLEAFKEYSIZE	☐			INT4	10	0
194	AVGNLEAFKEYSIZE	☐			INT4	10	0
195	COLLECTSTATISTICS	☐			CHAR	1	0
196	LASTUSED	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
197	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
198	IDX_REORGCHK	☐	DB6PMREORGCHK_IDX		STRU	0	0
199	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
200	TABSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
201	TABNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
202	DATAPARTITIONNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
203	INDSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
204	INDNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
205	CARD	☐			DEC	22	0
206	NLEAF	☐			DEC	22	0
207	NUM_EMPTY_LEAFS	☐			DEC	22	0
208	NLEVELS	☐			DEC	22	0
209	ISIZE	☐			DEC	22	0
210	NUMRIDS_DELETED	☐			DEC	22	0
211	FULLKEYCARD	☐			DEC	22	0
212	LEAF_RECSIZE	☐			DEC	22	0
213	NONLEAF_RECSIZE	☐			DEC	22	0
214	LEAF_PAGE_OVERHEAD	☐			DEC	22	0
215	NONLEAF_PAGE_OVERHEAD	☐			DEC	22	0
216	PCT_PAGES_SAVED	☐			DEC	15	0
217	F4	☐			INT4	10	0
218	F5	☐			INT4	10	0
219	F6	☐			INT4	10	0
220	F7	☐			INT4	10	0
221	F8	☐			INT4	10	0
222	REORG	☐			CHAR	5	0
223	F4_ICON	☐			STRG	0	0
224	F5_ICON	☐			STRG	0	0
225	F6_ICON	☐			STRG	0	0
226	F7_ICON	☐			STRG	0	0
227	F8_ICON	☐			STRG	0	0
228	UNIQUERULE	☐			CHAR	1	0
229	IDX_INFO	☐	DB6ADM_INDEX_INFO		STRU	0	0
230	INDSCHEMA	☐			STRG	0	0
231	INDNAME	☐			STRG	0	0
232	TABSCHEMA	☐			STRG	0	0
233	TABNAME	☐			STRG	0	0
234	DBPARTITIONNUM	☐			INT4	10	0
235	DATAPARTITIONID	☐			INT4	10	0
236	COMPRESS_ATTR	☐			STRG	0	0
237	INDEX_COMPRESSED	☐			STRG	0	0
238	INDEX_PARTITIONING	☐			STRG	0	0
239	INDEX_OBJECT_L_SIZE	☐			DEC	22	0
240	INDEX_OBJECT_P_SIZE	☐			DEC	22	0
241	INDEX_REQUIRES_REBUILD	☐			STRG	0	0
242	LARGE_RIDS	☐			STRG	0	0
243	IID	☐			INT4	10	0
244	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
245	RECLAIMABLE_SPACE	☐			DEC	22	0
246	IDX_COMPRESSION	☐	DB6ADM_INDCOMPR_INFO		STRU	0	0
247	INDSCHEMA	☐			STRG	0	0
248	INDNAME	☐			STRG	0	0
249	TABSCHEMA	☐			STRG	0	0
250	TABNAME	☐			STRG	0	0
251	DBPARTITIONNUM	☐			INT4	10	0
252	DATAPARTITIONID	☐			INT4	10	0
253	COMPRESS_ATTR	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
254	INDEX_COMPRESSED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
255	PCT_PAGES_SAVED	☐			INT4	10	0
256	NUM_LEAF_PAGES_SAVED	☐			DEC	22	0
257	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
258	VALUE_COMPRESSION	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
259	ROW_COMPRESSION	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
260	HIDE_COUNT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
261	TRUE_CARDINALITY	☐			DEC	22	0
262	DELTA_CARDINALITY	☐			DEC	22	0
263	POOL_LIKE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
264	TAB_STATS_TIME	☐	DB6TSTAMP_STRUCT		STRU	0	0
265	DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
266	TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
267	TAB_REORGCHK_TIME	☐	DB6TSTAMP_STRUCT		STRU	0	0
268	DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
269	TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
270	REORG_TIME	☐	DB6TSTAMP_STRUCT		STRU	0	0
271	DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
272	TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
273	REORG_RUNTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
274	CB_DISTRIBUTION_STATISTICS	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
275	IDX_REORGCHK_TIME	☐	DB6TSTAMP_STRUCT		STRU	0	0
276	DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
277	TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
278	DICT_BUILD_TIME	☐	DB6TSTAMP_STRUCT		STRU	0	0
279	DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
280	TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
281	VOLATILE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
282	TAB_REORGCHK_RESULT	☐			STRG	0	0
283	IDX_REORGCHK_RESULT	☐			STRG	0	0
284	TOTAL	☐	DB6_TABLE_OVERVIEW		STRU	0	0
285	TABLE_SIZE	☐			DEC	22	0
286	INDEX_SIZE	☐			DEC	22	0
287	INDEXES	☐			INT4	10	0
288	COMPRESSION_STATUS	☐			STRG	0	0
289	REORG_RESULT	☐			STRG	0	0
290	SYSCAT_COMPRESSION_PCT	☐			DEC	5	0
291	SYSCAT_COMPRESSION_ABS	☐			DEC	22	0
292	TAB_COMPRESSION_PCT	☐			DEC	5	0
293	TAB_COMPRESSION_ABS	☐			DEC	22	0
294	DELTA_COMPRESSION_ABS	☐			DEC	22	0
295	RUNSTATS_STATUS	☐			STRG	0	0
296	AVGROWCOMPRESSIONPCT	☐			DEC	5	0
297	DDL_STATEMENT	☐			STRG	0	0
298	SAP_BUFFERED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

History

Last changed by/on	SAP	20140117
SAP Release Created in	711