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

  


SAP /SDF/MSSDBSTATS table summary

Warning: Undefined array key "id" in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 101

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


  

Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 234 Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 278 Warning: Undefined variable $obj1 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj2 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj3 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj4 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj5 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj6 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj7 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj8 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj9 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj10 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj11 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279


View list of all SAP tables(S4H/ECC)

Select data from SAP table