DBAOPTL is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DBAOPTL in SAP.
- Table description : DB Optimization - Table Statistics
- Module : BC-DB-ORA-CCM
- Parent Module : BC
- Package : SDBA
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP DBAOPTL Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| SYS_ID | Database system ID | SDBA_DBSID | CHAR8 |
| OPER_ID | Unique operation ID | SDBA_OP_ID | CHAR14 |
| TASKNAME | Task Name | SDBA_TASK | SDBA_TASK |
| JOB_NR | Unique Job Number in a Task | SDBA_JOB | SDBA_JOB |
| TRIAL | Unique ID Number of the Suboperation | SDBA_TRIAL | CHAR10 |
| UTIL_NR | Utility number within job step | SDBA_UTNR | SDBA_UTNR |
| FUNC_ID | DBA Function ID | SDBA_FID | SDBA_FUNCT |
| UPD_OP | Update Time Stamp | SDBA_UPD | SDBA_UPD |
| OBJ | Object of DB operation | SDBA_OBJ30 | CHAR30 |
| ANALY_METH | Analysis Method | SDBA_ANME | CHAR30 |
| ANALY_OPTI | Analysis method | SDBA_OPT | CHAR30 |
| TABLES | Number of statistics to be checked | SDBA_TAB | CHAR12 |
| TAB_CHECK | Number of checked statistics | SDBA_CHK | CHAR12 |
| TAB_OLD | Number of tables with statistics that need to be updated | SDBA_OLD | CHAR12 |
| TAB_REFR | Number of tables with updated statistics | SDBA_REF | CHAR12 |
DBAOPTL related tables
| Table | Note |
|---|---|
| DBAOPTL | DB Optimization - Table Statistics |
| WDKACTGRPSTATS | Action group optimization statistics |
| ESH_QL_ST_STAT | Searchterm Statistics Table for Indexing of Statistics Data |
| OIJ_BPB_OPT_R | Oil TSW: table of optimization method for BPB |
| SRM_ASC_DESC | Management Table for Performance Optimization |
| TCOBJ | Help table for optimization reports (INTERNAL USE ONLY!) |
| VLCSYMBOL | VELO: Optimization Table - Only Symbols Relevant to LC |
| /VSO/M_DATA_CLUS | Cluster Table for Vehicle Space Optimization Data |
| CNVCDMCUCIA_STAT | Statistics data collected from the Statistics system |
| CNV_00001_OPTPRT | Texts for optimization transactions |
| CNV_10992_STXH | Schedule existing TDOBJECT in STXH for optimization |
| CNV_10994_BDCP | Schedule existing object classes in BDCP for optimization |
| CNV_10994_BDCP2 | Schedule existing object classes in BDCP2 for optimization |
| CNV_10994_CDHDR | Schedule existing object classes in CDHDR for optimization |
| CNV_10994_PCDHDR | Schedule existing object classes in PCHDR for optimization |
Related tcodes for DBAOPTL
Transaction codes in the same SAP package (SDBA) as the DBAOPTL table.
| Tcode | Description |
|---|---|
| DB12 | DBA Backup Logs |
| DB13 | DBA Planning Calendar |
| DB14 | Display DBA Operation Logs |
| DB16 | Display DB Check Results |
| DB17 | Configure DB Check |
| DB20 | Update DB Statistics |
| DB21 | Configure DB Statistics |
| DB24 | Administrative Database Operations |
| DB13C | Central DBA Planning Calendar |
| DBCO | Database Connection Maintenance |
| DB12OLD | DBA Backup Logs (OLD) |
| DB13OLD | DBA Planning Calendar (OLD) |
Statistics update indicator (post in/post out) TablesUpdate group for statistics update TablesStatistics-relevant delivery date Tables"statistics-relevant delivery date" TablesExchange rate for statistics (exch.rate at time of creation) TablesCondition is used for statistics TablesPurchase order line item table TablesPurchase order history table Tables
Latest Table Searches
Handling units sap table in SAPHow to display handling unit table in SAP
Sap handling unit zuordnung löschen table in SAP
Where to find handling unit table in SAP
Handling unit management configuration wm table in SAP
Handling unit wm table in SAP
What is sap handling unit table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP