SAP ORABLKANAL table - Detailed Analysis of Oracle Tables details in SAP


SAP ORABLKANAL table summary

Object Name: ORABLKANAL
Dictionary Type: Structure
Description: Detailed Analysis of Oracle Tables


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

Details
ORABLKANAL-A_SIZE table field - Allocated diskspace for an Oracle table

Description: Allocated diskspace for an Oracle table
Field Name: A_SIZE
Data Element: OA_SIZE
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field A_SIZE

ORABLKANAL-A_BLOCKS table field - Allocated blocks for an Oracle table

Description: Allocated blocks for an Oracle table
Field Name: A_BLOCKS
Data Element: OA_BLOCKS
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field A_BLOCKS

ORABLKANAL-A_EXTENTS table field - Allocated extents for an Oracle table

Description: Allocated extents for an Oracle table
Field Name: A_EXTENTS
Data Element: OA_EXTENTS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field A_EXTENTS

ORABLKANAL-U_SIZE table field - Disk space used for Oracle table

Description: Disk space used for Oracle table
Field Name: U_SIZE
Data Element: OU_SIZE
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field U_SIZE

ORABLKANAL-U_BLOCKS table field - Used blocks of an Oracle table

Description: Used blocks of an Oracle table
Field Name: U_BLOCKS
Data Element: OU_BLOCKS
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field U_BLOCKS

ORABLKANAL-E_SIZE table field - Empty space allocated for an Oracle table

Description: Empty space allocated for an Oracle table
Field Name: E_SIZE
Data Element: OE_SIZE
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field E_SIZE

ORABLKANAL-E_BLOCKS table field - Empty blocks allocated for an Oracle table

Description: Empty blocks allocated for an Oracle table
Field Name: E_BLOCKS
Data Element: OE_BLOCKS
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field E_BLOCKS

ORABLKANAL-INIT_EXT table field - Size of initial table extent

Description: Size of initial table extent
Field Name: INIT_EXT
Data Element: OINIT_EXT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INIT_EXT

ORABLKANAL-NEXT_EXT table field - Size of next extent

Description: Size of next extent
Field Name: NEXT_EXT
Data Element: ONEXT_EXT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEXT_EXT

ORABLKANAL-MIN_EXTS table field - Oracle storage parameter 'minextents'

Description: Oracle storage parameter 'minextents'
Field Name: MIN_EXTS
Data Element: OMIN_EXTS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_EXTS

ORABLKANAL-MAX_EXTS table field - Oracle storage parameter 'maxextents'

Description: Oracle storage parameter 'maxextents'
Field Name: MAX_EXTS
Data Element: OMAX_EXTS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_EXTS

ORABLKANAL-PCTINCR table field - Storage parameter 'pctincrease'

Description: Storage parameter 'pctincrease'
Field Name: PCTINCR
Data Element: OPCTINCR
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCTINCR

ORABLKANAL-BLKSIZE table field - Oracle block size

Description: Oracle block size
Field Name: BLKSIZE
Data Element: OBLKSIZE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLKSIZE

ORABLKANAL-AVG_BFREE table field - Avg. freespace in a used data base block

Description: Avg. freespace in a used data base block
Field Name: AVG_BFREE
Data Element: OAVG_BFREE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_BFREE

ORABLKANAL-PCT_FREE table field - Oracle storage parameter 'PCTFREE'

Description: Oracle storage parameter 'PCTFREE'
Field Name: PCT_FREE
Data Element: OPCT_FREE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_FREE

ORABLKANAL-P_PCT_FREE table field - Recommended value for storage parameter 'PCTFREE'

Description: Recommended value for storage parameter 'PCTFREE'
Field Name: P_PCT_FREE
Data Element: OP_PCT_FRE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P_PCT_FREE

ORABLKANAL-PCT_USED table field - Storage parameter 'PCTUSED'

Description: Storage parameter 'PCTUSED'
Field Name: PCT_USED
Data Element: OPCT_USED
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_USED

ORABLKANAL-P_PCT_USED table field - Recommended value for storage parameter 'PCTUSED'

Description: Recommended value for storage parameter 'PCTUSED'
Field Name: P_PCT_USED
Data Element: OP_PCT_USE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P_PCT_USED

ORABLKANAL-INI_TRANS table field - Number of initial transactions (Oracle storage parameter)

Description: Number of initial transactions (Oracle storage parameter)
Field Name: INI_TRANS
Data Element: OINI_TRANS
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INI_TRANS

ORABLKANAL-MAX_TRANS table field - Maximum number of transactions (Oracle storage parameter)

Description: Maximum number of transactions (Oracle storage parameter)
Field Name: MAX_TRANS
Data Element: OMAX_TRANS
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_TRANS

ORABLKANAL-HEADER_MIN table field - Block header, minimum size

Description: Block header, minimum size
Field Name: HEADER_MIN
Data Element: OHEADER_MI
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HEADER_MIN

ORABLKANAL-HEADER_MAX table field - Block header, maximum size

Description: Block header, maximum size
Field Name: HEADER_MAX
Data Element: OHEADER_MA
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HEADER_MAX

ORABLKANAL-DATA_MIN table field - Minimum size of the data area in a block

Description: Minimum size of the data area in a block
Field Name: DATA_MIN
Data Element: ODATA_MIN
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_MIN

ORABLKANAL-DATA_MAX table field - Maximum size of the data area in a block

Description: Maximum size of the data area in a block
Field Name: DATA_MAX
Data Element: ODATA_MAX
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_MAX

ORABLKANAL-ROWS table field - Number of rows in a table

Description: Number of rows in a table
Field Name: ROWS
Data Element: OROWS
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWS

ORABLKANAL-CHAINED table field - Number of rows requiring block chaining

Description: Number of rows requiring block chaining
Field Name: CHAINED
Data Element: OCHAINED
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHAINED

ORABLKANAL-AVG_ROW_EH table field - Average row length without block header

Description: Average row length without block header
Field Name: AVG_ROW_EH
Data Element: OAVG_ROW_E
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_ROW_EH

ORABLKANAL-AVG_ROW_IH table field - Avg. row length including the block header

Description: Avg. row length including the block header
Field Name: AVG_ROW_IH
Data Element: OAVG_ROW_I
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_ROW_IH

ORABLKANAL-AVG_RO_IHR table field - Avg. row length to take into account for initial loading

Description: Avg. row length to take into account for initial loading
Field Name: AVG_RO_IHR
Data Element: OAVG_RO_IH
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_RO_IHR


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table