SAP MSSDBSTATT table - Table statistics for MS SQL Server details in SAP

SAP MSSDBSTATT table summary

Object Name: MSSDBSTATT
Dictionary Type: Transparent table
Description: Table statistics for MS SQL Server

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

Details

MSSDBSTATT-TABLENAME table field - Table name ▼

Description: Table name
Field Name: TABLENAME
Data Element: MSSTABLE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLENAME

MSSDBSTATT-TOTALROWS table field - Number of rows ▼

Description: Number of rows
Field Name: TOTALROWS
Data Element: MSSNUMROWS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTALROWS

MSSDBSTATT-DATASIZE table field - Data size in KB ▼

Description: Data size in KB
Field Name: DATASIZE
Data Element: MSSDATASIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATASIZE

MSSDBSTATT-RESERVED table field - Reserved size in KB ▼

Description: Reserved size in KB
Field Name: RESERVED
Data Element: MSSRESSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESERVED

MSSDBSTATT-INDEXSIZE table field - Index size in KB ▼

Description: Index size in KB
Field Name: INDEXSIZE
Data Element: MSSINDEXSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXSIZE

MSSDBSTATT-ROWMODCTR table field - Row modification counter ▼

Description: Row modification counter
Field Name: ROWMODCTR
Data Element: MSSROWMODCTR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWMODCTR

MSSDBSTATT-STATSSCHVER table field - Statistics schema version ▼

Description: Statistics schema version
Field Name: STATSSCHVER
Data Element: MSSSTATSSCHVER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATSSCHVER

MSSDBSTATT-INDEXDEPTH table field - Depth ▼

Description: Depth
Field Name: INDEXDEPTH
Data Element: MSSINDDEPTH
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXDEPTH

MSSDBSTATT-NUMINDEXES table field - Number of indexes of a table ▼

Description: Number of indexes of a table
Field Name: NUMINDEXES
Data Element: MSSNUMINDS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMINDEXES

MSSDBSTATT-NUMSTATS table field - Number of statistics of a table ▼

Description: Number of statistics of a table
Field Name: NUMSTATS
Data Element: MSSNUMSTATS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMSTATS

MSSDBSTATT-STATSDATE table field - Last update statistics ▼

Description: Last update statistics
Field Name: STATSDATE
Data Element: MSSSTATSDATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATSDATE

MSSDBSTATT-TABLEOPTIONS table field - Table options on locking and memory ▼

Description: Table options on locking and memory
Field Name: TABLEOPTIONS
Data Element: MSSTABOPTS
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLEOPTIONS

MSSDBSTATT-BUFFSTATUS table field - SAP table buffering status on application server. ▼

Description: SAP table buffering status on application server.
Field Name: BUFFSTATUS
Data Element: MSSTABBUFF
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 BUFFSTATUS

MSSDBSTATT-FILEGROUP table field - Filegroup name ▼

Description: Filegroup name
Field Name: FILEGROUP
Data Element: MSSFG
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILEGROUP

MSSDBSTATT-SCANDENSITY table field - Scan density ▼

Description: Scan density
Field Name: SCANDENSITY
Data Element: MSSSCANDENSITY
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCANDENSITY

MSSDBSTATT-LOGICALFRAG table field - Logical scan fragmentation ▼

Description: Logical scan fragmentation
Field Name: LOGICALFRAG
Data Element: MSSLOGSCANFRAG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGICALFRAG

MSSDBSTATT-NUMPAGES table field - Number of pages in index level ▼

Description: Number of pages in index level
Field Name: NUMPAGES
Data Element: MSSILPAGES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMPAGES

MSSDBSTATT-BESTCOUNT table field - Ideal number of extent changes ▼

Description: Ideal number of extent changes
Field Name: BESTCOUNT
Data Element: MSSBESTCOUNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BESTCOUNT

MSSDBSTATT-ACTUALCOUNT table field - Actual number of extent changes ▼

Description: Actual number of extent changes
Field Name: ACTUALCOUNT
Data Element: MSSACTCOUNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTUALCOUNT

MSSDBSTATT-EXTENTSWITCHES table field - Number of extent switches ▼

Description: Number of extent switches
Field Name: EXTENTSWITCHES
Data Element: MSSEXTSWITCHES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENTSWITCHES

MSSDBSTATT-LASTTABLE table field - ▼

Description:
Field Name: LASTTABLE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTTABLE

MSSDBSTATT-LASTRUN table field - ▼

Description:
Field Name: LASTRUN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTRUN

MSSDBSTATT-LASTDURATION table field - Execution duration of an operation in seconds. ▼

Description: Execution duration of an operation in seconds.
Field Name: LASTDURATION
Data Element: MSSDURATE
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 LASTDURATION

View list of all SAP tables(S4H/ECC)

Select data from SAP table