SAP ODBSTATITM table - Statistical data for individual SAP Tables (f. Rel. < 3.0) details in SAP


SAP ODBSTATITM table summary

Object Name: ODBSTATITM
Dictionary Type: Structure
Description: Statistical data for individual SAP Tables (f. Rel. < 3.0)


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

Details
ODBSTATITM-TNAME table field - Table Name

Description: Table Name
Field Name: TNAME
Data Element: TABNAME
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: AS4TAB
MemoryID: DTB
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TNAME

ODBSTATITM-REF table field - Table type (short text)

Description: Table type (short text)
Field Name: REF
Data Element: TABTYPES
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: TABTYPESD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REF

ODBSTATITM-RNAME table field - Name of Pool/Cluster in the Database

Description: Name of Pool/Cluster in the Database
Field Name: RNAME
Data Element: SQLTABLE
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: SQLTABLE
MemoryID: STB
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RNAME

ODBSTATITM-BUF table field - Buffer mode of an SAP table

Description: Buffer mode of an SAP table
Field Name: BUF
Data Element: BUFMODE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BUFMODED
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUF

ODBSTATITM-SQL table field - Flag: Table processed via EXEC SQL?

Description: Flag: Table processed via EXEC SQL?
Field Name: SQL
Data Element: SQLACCESSD
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AS4FLAG
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL

ODBSTATITM-FILL1 table field - Single-Character Flag

Description: Single-Character Flag
Field Name: FILL1
Data Element: CHAR1
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILL1

ODBSTATITM-UPDCNT table field - No. of UPDATE attempts

Description: No. of UPDATE attempts
Field Name: UPDCNT
Data Element: UPDCNT
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 UPDCNT

ODBSTATITM-UPDFAIL table field - No. of failed update attempts

Description: No. of failed update attempts
Field Name: UPDFAIL
Data Element: UPDFAIL
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 UPDFAIL

ODBSTATITM-DELCNT table field - No. of DELETE attempts

Description: No. of DELETE attempts
Field Name: DELCNT
Data Element: DELCNT
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 DELCNT

ODBSTATITM-DELFAIL table field - No. of failed DELETE attempts

Description: No. of failed DELETE attempts
Field Name: DELFAIL
Data Element: DELFAIL
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 DELFAIL

ODBSTATITM-INSCNT table field - No. of INSERT attempts

Description: No. of INSERT attempts
Field Name: INSCNT
Data Element: INSCNT
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 INSCNT

ODBSTATITM-INSFAIL table field - No. of failed INSERT attempts

Description: No. of failed INSERT attempts
Field Name: INSFAIL
Data Element: INSFAIL
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 INSFAIL

ODBSTATITM-DIRCNT table field - Number of DIRECT READs

Description: Number of DIRECT READs
Field Name: DIRCNT
Data Element: DIRCNT
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 DIRCNT

ODBSTATITM-DIRFAIL table field - Number of Failed DIRECT READs

Description: Number of Failed DIRECT READs
Field Name: DIRFAIL
Data Element: DIRFAIL
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 DIRFAIL

ODBSTATITM-SEQCNT table field - No. of SEQUENTIAL READs

Description: No. of SEQUENTIAL READs
Field Name: SEQCNT
Data Element: SEQCNT
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 SEQCNT

ODBSTATITM-UPD_PREP table field - No. of SQL PREPAREs

Description: No. of SQL PREPAREs
Field Name: UPD_PREP
Data Element: PREPCNT
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 UPD_PREP

ODBSTATITM-UPD_EXEC table field - No of SQL EXECUTEs

Description: No of SQL EXECUTEs
Field Name: UPD_EXEC
Data Element: EXECCNT
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 UPD_EXEC

ODBSTATITM-UPD_ROW table field - No. of tuples affected in a table

Description: No. of tuples affected in a table
Field Name: UPD_ROW
Data Element: ROWCNT
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 UPD_ROW

ODBSTATITM-UPD_DUR table field - Operation duration

Description: Operation duration
Field Name: UPD_DUR
Data Element: OP_DUR
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 UPD_DUR

ODBSTATITM-DEL_PREP table field - No. of SQL PREPAREs

Description: No. of SQL PREPAREs
Field Name: DEL_PREP
Data Element: PREPCNT
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 DEL_PREP

ODBSTATITM-DEL_EXEC table field - No of SQL EXECUTEs

Description: No of SQL EXECUTEs
Field Name: DEL_EXEC
Data Element: EXECCNT
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 DEL_EXEC

ODBSTATITM-DEL_ROW table field - No. of tuples affected in a table

Description: No. of tuples affected in a table
Field Name: DEL_ROW
Data Element: ROWCNT
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 DEL_ROW

ODBSTATITM-DEL_DUR table field - Operation duration

Description: Operation duration
Field Name: DEL_DUR
Data Element: OP_DUR
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 DEL_DUR

ODBSTATITM-INS_PREP table field - No. of SQL PREPAREs

Description: No. of SQL PREPAREs
Field Name: INS_PREP
Data Element: PREPCNT
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 INS_PREP

ODBSTATITM-INS_EXEC table field - No of SQL EXECUTEs

Description: No of SQL EXECUTEs
Field Name: INS_EXEC
Data Element: EXECCNT
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 INS_EXEC

ODBSTATITM-INS_ROW table field - No. of tuples affected in a table

Description: No. of tuples affected in a table
Field Name: INS_ROW
Data Element: ROWCNT
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 INS_ROW

ODBSTATITM-INS_DUR table field - Operation duration

Description: Operation duration
Field Name: INS_DUR
Data Element: OP_DUR
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 INS_DUR

