SAP Table MSSFILES
MS SQL Server: Database File List
MSSFILES (MS SQL Server: Database File List) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MSSFILES to other SAP tables.
Source: MSSFILES (MS SQL Server: Database File List)
MSSFILES table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| FILEGRPNA | Filegroup name | MSSFG | CHAR | 128 | 0 | |||
| LOGFILENA | Logical file name | MSSFILE | CHAR | 128 | 0 | |||
| PHYFILENA | Physical file name (full path) of the database file. | MSQPHYFLNA | CHAR | 520 | 0 | |||
| FILEID | FILE ID of DB file for SQL Server | MSSFILEID | INT2 | 5 | 0 | |||
| FLSIZEMB | File size in MB. | MSQFLTSIZE | DEC | 15 | 0 | |||
| ALLOCMB | Allocated space in a DB file in MB | MSSALLOCFILEMB | DEC | 15 | 0 | |||
| FREEPCT | Free percentage of space in a SQL Server file | MSSFREEPCT | DEC | 6 | 2 | |||
| GROWTH | File growth step configured in SQL Server. | MSSDBGROW | CHAR | 10 | 0 | |||
| GROWTHMB | True file growth in MB | MSQFLTGROW | DEC | 16 | 0 | |||
| FLMAXSIZE | File size limit in MB configured in SQL Server. | MSSMAXSIZE | CHAR | 10 | 0 | |||
| PRIMARYFILE | Primary file containing startup information and also data | MSQFLPRIM | CHAR | 1 | 0 | |||
| READONLY | The file group is read only | MSQFLGRPRO | CHAR | 1 | 0 | |||
| LOGDEV | file is a log file | MSQFLLGDEV | CHAR | 1 | 0 | |||
| GRWTHPCT | SQL Server file has growth represented in percentage | MSQFLGRPCT | CHAR | 1 | 0 | |||
| DEVFREEMB | Free space left on file system (partition) in MB. | MSQDEVFREE | DEC | 15 | 0 | |||
| ALERTSTATUS | ALERT Status , 'R','Y','G' - red,yellow,green | MSSALERTSTATUS | CHAR | 1 | 0 | |||
| FILEMSG | MSS Alert Text as seen in RZ20 | MSSALERTTXT | CHAR | 50 | 0 | |||
