SAP /SDF/MSSTABLESTATS table - SQL Server: Table size and usage (copy of MSDTBSTATS) details in SAP


SAP /SDF/MSSTABLESTATS table summary

Object Name: /SDF/MSSTABLESTATS
Dictionary Type: Structure
Description: SQL Server: Table size and usage (copy of MSDTBSTATS)


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

Details
/SDF/MSSTABLESTATS-ANLYID table field - SQL Server analysis ID for statement download

Description: SQL Server analysis ID for statement download
Field Name: ANLYID
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 ANLYID

/SDF/MSSTABLESTATS-TABNAME table field - SQL Server table or index name

Description: SQL Server table or index name
Field Name: TABNAME
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 TABNAME

/SDF/MSSTABLESTATS-RESERVED table field - SQL Server reserved size of table

Description: SQL Server reserved size of table
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/MSSTABLESTATS-DATASIZE table field - SQL Server total used size of table

Description: SQL Server total used size of table
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/MSSTABLESTATS-INDEXSIZE table field - SQL Server total size of all indexes

Description: SQL Server total size of all indexes
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/MSSTABLESTATS-UNUSEDSIZE table field - SQL Server total unused size

Description: SQL Server total unused size
Field Name: UNUSEDSIZE
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 UNUSEDSIZE

/SDF/MSSTABLESTATS-TOTALROWS table field - SQL Server number of rows in a table

Description: SQL Server number of rows in a table
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/MSSTABLESTATS-MINLEN table field - SQL Server minimum size of the row

Description: SQL Server minimum size of the row
Field Name: MINLEN
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 MINLEN

/SDF/MSSTABLESTATS-MAXLEN table field - SQL Server maximum size of a row

Description: SQL Server maximum size of a row
Field Name: MAXLEN
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 MAXLEN

/SDF/MSSTABLESTATS-ROWMODCTR table field - SQL Server modified rows in the table since upd stats

Description: SQL Server modified rows in the table since upd stats
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/MSSTABLESTATS-SCHEMAVER table field - SQL Server The count of changes in schema of a given object

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

/SDF/MSSTABLESTATS-SCANDENS table field - SQL Server statement download

Description: SQL Server statement download
Field Name: SCANDENS
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 SCANDENS

/SDF/MSSTABLESTATS-FILEGID table field - SQL Server file group ID

Description: SQL Server file group ID
Field Name: FILEGID
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 FILEGID

/SDF/MSSTABLESTATS-LASTCHUSER table field - SQL Server statement download user last table change

Description: SQL Server statement download user last table change
Field Name: LASTCHUSER
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 LASTCHUSER

/SDF/MSSTABLESTATS-LCHDATE table field - SQL Server analysis date

Description: SQL Server analysis date
Field Name: LCHDATE
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 LCHDATE

/SDF/MSSTABLESTATS-LCHTIME table field - SQL Server analysis time

Description: SQL Server analysis time
Field Name: LCHTIME
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 LCHTIME

/SDF/MSSTABLESTATS-BUFFERING table field - SQL Server statement download table buffering

Description: SQL Server statement download table buffering
Field Name: BUFFERING
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 BUFFERING

/SDF/MSSTABLESTATS-GENBUFFFLD table field - SQL Server statement download number of gen buffered fields

Description: SQL Server statement download number of gen buffered fields
Field Name: GENBUFFFLD
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 GENBUFFFLD

/SDF/MSSTABLESTATS-BUFSTATE table field - SQL Server statement download buffering on/off

Description: SQL Server statement download buffering on/off
Field Name: BUFSTATE
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 BUFSTATE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table