SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

DBAOPTL Table in SAP | DB Optimization - Table Statistics Table & Fields List

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
DBAOPTL table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

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

FieldNoteData ElementDomain
SYS_IDDatabase system IDSDBA_DBSIDCHAR8
OPER_IDUnique operation IDSDBA_OP_IDCHAR14
TASKNAMETask NameSDBA_TASKSDBA_TASK
JOB_NRUnique Job Number in a TaskSDBA_JOBSDBA_JOB
TRIALUnique ID Number of the SuboperationSDBA_TRIALCHAR10
UTIL_NRUtility number within job stepSDBA_UTNRSDBA_UTNR
FUNC_IDDBA Function IDSDBA_FIDSDBA_FUNCT
UPD_OPUpdate Time StampSDBA_UPDSDBA_UPD
OBJObject of DB operationSDBA_OBJ30CHAR30
ANALY_METHAnalysis MethodSDBA_ANMECHAR30
ANALY_OPTIAnalysis methodSDBA_OPTCHAR30
TABLESNumber of statistics to be checkedSDBA_TABCHAR12
TAB_CHECKNumber of checked statisticsSDBA_CHKCHAR12
TAB_OLDNumber of tables with statistics that need to be updatedSDBA_OLDCHAR12
TAB_REFRNumber of tables with updated statisticsSDBA_REFCHAR12

DBAOPTL related tables

TableNote
DBAOPTLDB Optimization - Table Statistics
WDKACTGRPSTATSAction group optimization statistics
ESH_QL_ST_STATSearchterm Statistics Table for Indexing of Statistics Data
OIJ_BPB_OPT_ROil TSW: table of optimization method for BPB
SRM_ASC_DESCManagement Table for Performance Optimization
TCOBJHelp table for optimization reports (INTERNAL USE ONLY!)
VLCSYMBOLVELO: Optimization Table - Only Symbols Relevant to LC
/VSO/M_DATA_CLUSCluster Table for Vehicle Space Optimization Data
CNVCDMCUCIA_STATStatistics data collected from the Statistics system
CNV_00001_OPTPRTTexts for optimization transactions
CNV_10992_STXHSchedule existing TDOBJECT in STXH for optimization
CNV_10994_BDCPSchedule existing object classes in BDCP for optimization
CNV_10994_BDCP2Schedule existing object classes in BDCP2 for optimization
CNV_10994_CDHDRSchedule existing object classes in CDHDR for optimization
CNV_10994_PCDHDRSchedule existing object classes in PCHDR for optimization
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com