SAP /SDF/ORATABCOL2 table - Information about table columns details in SAP


SAP /SDF/ORATABCOL2 table summary

Object Name: /SDF/ORATABCOL2
Dictionary Type: Structure
Description: Information about table columns


Field list for /SDF/ORATABCOL2 table on an S/4 SAP system

Details
/SDF/ORATABCOL2-ANALY_ID table field - Analysis ID

Description: Analysis ID
Field Name: ANALY_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANALY_ID

/SDF/ORATABCOL2-STMT_ID table field - Statement ID

Description: Statement ID
Field Name: STMT_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_ID

/SDF/ORATABCOL2-TAB_NAME table field - Table Name

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

See all SAP tables containing field TAB_NAME

/SDF/ORATABCOL2-COLUMN_N table field - Column name

Description: Column name
Field Name: COLUMN_N
Data Element:
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

/SDF/ORATABCOL2-DATA_TYPE table field - datatype of the column

Description: datatype of the column
Field Name: DATA_TYPE
Data Element:
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

/SDF/ORATABCOL2-DATA_LENG table field - length of the column in bytes

Description: length of the column in bytes
Field Name: DATA_LENG
Data Element:
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

/SDF/ORATABCOL2-DATA_PREC table field - length: decimal digits (number

Description: length: decimal digits (number
Field Name: DATA_PREC
Data Element:
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

/SDF/ORATABCOL2-DATA_SCALE table field - digits to right of decimal poi

Description: digits to right of decimal poi
Field Name: DATA_SCALE
Data Element:
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

/SDF/ORATABCOL2-NULLABLE table field - does column allow null values?

Description: does column allow null values?
Field Name: NULLABLE
Data Element:
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

/SDF/ORATABCOL2-COLUMN_ID table field - sequence number of the column

Description: sequence number of the column
Field Name: COLUMN_ID
Data Element:
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

/SDF/ORATABCOL2-DEF_LENGTH table field - length of default value for th

Description: length of default value for th
Field Name: DEF_LENGTH
Data Element:
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

/SDF/ORATABCOL2-DATA_DEF table field - default value for the column

Description: default value for the column
Field Name: DATA_DEF
Data Element:
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

/SDF/ORATABCOL2-NUM_DISTIN table field - number of distinct values in t

Description: number of distinct values in t
Field Name: NUM_DISTIN
Data Element:
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

/SDF/ORATABCOL2-LOW_VALUE table field - the low value in the column

Description: the low value in the column
Field Name: LOW_VALUE
Data Element:
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

/SDF/ORATABCOL2-HIGH_VALUE table field - the high value in the column

Description: the high value in the column
Field Name: HIGH_VALUE
Data Element:
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

/SDF/ORATABCOL2-DENSITY table field - density of the column

Description: density of the column
Field Name: DENSITY
Data Element:
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

/SDF/ORATABCOL2-NUM_NULLS table field - number of nulls in the column

Description: number of nulls in the column
Field Name: NUM_NULLS
Data Element:
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

/SDF/ORATABCOL2-NUM_BUCKET table field - Number of Buckets in Histogram

Description: Number of Buckets in Histogram
Field Name: NUM_BUCKET
Data Element:
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

/SDF/ORATABCOL2-LAST_ANAL table field - date of the most recent analysis

Description: date of the most recent analysis
Field Name: LAST_ANAL
Data Element:
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

/SDF/ORATABCOL2-SAMP_SIZE table field - sample size used in analyzing

Description: sample size used in analyzing
Field Name: SAMP_SIZE
Data Element:
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

/SDF/ORATABCOL2-HISTOGRAM table field - Indicates exist./type of histogram: none, freq, height bal.

Description: Indicates exist./type of histogram: none, freq, height bal.
Field Name: HISTOGRAM
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HISTOGRAM

/SDF/ORATABCOL2-GLOBAL_STATS table field - Estimated from underlying partitions (Y/N)

Description: Estimated from underlying partitions (Y/N)
Field Name: GLOBAL_STATS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GLOBAL_STATS

/SDF/ORATABCOL2-USER_STATS table field - Statistics were entered directly by the user (YES)

Description: Statistics were entered directly by the user (YES)
Field Name: USER_STATS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_STATS

/SDF/ORATABCOL2-AVG_COL_LEN table field - Average length of the column (in bytes)

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

See all SAP tables containing field AVG_COL_LEN

/SDF/ORATABCOL2-INST_ID table field - Instance ID

Description: Instance ID
Field Name: INST_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INST_ID

/SDF/ORATABCOL2-OBJ_NUM table field - Table object number

Description: Table object number
Field Name: OBJ_NUM
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJ_NUM

/SDF/ORATABCOL2-SEGMENT_COLUMN_ID table field - Segment column number

Description: Segment column number
Field Name: SEGMENT_COLUMN_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEGMENT_COLUMN_ID

/SDF/ORATABCOL2-INMEMORY_COMPRESSION table field - Column compression level

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

See all SAP tables containing field INMEMORY_COMPRESSION

/SDF/ORATABCOL2-CON_ID table field - The ID of the container to which the data pertains

Description: The ID of the container to which the data pertains
Field Name: CON_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CON_ID

/SDF/ORATABCOL2-STMT_SOURCE table field - DBA HIST (D) or Cache (C)

Description: DBA HIST (D) or Cache (C)
Field Name: STMT_SOURCE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_SOURCE

/SDF/ORATABCOL2-DBA_HIST_B_TS table field - Start timestamp for statement selection from DBA HIST

Description: Start timestamp for statement selection from DBA HIST
Field Name: DBA_HIST_B_TS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBA_HIST_B_TS

/SDF/ORATABCOL2-DBA_HIST_E_TS table field - End timestamp for statement selection from DBA HIST

Description: End timestamp for statement selection from DBA HIST
Field Name: DBA_HIST_E_TS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBA_HIST_E_TS


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table