SAP MSQBACKSET Table in S/4 HANA - MS SQL server backup list
MSQBACKSET is a standard SAP Table which is used to store MS SQL server backup list data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MSQBACKSET table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Cannot Be Enhanced
Dictionary Type: Structure
Database Table: MSQBACKSET
MSQBACKSET table structure field list
Below is the full MSQBACKSET field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
DBNAME | Database name | MSSDB | CHAR | 128(0) | MSSSYSNAME | |||||
BKUPTYPE | MS SQL server - Backup Type description | MSSBKTYPES | CHAR | 30(0) | ||||||
BACKSTART | MS SQL server backup finish date | MSQBKFINDT | CHAR | 20(0) | ||||||
BACKDEVNAM | MS SQL server backup device name | MSQDEVNAME | CHAR | 128(0) | MSSSYSNAME | |||||
VOLUMENAME | MS SQL Server - Desciption of the media name | MSQBKMEDNA | CHAR | 128(0) | ||||||
BACKUPID | MS SQL Server backup ID for the backup task | MSQBAKUPID | INT4 | 10(0) | INT4 | |||||
BKUPNAME | Name of the backup set | MSSBKNAME | CHAR | 128(0) | MSSSYSNAME | |||||
BKUPDESC | Description of the backup set | MSSBKDESC | CHAR | 255(0) | ||||||
BACKDBSIZE | MS SQL server DB size | MSQDBSZ | DEC | 14(4) | ||||||
BKUPDURA | Backup job run duration | MSSBKDURA | CHAR | 8(0) |
Search for further information about these or an SAP related objects