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: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
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: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
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: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
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: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CHAR4
MemoryID:
AppClass: TEST
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: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
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: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
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: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: CHAR14
MemoryID:
AppClass: SAP
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: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
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: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: CHAR14
MemoryID:
AppClass: SAP
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: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
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: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
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: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
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: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
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: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
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: DEC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: DEC14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAMP_SIZE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table