CTABSTAT_64 SAP (Statistical Data About an Individual SAP Table 64 Bit) Structure details

Dictionary Type: Structure
Description: Statistical Data About an Individual SAP Table 64 Bit




ABAP Code to SELECT data from CTABSTAT_64
Related tables to CTABSTAT_64
Access table CTABSTAT_64




Structure field list including key, data, relationships and ABAP select examples

CTABSTAT_64 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Statistical Data About an Individual SAP Table 64 Bit" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CTABSTAT_64 TYPE CTABSTAT_64.

The CTABSTAT_64 table consists of various fields, each holding specific information or linking keys about Statistical Data About an Individual SAP Table 64 Bit data available in SAP. These include UPDFAIL (Number of Failed UPDATE Attempts), DELCNT (Number of DELETE Attmempts), DELFAIL (Number of Failed DELETE Attempts), INSCNT (Number of INSERT attempts).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP CTABSTAT_64 structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
UPDCNTNumber of UPDATE Attempts UPD_CNT_64DEC20ABAP_MSIZE
UPDFAILNumber of Failed UPDATE Attempts UPD_FAIL_64DEC20ABAP_MSIZE
DELCNTNumber of DELETE Attmempts DEL_CNT_64DEC20ABAP_MSIZE
DELFAILNumber of Failed DELETE Attempts DEL_FAIL_64DEC20ABAP_MSIZE
INSCNTNumber of INSERT attempts INS_CNT_64DEC20ABAP_MSIZE
INSFAILNumber of Failed INSERT Attempts INS_FAIL_64DEC20ABAP_MSIZE
DIRCNTNumber of DIRECT READs DIR_CNT_64DEC20ABAP_MSIZE
DIRFAILNumber of Failed DIRECT READs DIR_FAIL_64DEC20ABAP_MSIZE
SEQCNTNumber of SEQUENTIAL READs SEQ_CNT_64DEC20ABAP_MSIZE
SEQFAILNumber of Unsuccessful SEQUENTIAL READs SEQ_FAIL_64DEC20ABAP_MSIZE
UPD_PREPNumber of SQL PREPAREs PREP_CNT_64DEC20ABAP_MSIZE
UPD_EXECNumber of SQL EXECUTEs EXEC_CNT_64DEC20ABAP_MSIZE
UPD_ROWNo. of Tuples Affected in a Table ROW_CNT_64DEC20ABAP_MSIZE
UPD_DUROperation Duration OP_DUR_64DEC20ABAP_MSIZE
DEL_PREPNumber of SQL PREPAREs PREP_CNT_64DEC20ABAP_MSIZE
DEL_EXECNumber of SQL EXECUTEs EXEC_CNT_64DEC20ABAP_MSIZE
DEL_ROWNo. of Tuples Affected in a Table ROW_CNT_64DEC20ABAP_MSIZE
DEL_DUROperation Duration OP_DUR_64DEC20ABAP_MSIZE
INS_PREPNumber of SQL PREPAREs PREP_CNT_64DEC20ABAP_MSIZE
INS_EXECNumber of SQL EXECUTEs EXEC_CNT_64DEC20ABAP_MSIZE
INS_ROWNo. of Tuples Affected in a Table ROW_CNT_64DEC20ABAP_MSIZE
INS_DUROperation Duration OP_DUR_64DEC20ABAP_MSIZE
DIR_PREPNumber of SQL PREPAREs PREP_CNT_64DEC20ABAP_MSIZE
DIR_OPENNumber of SQL OPENs OPEN_CNT_64DEC20ABAP_MSIZE
DIR_FETCHNumber of SQL FETCHes FETCH_CNT_64DEC20ABAP_MSIZE
DIR_DUROperation Duration OP_DUR_64DEC20ABAP_MSIZE
SEQ_PREPNumber of SQL PREPAREs PREP_CNT_64DEC20ABAP_MSIZE
SEQ_OPENNumber of SQL OPENs OPEN_CNT_64DEC20ABAP_MSIZE
SEQ_FETCHNumber of SQL FETCHes FETCH_CNT_64DEC20ABAP_MSIZE
SEQ_ROWNo. of Tuples Affected in a Table ROW_CNT_64DEC20ABAP_MSIZE
SEQ_DUROperation Duration OP_DUR_64DEC20ABAP_MSIZE
LOAD_PREPNumber of SQL PREPAREs PREP_CNT_64DEC20ABAP_MSIZE
LOAD_OPENNumber of SQL OPENs OPEN_CNT_64DEC20ABAP_MSIZE
LOAD_FETCHNumber of SQL FETCHes FETCH_CNT_64DEC20ABAP_MSIZE
LOAD_ROWNo. of Tuples Affected in a Table ROW_CNT_64DEC20ABAP_MSIZE
LOAD_DUROperation Duration OP_DUR_64DEC20ABAP_MSIZE
BUF_RESETNumber of Buffer Resets BUF_RESET_64DEC20ABAP_MSIZE
BUF_SIZESize of the Buffer for an Object BUF_SIZE_64DEC20ABAP_MSIZE
BUF_SIZEMXMaximum Buffer Size for an Object BUF_SIZEMX_64DEC20ABAP_MSIZE
BUF_RECSNumber of Buffered Records for an Object BUF_RECS_64DEC20ABAP_MSIZE
BUF_RECSMXMaximum Number of Buffered Records for an Object BUF_RECSMX_64DEC20ABAP_MSIZE
BUF_DIRNumber of Direct Hits in the Buffer BUF_DIR_64DEC20ABAP_MSIZE
BUF_SEQNumber of Sequential Buffer Accesses BUF_SEQ_64DEC20ABAP_MSIZE
REGIONS_NNumber of Generic Regions of a Buffered Table GENREGIONS_64DEC20ABAP_MSIZE
SEQ_SCANNumber of Records Read with Sequential Access SEQ_SCAN_64DEC20ABAP_MSIZE
BUF_STATEStatus of the table in the table buffer PBUFSTATECHAR1PBUFSTATE
TNAMETable name DBSTATTABNCHAR30Assigned to domainAS4TAB
REFTable type (short text) TABTYPESCHAR1TABTYPESD
RNAMEName of the pool or cluster DBSTATSQLTCHAR30Assigned to domainAS4TAB
BYPASSBUFTable read with BYPASSING BUFFER (checked tables only) BYPASSBUFCHAR1BYPASSBUF
SQLFlag: Table processed via EXEC SQL? SQLACCESSDCHAR1AS4FLAG

Key field Non-key field



How do I retrieve data from SAP structure CTABSTAT_64 using ABAP code?

As CTABSTAT_64 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CTABSTAT_64 as there is no data to select.

How to access SAP table CTABSTAT_64

Within an ECC or HANA version of SAP you can also view further information about CTABSTAT_64 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!