SDBAADAUPD SAP (SAP DB: Log Table for Update Statistics and Checks) Table details
Dictionary Type: Table
Description: SAP DB: Log Table for Update Statistics and Checks
Description: SAP DB: Log Table for Update Statistics and Checks
Table field list including key, data, relationships and ABAP select examples
SDBAADAUPD is a standard SAP Table which is used to store SAP DB: Log Table for Update Statistics and Checks data and is available within R/3 SAP systems depending on the version and release level.
The SDBAADAUPD table consists of various fields, each holding specific information or linking keys about SAP DB: Log Table for Update Statistics and Checks data available in SAP. These include SAVTYP (SDB Action Types for Weekly Planning), UPDTAB (SDB Table Name), UPDCOL (SDB Column Name), BEGDAT (Date stamp for start or end of backup SQL-DB).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP SDBAADAUPD table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| SAVID | Command ID (unique; link cnhist <-> cnreprt) | SDBA_CMDID | CHAR | 12 | CHAR12 | ||||
| SAVTYP | SDB Action Types for Weekly Planning | SAVTYP10 | CHAR | 10 | SAVTYP10 | ||||
| UPDTAB | SDB Table Name | ADATABNAME | CHAR | 30 | CHAR30 | ||||
| UPDCOL | SDB Column Name | ADACOLNAME | CHAR | 18 | CHAR18 | ||||
| BEGDAT | Date stamp for start or end of backup SQL-DB | SDBADATE | CHAR | 10 | CHAR10 | ||||
| BEGTIM | Time (24 hour clock) for DBA action to run | SDBA_TIME | TIMS | 6 | SYTIME | ||||
| ENDDAT | Date stamp for start or end of backup SQL-DB | SDBADATE | CHAR | 10 | CHAR10 | ||||
| ENDTIM | Time (24 hour clock) for DBA action to run | SDBA_TIME | TIMS | 6 | SYTIME | ||||
| AMETH | Analysis Method for Collecting Statistics | AM_AMETH | CHAR | 4 | AM_AMETH | ||||
| SAVSTA | State of backup for SQL-DB | SDBASAVSTA | CHAR | 6 | CHAR6 | ||||
| RETCOD | SAP DB: Return code of backup | SDBARETCOD | DEC | 13 | DEC_13 |
| Key field | Non-key field |
How do I retrieve data from SAP table SDBAADAUPD using ABAP code
The following ABAP code Example will allow you to do a basic selection on SDBAADAUPD to SELECT all data from the tableDATA: WA_SDBAADAUPD TYPE SDBAADAUPD.
SELECT SINGLE *
FROM SDBAADAUPD
INTO CORRESPONDING FIELDS OF WA_SDBAADAUPD
WHERE...
How to access SAP table SDBAADAUPD
Within an ECC or HANA version of SAP you can also view further information about SDBAADAUPD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects