SAP ABAP Table COLUMNS_ST (DB02: dba_tab_columns (Oracle))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ STUO (Package) ORACLE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	COLUMNS_ST	Table Relationship Diagram
Short Description	DB02: dba_tab_columns (Oracle)

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_N	☐	COLUMN_N	CHAR30	CHAR	30	0	Column name
2	DATA_TYPE	☐	DATA_TYPE	CHAR10	CHAR	10	0	datatype of the column
3	DATA_LENG	☐	DATA_LENG		INT4	10	0	length of the column in bytes
4	DATA_PREC	☐	DATA_PREC	CHAR10	CHAR	10	0	length: decimal digits (number) or binary
5	DATA_SCALE	☐	DATA_SCALE		INT4	10	0	decimal places
6	NULLABLE	☐	NULLABLE_C	CHAR4	CHAR	4	0	does column allow null values?
7	COLUMN_ID	☐	COLUMN_ID	DEC14	DEC	14	0	sequence number of the column as created
8	DEF_LENGTH	☐	DEF_LENGTH	DEC14	DEC	14	0	length of default value for the column
9	DATA_DEF	☐	DATA_DEF	CHAR14	CHAR	14	0	default value for the column
10	NUM_DISTIN	☐	NUM_DISTIN	DEC14	DEC	14	0	number of distinct values in the column
11	LOW_VALUE	☐	LOW_VALUE	CHAR14	CHAR	14	0	the low value in the column
12	HIGH_VALUE	☐	HIGH_VALUE	CHAR30	CHAR	30	0	the high value in the column
13	DENSITY	☐	DENSITY	DEC14	DEC	14	0	density of the column
14	NUM_NULLS	☐	NUM_NULLS	DEC14	DEC	14	0	number of nulls in the column
15	NUM_BUCKET	☐	NUM_BUCKET	DEC14	DEC	14	0	Number of buckets in histogram
16	LAST_ANAL	☐	LAST_ANAL	DATS	DATS	8	0	date of the most recent analysis
17	SAMP_SIZE	☐	SAMP_SIZE	DEC14	DEC	14	0	sample size used in analyzing this column

History

Last changed by/on	SAP	20130604
SAP Release Created in