SAP MSQTABSTAT table - MS SQL server table statistics details in SAP

SAP MSQTABSTAT table summary

Object Name: MSQTABSTAT
Dictionary Type: Structure
Description: MS SQL server table statistics

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

Details

MSQTABSTAT-RESERVED table field - MS SQL server - reserved size of the table ▼

Description: MS SQL server - reserved size of the table
Field Name: RESERVED
Data Element: MSQTABRES
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 RESERVED

MSQTABSTAT-DATASIZE table field - MS SQL server - Total used size of the table ▼

Description: MS SQL server - Total used size of the table
Field Name: DATASIZE
Data Element: MSQTABTOT
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 DATASIZE

MSQTABSTAT-INDEXSIZE table field - Size of all indexes in the database in KB. ▼

Description: Size of all indexes in the database in KB.
Field Name: INDEXSIZE
Data Element: MSQTOTINSZ
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

MSQTABSTAT-UNUSEDSIZE table field - MS SQL server - total unused space ▼

Description: MS SQL server - total unused space
Field Name: UNUSEDSIZE
Data Element: MSQTABUNUD
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 UNUSEDSIZE

MSQTABSTAT-TOTALROWS table field - MS SQL server - number of rows in a table ▼

Description: MS SQL server - number of rows in a table
Field Name: TOTALROWS
Data Element: MSQTABROWS
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

MSQTABSTAT-MINLEN table field - MS SQL server minimum size of the row. ▼

Description: MS SQL server minimum size of the row.
Field Name: MINLEN
Data Element: MSQMINLEN
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MINLEN

MSQTABSTAT-MAXLEN table field - MS SQL server - maximum size of a row ▼

Description: MS SQL server - maximum size of a row
Field Name: MAXLEN
Data Element: MSQMAXLEN
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXLEN

MSQTABSTAT-ROWMODCTR table field - MS SQL server - modified rows in the table since upd stats ▼

Description: MS SQL server - modified rows in the table since upd stats
Field Name: ROWMODCTR
Data Element: MSQMODROWS
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

MSQTABSTAT-SCHEMAVER table field - The count of changes in schema of a given object ▼

Description: The count of changes in schema of a given object
Field Name: SCHEMAVER
Data Element: MSQSCHEVER
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 SCHEMAVER

View list of all SAP tables(S4H/ECC)

Select data from SAP table