SAP ABAP Table DBSTATTMSS (Table sizes)

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	TRANSP	Transparent table
Transparent table	DBSTATTMSS	Table Relationship Diagram
Short Description	Table sizes

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	TABID	☑	MSSTABID	INT4	INT4	10	0	MS SQL Server table object id
2	TABNAME	☐	MSSOBJNAME	TEXT30	CHAR	30	0	MS SQL Server object name
3	LUPDSTAT	☐	AM_DATE	CHAR12	CHAR	12	0	Analysis date (yyyymmddhhmm)
4	UPDDURATE	☐	MSSDURATE	INT4	INT4	10	0	Execution duration of an operation in seconds.
5	LCHCKTABLE	☐	AM_DATE	CHAR12	CHAR	12	0	Analysis date (yyyymmddhhmm)
6	CHCKDURATE	☐	MSSDURATE	INT4	INT4	10	0	Execution duration of an operation in seconds.
7	CHECKTYPE	☐	MSSCHKTYPE	TEXT1	CHAR	1	0	MS SQL Server type of check action
8	NROWS	☐	OROWS	DEC15	DEC	15	0	Number of rows in a table
9	DPAGES	☐	MSSDPAGES	INT4	INT4	10	0	MS SQL Server number of data pages in table
10	RESERVED	☐	MSSTBRESVD	INT4	INT4	10	0	MS SQL Server reserved pages for table
11	USED	☐	MSSTBUSED	INT4	INT4	10	0	MS SQL Server number of used pages of a table
12	TOTIDXPG	☐	MSSTOTIDXP	INT4	INT4	10	0	MS SQL Server number of index pages for all idx of one table
13	RESIMTXTPG	☐	MSSRESIMTX	INT4	INT4	10	0	MS SQL Server number of reserved image + text pages of table
14	USDIMTXTPG	☐	MSSUSDIMTX	INT4	INT4	10	0	MS SQL Server number of used image or text pages for table

History

Last changed by/on	SAP	20130604
SAP Release Created in