SAP CTABSTAT table - Statistical data on individual SAP tables (kernel) details in SAP

SAP CTABSTAT table summary

Object Name: CTABSTAT
Dictionary Type: Structure
Description: Statistical data on individual SAP tables (kernel)

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

Details

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-SEQFAIL table field - Number of unsuccessful SEQUENTIAL READs ▼

Description: Number of unsuccessful SEQUENTIAL READs
Field Name: SEQFAIL
Data Element: SEQ_FAIL
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 SEQFAIL

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-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

CTABSTAT-REGIONS_N table field - No. of generic regions of a buffered table ▼

Description: No. of generic regions of a buffered table
Field Name: REGIONS_N
Data Element: GENREGIONS
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 REGIONS_N

CTABSTAT-SEQ_SCAN table field - No. of records read with seq. acess ▼

Description: No. of records read with seq. acess
Field Name: SEQ_SCAN
Data Element: SEQ_SCAN
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_SCAN

CTABSTAT-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

CTABSTAT-TNAME table field - Table name ▼

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

See all SAP tables containing field TNAME

CTABSTAT-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

CTABSTAT-RNAME table field - Name of the pool or cluster ▼

Description: Name of the pool or cluster
Field Name: RNAME
Data Element: DBSTATSQLT
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: AS4TAB
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RNAME

CTABSTAT-BYPASSBUF table field - Table read with BYPASSING BUFFER (checked tables only) ▼

Description: Table read with BYPASSING BUFFER (checked tables only)
Field Name: BYPASSBUF
Data Element: BYPASSBUF
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BYPASSBUF
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BYPASSBUF

CTABSTAT-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

View list of all SAP tables(S4H/ECC)

Select data from SAP table