ODBSTATITM-DIR_PREP table field - No. of SQL PREPAREs

Description: No. of SQL PREPAREs
Field Name: DIR_PREP
Data Element: PREPCNT
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 DIR_PREP

ODBSTATITM-DIR_OPEN table field - No. of SQL OPENs

Description: No. of SQL OPENs
Field Name: DIR_OPEN
Data Element: OPENCNT
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 DIR_OPEN

ODBSTATITM-DIR_FETCH table field - No. of SQL FETCHes

Description: No. of SQL FETCHes
Field Name: DIR_FETCH
Data Element: FETCHCNT
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 DIR_FETCH

ODBSTATITM-DIR_DUR table field - Operation duration

Description: Operation duration
Field Name: DIR_DUR
Data Element: OP_DUR
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 DIR_DUR

ODBSTATITM-SEQ_PREP table field - No. of SQL PREPAREs

Description: No. of SQL PREPAREs
Field Name: SEQ_PREP
Data Element: PREPCNT
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 SEQ_PREP

ODBSTATITM-SEQ_OPEN table field - No. of SQL OPENs

Description: No. of SQL OPENs
Field Name: SEQ_OPEN
Data Element: OPENCNT
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 SEQ_OPEN

ODBSTATITM-SEQ_FETCH table field - No. of SQL FETCHes

Description: No. of SQL FETCHes
Field Name: SEQ_FETCH
Data Element: FETCHCNT
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 SEQ_FETCH

ODBSTATITM-SEQ_ROW table field - No. of tuples affected in a table

Description: No. of tuples affected in a table
Field Name: SEQ_ROW
Data Element: ROWCNT
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 SEQ_ROW

ODBSTATITM-SEQ_DUR table field - Operation duration

Description: Operation duration
Field Name: SEQ_DUR
Data Element: OP_DUR
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 SEQ_DUR

ODBSTATITM-UNUSED1 table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: UNUSED1
Data Element: INT4
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 UNUSED1

ODBSTATITM-UNUSED2 table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: UNUSED2
Data Element: INT4
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 UNUSED2

ODBSTATITM-UNUSED3 table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: UNUSED3
Data Element: INT4
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 UNUSED3

ODBSTATITM-UNUSED4 table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: UNUSED4
Data Element: INT4
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 UNUSED4

ODBSTATITM-FILL2 table field - Undefined range (can be used for patch levels)

Description: Undefined range (can be used for patch levels)
Field Name: FILL2
Data Element: CHAR4
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 FILL2

ODBSTATITM-LOAD_PREP table field - No. of SQL PREPAREs

Description: No. of SQL PREPAREs
Field Name: LOAD_PREP
Data Element: PREPCNT
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 LOAD_PREP

ODBSTATITM-LOAD_OPEN table field - No. of SQL OPENs

Description: No. of SQL OPENs
Field Name: LOAD_OPEN
Data Element: OPENCNT
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 LOAD_OPEN

ODBSTATITM-LOAD_FETCH table field - No. of SQL FETCHes

Description: No. of SQL FETCHes
Field Name: LOAD_FETCH
Data Element: FETCHCNT
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 LOAD_FETCH

ODBSTATITM-LOAD_ROW table field - No. of tuples affected in a table

Description: No. of tuples affected in a table
Field Name: LOAD_ROW
Data Element: ROWCNT
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 LOAD_ROW

ODBSTATITM-LOAD_DUR table field - Operation duration

Description: Operation duration
Field Name: LOAD_DUR
Data Element: OP_DUR
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 LOAD_DUR

ODBSTATITM-BUF_STATE table field - Status of the table in the table buffer

Description: Status of the table in the table buffer
Field Name: BUF_STATE
Data Element: PBUFSTATE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: PBUFSTATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUF_STATE

ODBSTATITM-FILL3 table field - 3-Byte field

Description: 3-Byte field
Field Name: FILL3
Data Element: CHAR3
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CHAR3
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILL3

ODBSTATITM-BUF_RESET table field - No. of buffer resets

Description: No. of buffer resets
Field Name: BUF_RESET
Data Element: PBUFRESET
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 BUF_RESET

ODBSTATITM-BUF_SIZE table field - Size of the buffer for an object

Description: Size of the buffer for an object
Field Name: BUF_SIZE
Data Element: PBUFSIZE
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 BUF_SIZE

ODBSTATITM-BUF_SIZEMX table field - Maximum buffer size for an object

Description: Maximum buffer size for an object
Field Name: BUF_SIZEMX
Data Element: PBUFSIZEMX
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 BUF_SIZEMX

ODBSTATITM-BUF_RECS table field - No. of buffered records for an object

Description: No. of buffered records for an object
Field Name: BUF_RECS
Data Element: PBUFRECS
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 BUF_RECS

ODBSTATITM-BUF_RECSMX table field - Maximum no. of buffered records for an object

Description: Maximum no. of buffered records for an object
Field Name: BUF_RECSMX
Data Element: PBUFRECSMX
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 BUF_RECSMX

ODBSTATITM-BUF_DIR table field - No. of direct hits in the buffer

Description: No. of direct hits in the buffer
Field Name: BUF_DIR
Data Element: PBUFDIR
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 BUF_DIR

ODBSTATITM-BUF_SEQ table field - No. of sequential buffer accesses

Description: No. of sequential buffer accesses
Field Name: BUF_SEQ
Data Element: PBUFSEQ
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 BUF_SEQ

ODBSTATITM-BUDIR table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: BUDIR
Data Element: INT4
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 BUDIR

ODBSTATITM-BUSEQ table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: BUSEQ
Data Element: INT4
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 BUSEQ


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table