SAP Table SDBAADAHIS
Backup History (Input: sysdba.cnhist)
SDBAADAHIS (Backup History (Input: sysdba.cnhist)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SDBAADAHIS to other SAP tables.
SDBAADAHIS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| CMD_ID | Command ID (unique; link cnhist <-> cnreprt) | SDBA_CMDID | CHAR | 12 | 0 | |||
| ADALABEL | Backup label | SDBALABEL | CHAR | 13 | 0 | |||
| ACTION | Short name for the DBA action | SDBA_SNAME | CHAR | 11 | 0 | |||
| STRTPNODAT | Date stamp | SDBA_DATE | DATS | 8 | 0 | |||
| STRTPNOTIM | Time (24 hour clock) for DBA action to run | SDBA_TIME | TIMS | 6 | 0 | |||
| STOPPNODAT | Date stamp | SDBA_DATE | DATS | 8 | 0 | |||
| STOPPNOTIM | Time (24 hour clock) for DBA action to run | SDBA_TIME | TIMS | 6 | 0 | |||
| BEGDAT | Date stamp | SDBA_DATE | DATS | 8 | 0 | |||
| BEGTIM | Time (24 hour clock) for DBA action to run | SDBA_TIME | TIMS | 6 | 0 | |||
| ENDDAT | Date stamp | SDBA_DATE | DATS | 8 | 0 | |||
| ENDTIM | Time (24 hour clock) for DBA action to run | SDBA_TIME | TIMS | 6 | 0 | |||
| STARTLPNO | Log page number at start of action | SDBASTRPNO | NUMC | 10 | 0 | |||
| STOPLPNO | Log page number at stop action | SDBASTPPNO | NUMC | 10 | 0 | |||
| LOGREQ | Indicator whether log info required for consistency | SDBALOGREQ | CHAR | 3 | 0 | |||
| MEDIANAME | Logical name of backup volume | SDBAMEDIA | CHAR | 60 | 0 | |||
| PAGECOUNT | No. of pages backed up | SDBAPAGCNT | NUMC | 10 | 0 | |||
| ADAVOLUME | Number of volumes used for backup | SDBAVOLUME | NUMC | 10 | 0 | |||
| RETCOD | Return code | SDBA_RCODE | CHAR | 13 | 0 | |||
| RETTEXT | Error message for return code | SDBARETTEX | CHAR | 40 | 0 | |||
