SAP COLUMNS_ST table - DB02: dba_tab_columns (Oracle) details in SAP


SAP COLUMNS_ST table summary

Object Name: COLUMNS_ST
Dictionary Type: Structure
Description: DB02: dba_tab_columns (Oracle)


Field list for COLUMNS_ST table on an S/4 SAP system

Details
COLUMNS_ST-COLUMN_N table field - Column name

Description: Column name
Field Name: COLUMN_N
Data Element: COLUMN_N
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLUMN_N

COLUMNS_ST-DATA_TYPE table field - datatype of the column

Description: datatype of the column
Field Name: DATA_TYPE
Data Element: DATA_TYPE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_TYPE

COLUMNS_ST-DATA_LENG table field - length of the column in bytes

Description: length of the column in bytes
Field Name: DATA_LENG
Data Element: DATA_LENG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_LENG

COLUMNS_ST-DATA_PREC table field - length: decimal digits (number) or binary

Description: length: decimal digits (number) or binary
Field Name: DATA_PREC
Data Element: DATA_PREC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_PREC

COLUMNS_ST-DATA_SCALE table field - decimal places

Description: decimal places
Field Name: DATA_SCALE
Data Element: DATA_SCALE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_SCALE

COLUMNS_ST-NULLABLE table field - does column allow null values?

Description: does column allow null values?
Field Name: NULLABLE
Data Element: NULLABLE_C
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NULLABLE

COLUMNS_ST-COLUMN_ID table field - sequence number of the column as created

Description: sequence number of the column as created
Field Name: COLUMN_ID
Data Element: COLUMN_ID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLUMN_ID

COLUMNS_ST-DEF_LENGTH table field - length of default value for the column

Description: length of default value for the column
Field Name: DEF_LENGTH
Data Element: DEF_LENGTH
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEF_LENGTH

COLUMNS_ST-DATA_DEF table field - default value for the column

Description: default value for the column
Field Name: DATA_DEF
Data Element: DATA_DEF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_DEF

COLUMNS_ST-NUM_DISTIN table field - number of distinct values in the column

Description: number of distinct values in the column
Field Name: NUM_DISTIN
Data Element: NUM_DISTIN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUM_DISTIN

COLUMNS_ST-LOW_VALUE table field - the low value in the column

Description: the low value in the column
Field Name: LOW_VALUE
Data Element: LOW_VALUE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOW_VALUE

COLUMNS_ST-HIGH_VALUE table field - the high value in the column

Description: the high value in the column
Field Name: HIGH_VALUE
Data Element: HIGH_VALUE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HIGH_VALUE

COLUMNS_ST-DENSITY table field - density of the column

Description: density of the column
Field Name: DENSITY
Data Element: DENSITY
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DENSITY

COLUMNS_ST-NUM_NULLS table field - number of nulls in the column

Description: number of nulls in the column
Field Name: NUM_NULLS
Data Element: NUM_NULLS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUM_NULLS

COLUMNS_ST-NUM_BUCKET table field - Number of buckets in histogram

Description: Number of buckets in histogram
Field Name: NUM_BUCKET
Data Element: NUM_BUCKET
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUM_BUCKET

COLUMNS_ST-LAST_ANAL table field - date of the most recent analysis

Description: date of the most recent analysis
Field Name: LAST_ANAL
Data Element: LAST_ANAL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_ANAL

COLUMNS_ST-SAMP_SIZE table field - sample size used in analyzing this column

Description: sample size used in analyzing this column
Field Name: SAMP_SIZE
Data Element: SAMP_SIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAMP_SIZE