SAP /SDF/MSSDBSTATT table - SQL Server: Details on a database table (copy of MSSDBSTATT) details in SAP


SAP /SDF/MSSDBSTATT table summary

Object Name: /SDF/MSSDBSTATT
Dictionary Type: Structure
Description: SQL Server: Details on a database table (copy of MSSDBSTATT)


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

Details
/SDF/MSSDBSTATT-TABLENAME table field - Table name

Description: Table name
Field Name: TABLENAME
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 TABLENAME

/SDF/MSSDBSTATT-TOTALROWS table field - Number of rows

Description: Number of rows
Field Name: TOTALROWS
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 TOTALROWS

/SDF/MSSDBSTATT-DATASIZE table field - Data size in KB

Description: Data size in KB
Field Name: DATASIZE
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 DATASIZE

/SDF/MSSDBSTATT-RESERVED table field - Reserved size in KB

Description: Reserved size in KB
Field Name: RESERVED
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 RESERVED

/SDF/MSSDBSTATT-INDEXSIZE table field - Index size in KB

Description: Index size in KB
Field Name: INDEXSIZE
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 INDEXSIZE

/SDF/MSSDBSTATT-ROWMODCTR table field - Row modification counter

Description: Row modification counter
Field Name: ROWMODCTR
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 ROWMODCTR

/SDF/MSSDBSTATT-STATSSCHVER table field - Statistics schema version

Description: Statistics schema version
Field Name: STATSSCHVER
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 STATSSCHVER

/SDF/MSSDBSTATT-INDEXDEPTH table field - Depth

Description: Depth
Field Name: INDEXDEPTH
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 INDEXDEPTH

/SDF/MSSDBSTATT-NUMINDEXES table field - Number of indexes of a table

Description: Number of indexes of a table
Field Name: NUMINDEXES
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 NUMINDEXES

/SDF/MSSDBSTATT-NUMSTATS table field - Number of statistics of a table

Description: Number of statistics of a table
Field Name: NUMSTATS
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 NUMSTATS

/SDF/MSSDBSTATT-STATSDATE table field - Last update statistics

Description: Last update statistics
Field Name: STATSDATE
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 STATSDATE

/SDF/MSSDBSTATT-TABLEOPTIONS table field - Table options on locking and memory

Description: Table options on locking and memory
Field Name: TABLEOPTIONS
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 TABLEOPTIONS

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

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

/SDF/MSSDBSTATT-FILEGROUP table field - Filegroup name

Description: Filegroup name
Field Name: FILEGROUP
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 FILEGROUP

/SDF/MSSDBSTATT-SCANDENSITY table field - SQL Server: Fragmentation rate (DEC 5,2)

Description: SQL Server: Fragmentation rate (DEC 5,2)
Field Name: SCANDENSITY
Data Element: /SDF/MSSRATE
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: /SDF/MSSRATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCANDENSITY

/SDF/MSSDBSTATT-LOGICALFRAG table field - SQL Server: Fragmentation rate (DEC 5,2)

Description: SQL Server: Fragmentation rate (DEC 5,2)
Field Name: LOGICALFRAG
Data Element: /SDF/MSSRATE
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: /SDF/MSSRATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGICALFRAG

/SDF/MSSDBSTATT-NUMPAGES table field - Number of pages in index level

Description: Number of pages in index level
Field Name: NUMPAGES
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 NUMPAGES

/SDF/MSSDBSTATT-BESTCOUNT table field - Ideal number of extent changes

Description: Ideal number of extent changes
Field Name: BESTCOUNT
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 BESTCOUNT

/SDF/MSSDBSTATT-ACTUALCOUNT table field - Actual number of extent changes

Description: Actual number of extent changes
Field Name: ACTUALCOUNT
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 ACTUALCOUNT

/SDF/MSSDBSTATT-EXTENTSWITCHES table field - Number of extent switches

Description: Number of extent switches
Field Name: EXTENTSWITCHES
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 EXTENTSWITCHES

/SDF/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

/SDF/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

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

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table