SAP ABAP Table DB6CATCOL (DB6: SYSCAT.COLUMNS)

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	DB6CATCOL	Table Relationship Diagram
Short Description	DB6: SYSCAT.COLUMNS

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	☐			STRG	0	0
2	TABNAME	☐			STRG	0	0
3	COLNAME	☐			STRG	0	0
4	COLNO	☐			INT4	10	0
5	TYPESCHEMA	☐			STRG	0	0
6	TYPENAME	☐			STRG	0	0
7	LENGTH	☐			INT4	10	0
8	SCALE	☐			INT4	10	0
9	DEFAULT	☐			STRG	0	0
10	NULLS	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
11	CODEPAGE	☐			INT4	10	0
12	LOGGED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
13	COMPACT	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
14	COLCARD	☐			DEC	22	0
15	HIGH2KEY	☐			STRG	0	0
16	LOW2KEY	☐			STRG	0	0
17	AVGCOLLEN	☐			INT4	10	0
18	KEYSEQ	☐			INT4	10	0
19	PARTKEYSEQ	☐			INT4	10	0
20	NQUANTILES	☐			INT4	10	0
21	NMOSTFREQ	☐			INT4	10	0
22	NUMNULLS	☐			DEC	22	0
23	INLINE_LENGTH	☐			INT4	10	0
24	HIDDEN	☐			STRG	0	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	730