SAP ABAP Table MSSTABSTATS (Structure for table history data from sap_tabstats)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSTABSTATS	Table Relationship Diagram
Short Description	Structure for table history data from sap_tabstats

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TABLENAME	☐	MSSTABLE	MSSSYSNAME	CHAR	128	0	Table name
2	SAMPLEDATE	☐	MSSSAMPLEDT	MSSDATE	DATS	8	0	Sample date for table history
3	SAMPLETIME	☐	MSSSAMPLETM	MSSTIME	TIMS	6	0	Sample time for table size history
4	TOTALROWS	☐	MSSNUMROWS		DEC	15	0	Number of rows
5	DATASIZE	☐	MSSDATASIZE		DEC	15	0	Data size in KB
6	RESERVED	☐	MSSRESSIZE		DEC	15	0	Reserved size in KB
7	INDEXSIZE	☐	MSSINDEXSIZE		DEC	15	0	Index size in KB
8	ROWMODCTR	☐	MSSROWMODCTR		INT4	10	0	Row modification counter
9	STATSSCHVER	☐	MSSSTATSSCHVER		INT4	10	0	Statistics schema version
10	INDEXDEPTH	☐	MSSINDDEPTH		INT4	10	0	Depth
11	NUMINDEXES	☐	MSSNUMINDS		INT4	10	0	Number of indexes of a table
12	NUMSTATS	☐	MSSNUMSTATS		INT4	10	0	Number of statistics of a table
13	STATSDATE	☐	MSSSTATSDATE		CHAR	20	0	Last update statistics
14	TABLEOPTIONS	☐	MSSTABOPTS	CHAR10	CHAR	10	0	Table options on locking and memory
15	LASTDURATION	☐	MSSSZCHKDURATE	INT4	INT4	10	0	Execution duration of table size checks

History

Last changed by/on	SAP	20130604
SAP Release Created in	710