SAP ABAP Table MSQBACKMED (MS SQL SERVER BACKUP MEDIASETS)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server
Basic Data
| Table Category | INTTAB | Structure |
| Structure | MSQBACKMED |
Table Relationship Diagram 
|
| Short Description | MS SQL SERVER BACKUP MEDIASETS |
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 |  MEIDASETID |
MSSBKMDSID | INT4 | 10 | 0 | Backup media set id | |||
| 2 | BACKSETID |
MSQBAKUPID | INT4 | INT4 | 10 | 0 | MS SQL Server backup ID for the backup task | ||
| 3 | NAME1 |
MSQBKMEDNA | CHAR | 128 | 0 | MS SQL Server - Desciption of the media name | |||
| 4 | NAME2 |
MSSBKNAME | MSSSYSNAME | CHAR | 128 | 0 | Name of the backup set | ||
| 5 | DESC1 |
MSSMDSETDS | MSSSYSNAME | CHAR | 128 | 0 | MS Sql Server - Backup media set description | ||
| 6 | DESC2 |
MSSBKDESC | CHAR | 255 | 0 | Description of the backup set | |||
| 7 | SFTNAME |
MSSBKSFTNA | CHAR | 128 | 0 | MS SQL Server - Backup software Name | |||
| 8 | 1FAMILYNUM |
MSSFSTFANU | INT2 | 5 | 0 | MS SQL Server - Family num of media where the backup starts | |||
| 9 | BACKUPPOS |
MSSBKSETPO | INT4 | 10 | 0 | MS SQL Server - Backup set position | |||
| 10 | EXP_DATE |
MSQEXPDATE | CHAR20 | CHAR | 20 | 0 | MS SQL server - backup expiration date | ||
| 11 | START_DATE |
MSSBKSTART | CHAR20 | CHAR | 20 | 0 | MS SQL Server: Database starting time | ||
| 12 | END_DATE |
MSQBKFINDT | CHAR | 20 | 0 | MS SQL server backup finish date | |||
| 13 | TYPE |
MSQBKTYPE | CHAR1 | CHAR | 1 | 0 | MS SQL server - backup type ( full, differential, log) | ||
| 14 | DBNAME |
MSSDB | MSSSYSNAME | CHAR | 128 | 0 | Database name | ||
| 15 | SERVERNAM |
MSSSERVER1 | TEXT30 | CHAR | 30 | 0 | MS SQL Server server to be used for a SQL task execution | ||
| 16 | MACHINENAM |
MSQHOSTNA | CHAR30 | CHAR | 30 | 0 | MS SQL server - server name | ||
| 17 | JOB_ID |
MSQJOBID | MSQHEX16 | RAW | 16 | 0 | MS SQL Server job ID | ||
| 18 | BACKUPTYPE |
MSSBKTYPES | CHAR | 30 | 0 | MS SQL server - Backup Type description |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
