SAP MSQBACKMED Table in S/4 HANA - MS SQL SERVER BACKUP MEDIASETS
MSQBACKMED is a standard SAP Table which is used to store MS SQL SERVER BACKUP MEDIASETS 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 MSQBACKMED table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Structure
Database Table: MSQBACKMED
MSQBACKMED table structure field list
Below is the full MSQBACKMED 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 |
| MEIDASETID | Backup media set id | MSSBKMDSID | INT4 | 10(0) | ||||||
| BACKSETID | MS SQL Server backup ID for the backup task | MSQBAKUPID | INT4 | 10(0) | INT4 | |||||
| NAME1 | MS SQL Server - Desciption of the media name | MSQBKMEDNA | CHAR | 128(0) | ||||||
| NAME2 | Name of the backup set | MSSBKNAME | CHAR | 128(0) | MSSSYSNAME | |||||
| DESC1 | MS Sql Server - Backup media set description | MSSMDSETDS | CHAR | 128(0) | MSSSYSNAME | |||||
| DESC2 | Description of the backup set | MSSBKDESC | CHAR | 255(0) | ||||||
| SFTNAME | MS SQL Server - Backup software Name | MSSBKSFTNA | CHAR | 128(0) | ||||||
| 1FAMILYNUM | MS SQL Server - Family num of media where the backup starts | MSSFSTFANU | INT2 | 5(0) | ||||||
| BACKUPPOS | MS SQL Server - Backup set position | MSSBKSETPO | INT4 | 10(0) | ||||||
| EXP_DATE | MS SQL server - backup expiration date | MSQEXPDATE | CHAR | 20(0) | CHAR20 | |||||
| START_DATE | MS SQL Server: Database starting time | MSSBKSTART | CHAR | 20(0) | CHAR20 | |||||
| END_DATE | MS SQL server backup finish date | MSQBKFINDT | CHAR | 20(0) | ||||||
| TYPE | MS SQL server - backup type ( full, differential, log) | MSQBKTYPE | CHAR | 1(0) | CHAR1 | |||||
| DBNAME | Database name | MSSDB | CHAR | 128(0) | MSSSYSNAME | |||||
| SERVERNAM | MS SQL Server server to be used for a SQL task execution | MSSSERVER1 | CHAR | 30(0) | TEXT30 | |||||
| MACHINENAM | MS SQL server - server name | MSQHOSTNA | CHAR | 30(0) | CHAR30 | |||||
| JOB_ID | MS SQL Server job ID | MSQJOBID | RAW | 16(0) | MSQHEX16 | |||||
| BACKUPTYPE | MS SQL server - Backup Type description | MSSBKTYPES | CHAR | 30(0) |
Search for further information about these or an SAP related objects