SAP ABAP Table MSSFILES (MS SQL Server: Database File List)

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	MSSFILES	Table Relationship Diagram
Short Description	MS SQL Server: Database File List

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	FILEGRPNA	☐	MSSFG	MSSSYSNAME	CHAR	128	0	Filegroup name
2	LOGFILENA	☐	MSSFILE	MSSSYSNAME	CHAR	128	0	Logical file name
3	PHYFILENA	☐	MSQPHYFLNA	CHAR520	CHAR	520	0	Physical file name (full path) of the database file.
4	FILEID	☐	MSSFILEID		INT2	5	0	FILE ID of DB file for SQL Server
5	FLSIZEMB	☐	MSQFLTSIZE		DEC	15	0	File size in MB.
6	ALLOCMB	☐	MSSALLOCFILEMB		DEC	15	0	Allocated space in a DB file in MB
7	FREEPCT	☐	MSSFREEPCT		DEC	6	2	Free percentage of space in a SQL Server file
8	GROWTH	☐	MSSDBGROW	CHAR10	CHAR	10	0	File growth step configured in SQL Server.
9	GROWTHMB	☐	MSQFLTGROW		DEC	16	0	True file growth in MB
10	FLMAXSIZE	☐	MSSMAXSIZE	CHAR10	CHAR	10	0	File size limit in MB configured in SQL Server.
11	PRIMARYFILE	☐	MSQFLPRIM	CHAR1	CHAR	1	0	Primary file containing startup information and also data
12	READONLY	☐	MSQFLGRPRO	CHAR001	CHAR	1	0	The file group is read only
13	LOGDEV	☐	MSQFLLGDEV	CHAR001	CHAR	1	0	file is a log file
14	GRWTHPCT	☐	MSQFLGRPCT	CHAR1	CHAR	1	0	SQL Server file has growth represented in percentage
15	DEVFREEMB	☐	MSQDEVFREE		DEC	15	0	Free space left on file system (partition) in MB.
16	ALERTSTATUS	☐	MSSALERTSTATUS		CHAR	1	0	ALERT Status , 'R','Y','G' - red,yellow,green
17	FILEMSG	☐	MSSALERTTXT		CHAR	50	0	MSS Alert Text as seen in RZ20

History

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