SAP /SDF/MSSDBSTATS table - SQL Server: Statistics on database tables ( MSDDBSTATS ) details in SAP


SAP /SDF/MSSDBSTATS table summary

Object Name: /SDF/MSSDBSTATS
Dictionary Type: Structure
Description: SQL Server: Statistics on database tables ( MSDDBSTATS )


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

Details
/SDF/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-INDEXDEPTH table field - Index Depth

Description: Index 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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-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/MSSDBSTATS-AVGPGPEREX table field - Average pages per extent

Description: Average pages per extent
Field Name: AVGPGPEREX
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 AVGPGPEREX

/SDF/MSSDBSTATS-EXTSCANFRG table field - Extent scan fragmentation

Description: Extent scan fragmentation
Field Name: EXTSCANFRG
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 EXTSCANFRG

/SDF/MSSDBSTATS-AVGPGDSTF table field - Average page density

Description: Average page density
Field Name: AVGPGDSTF
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 AVGPGDSTF

/SDF/MSSDBSTATS-MISC table field - Miscellanious

Description: Miscellanious
Field Name: MISC
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 MISC


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table