Table/Structure Field list used by SAP ABAP Function Module GET_SQLFILES_MSS (get data on the files of a SQL Server database)
SAP ABAP Function Module 
GET_SQLFILES_MSS (get data on the files of a SQL Server database) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | |
| 2 | Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | SOURCE VALUE(CON_NAME) LIKE DBCON-CON_NAME DEFAULT 'DEFAULT' |
| 3 | Table/Structure Field |
MSQ_FILES - FLGRWPCT | SQL Server file has growth represented in percentage | |
| 4 | Table/Structure Field |
MSQ_FILES - PHYFILENA | Physical file name (full path) of the database file. | |
| 5 | Table/Structure Field |
MSQ_FILES - LOGFILENA | Logical file name | |
| 6 | Table/Structure Field |
MSQ_FILES - FLWRITEBU | file has been written to since the last backup was done | |
| 7 | Table/Structure Field |
MSQ_FILES - FLUSDEXTS | Total no. of used extents(8 contiguous pgs) assigned to file | |
| 8 | Table/Structure Field |
MSQ_FILES - FLSIZEMB | File size in MB. | |
| 9 | Table/Structure Field |
MSQ_FILES - FLMAXSZMB | True Max file size in MB(-1 means file grows till disk full) | |
| 10 | Table/Structure Field |
MSQ_FILES - FLLOGDEV | file is a log file | |
| 11 | Table/Structure Field |
MSQ_FILES - FLGROWTH | Growth size of the SQL Server database file | |
| 12 | Table/Structure Field |
MSQ_FILES - FLGROWMB | True file growth in MB | |
| 13 | Table/Structure Field |
MSQ_FILES - FLEXTENTS | Total number of extents assigned to a file | |
| 14 | Table/Structure Field |
MSQ_FILES - FLDISKFILE | file is a disk file | |
| 15 | Table/Structure Field |
MSQ_FILES - FLDBCREATE | file created during Database creation | |
| 16 | Table/Structure Field |
MSQ_FILES - FLCREATEDB | file was created with a CREATE DB command | |
| 17 | Table/Structure Field |
MSQ_FILES - FILEPRMRY | Primary file containing startup information and also data | |
| 18 | Table/Structure Field |
MSQ_FILES - FILEGRPNA | Filegroup name | |
| 19 | Table/Structure Field |
MSQ_FILES - FILEGRPDEF | Default file grp contains objects created w/o defined filegp | |
| 20 | Table/Structure Field |
MSQ_FILES - FGRPRDONLY | The file group is read only | |
| 21 | Table/Structure Field |
MSQ_FILES - DEVFREE | Free space left on file system (partition) in MB. | |
| 22 | Table/Structure Field |
MSSCONNDATA - ERRCODE | Return Code | |
| 23 | Table/Structure Field |
MSSCONNDATA - MSGV4 | Message Variable | |
| 24 | Table/Structure Field |
MSSCONNDATA - MSGV3 | Message Variable | |
| 25 | Table/Structure Field |
MSSCONNDATA - MSGV2 | Message Variable | |
| 26 | Table/Structure Field |
MSSCONNDATA - MSGV1 | Message Variable | |
| 27 | Table/Structure Field |
MSSCONNDATA - MSGNO | Message Number | |
| 28 | Table/Structure Field |
MSSCONNDATA - MSGID | Message Class | |
| 29 | Table/Structure Field |
MSSCONNDATA - DBSCHEMA | MSSQL Multiconnect : Object source schema | |
| 30 | Table/Structure Field |
MSSCONNDATA - DBNAME | Database name | |
| 31 | Table/Structure Field |
MSSCONNDATA - MSGTY | Message Type | |
| 32 | Table/Structure Field |
MSS_DBDATA - DBNAME | Database name | |
| 33 | Table/Structure Field |
MSS_DBDATA - DBNAME | Database name | SOURCE VALUE(DBNAME) LIKE MSS_DBDATA-DBNAME OPTIONAL |
| 34 | Table/Structure Field |
SYMSG - MSGV1 | Message Variable | |
| 35 | Table/Structure Field |
SYMSG - MSGV4 | Message Variable | |
| 36 | Table/Structure Field |
SYMSG - MSGV3 | Message Variable | |
| 37 | Table/Structure Field |
SYMSG - MSGV2 | Message Variable | |
| 38 | Table/Structure Field |
SYMSG - MSGTY | Message Type | |
| 39 | Table/Structure Field |
SYMSG - MSGNO | Message Number | |
| 40 | Table/Structure Field |
SYMSG - MSGID | Message Class | |
| 41 | Table/Structure Field |
SYST - MSGID | ABAP System Field: Message ID | |
| 42 | Table/Structure Field |
SYST - MSGNO | ABAP System Field: Message Number | |
| 43 | Table/Structure Field |
SYST - MSGTY | ABAP System Field: Message Type | |
| 44 | Table/Structure Field |
SYST - MSGV1 | ABAP System Field: Message Variable | |
| 45 | Table/Structure Field |
SYST - MSGV2 | ABAP System Field: Message Variable | |
| 46 | Table/Structure Field |
SYST - MSGV3 | ABAP System Field: Message Variable | |
| 47 | Table/Structure Field |
SYST - MSGV4 | ABAP System Field: Message Variable |
