SAP ABAP Table SYB_SYSCOLUMNS (SYB: Column definition of a table / index)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYB_SYSCOLUMNS	Table Relationship Diagram
Short Description	SYB: Column definition of a table / index

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	COLUMN_NAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
2	POSITION	☐			INT4	10	0
3	DATA_TYPE	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
4	DATA_LENGTH	☐			INT4	10	0
5	DATA_PRECISION	☐			INT4	10	0
6	DATA_SCALE	☐			INT4	10	0
7	NULLABLE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
8	DDIC_TYPE	☐	DATATYPE_D	DATATYPE	CHAR	4	0	Data Type in ABAP Dictionary
9	DDIC_LENGTH	☐			INT4	10	0
10	DDIC_DECIMALS	☐			INT4	10	0
11	LOB_INLINE_LEN	☐			INT4	10	0
12	COMPRESSION	☐			CHAR	20	0
13	MATERIALIZED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
14	COMPUTED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
15	ENCRYPTED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False

History

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