SAP ABAP Table DB6CATTAB (DB6 complete SYSCAT.TABLES table structure)

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	DB6CATTAB	Table Relationship Diagram
Short Description	DB6 complete SYSCAT.TABLES table structure

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	TABSCHEMA	☐			CHAR	128	0
2	TABNAME	☐			CHAR	128	0
3	DEFINER	☐			CHAR	128	0
4	TYPE	☐			CHAR	1	0
5	STATUS	☐			CHAR	1	0
6	BASE_TABSCHEMA	☐			CHAR	128	0
7	BASE_TABNAME	☐			CHAR	128	0
8	ROWTYPESCHEMA	☐			CHAR	128	0
9	ROWTYPENAME	☐			CHAR	128	0
10	CREATE_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
11	STATS_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
12	COLCOUNT	☐			INT4	10	0
13	TABLEID	☐			INT4	10	0
14	TBSPACEID	☐			INT4	10	0
15	CARD	☐			DEC	22	0
16	NPAGES	☐			DEC	22	0
17	FPAGES	☐			DEC	22	0
18	OVERFLOW	☐			DEC	22	0
19	TBSPACE	☐			CHAR	128	0
20	INDEX_TBSPACE	☐			CHAR	128	0
21	LONG_TBSPACE	☐			CHAR	128	0
22	PARENTS	☐			INT4	10	0
23	CHILDREN	☐			INT4	10	0
24	SELFREFS	☐			INT4	10	0
25	KEYCOLUMNS	☐			INT4	10	0
26	KEYINDEXID	☐			INT4	10	0
27	KEYUNIQUE	☐			INT4	10	0
28	CHECKCOUNT	☐			INT4	10	0
29	DATACAPTURE	☐			CHAR	1	0
30	CONST_CHECKED	☐			CHAR	32	0
31	PMAP_ID	☐			INT4	10	0
32	PARTITION_MODE	☐			CHAR	1	0
33	LOG_ATTRIBUTE	☐			CHAR	1	0
34	PCTFREE	☐			INT4	10	0
35	APPEND_MODE	☐			CHAR	1	0
36	REFRESH	☐			CHAR	1	0
37	REFRESH_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
38	LOCKSIZE	☐			CHAR	1	0
39	VOLATILE	☐			CHAR	3	0
40	REMARKS	☐			STRG	0	0
41	ROW_FORMAT	☐			CHAR	1	0
42	PROPERTY	☐			CHAR	32	0
43	STATISTICS_PROFILE	☐			STRG	0	0
44	COMPRESSION	☐			CHAR	13	0
45	ACCESS_MODE	☐			CHAR	1	0
46	CLUSTERED	☐			CHAR	30	0
47	ACTIVE_BLOCKS	☐			DEC	22	0
48	DROPRULE	☐			CHAR	1	0
49	MAXFREESPACESEARCH	☐			INT4	10	0
50	AVGCOMPRESSEDROWSIZE	☐			INT2	5	0
51	AVGROWCOMPRESSIONRATIO	☐			DEC	5	2
52	AVGROWSIZE	☐			INT2	5	0
53	PCTROWSCOMPRESSED	☐			DEC	5	0
54	PCTPAGESSAVED	☐			INT4	10	0
55	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
56	ROWCOMPMODE	☐			STRG	0	0
57	TABLEORG	☐			STRG	0	0

History

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