SAP ALSTATITEM table - Statistical Data About Individual SAP Tables + Host + RC details in SAP

SAP ALSTATITEM table summary

Object Name: ALSTATITEM
Dictionary Type: Structure
Description: Statistical Data About Individual SAP Tables + Host + RC

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

Details

ALSTATITEM-NAME table field - Application Server Instance ▼

Description: Application Server Instance
Field Name: NAME
Data Element: MSNAME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSNAME
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

ALSTATITEM-RC table field - Return Code ▼

Description: Return Code
Field Name: RC
Data Element: SYSUBRC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SYST_SHORT
MemoryID:
AppClass: SAB4
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

View list of all SAP tables(S4H/ECC)

Select data from SAP table