SAP ABAP Table MSQDBASES (MS SQL server databases ( as from sysdatabases ))
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
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 | MSQDBASES |
Table Relationship Diagram 
|
| Short Description | MS SQL server databases ( as from sysdatabases ) |
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 |  DBNAME |
MSQDBNAME | CHAR255 | CHAR | 255 | 0 | The name of the database in SQL Server instance. | ||
| 2 | DBID |
MSQDBASEID | INT2 | INT2 | 5 | 0 | MS SQL Server database ID | ||
| 3 | SID |
MSQSID | INT4 | INT4 | 10 | 0 | MS SQL Server - database creator user ID | ||
| 4 | DBMODE |
MSQDBMODE | INT2 | INT2 | 5 | 0 | MS SQL server database lock mode | ||
| 5 | STATUS |
MSQDBSTATS | INT4 | INT4 | 10 | 0 | MS SQL server database status | ||
| 6 | STATUS2 |
MSQDBSTATS | INT4 | INT4 | 10 | 0 | MS SQL server database status | ||
| 7 | CRDATE |
MSQCREDATE | CHAR8 | CHAR | 8 | 0 | MS SQL server database creation date. | ||
| 8 | CATEGORY |
MSQCATEGRY | INT4 | INT4 | 10 | 0 | MS SQL server database category | ||
| 9 | CMPTLEVEL |
MSQCMPCOLU | INT1 | INT1 | 3 | 0 | MS SQL server Compatibility Column | ||
| 10 | FILENAME |
MSQFILNAME | CHAR520 | CHAR | 520 | 0 | MS SQL server database physical file name with full path | ||
| 11 | VERSION |
MSQVERSION | INT2 | INT2 | 5 | 0 | MS SQL Server Database version |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
