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

DBTMPORA Table in SAP: DB Optimizer Control (Statistics Creation)

DBTMPORA is an SAP table in package SDBA, software component SAP_BASIS. View details, fields & related tables of DBTMPORA in SAP.

  • Table description : DB Optimizer Control (Statistics Creation)
  • Package : SDBA
  • Software Component : SAP_BASIS
DBTMPORA 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 DBTMPORA Table Fields structure

FieldNoteData ElementDomain
DBOBJName of Database ObjectAM_DBOBJAM_DBOBJ
DOTYPType of Database ObjectAM_DOTYPAM_DOTYP
OBJOWOwner of the Database ObjectAM_DBOWNCHAR30
DBTYPDatabaseDBSYSTEMDBSYSTEM
VWTYPType of Usage of Table EntryAM_VWTYPAM_VWTYPE
ACTIVControl Flag for Update of StatisticsAM_ACTVEAM_ACTIVE
OBJECIdentification of EDM clusterUDCLUIDUDCLUID
AEDATChange/Insert Date in Control TableAM_AENDDATSYDATS
SIGNISignificance for Collection of StatisticsAM_SIGNIAM_SIGNI
AMETHAnalysis Method for Collecting StatisticsAM_AMETHAM_AMETH
OPTIOSample Size for Collection of StatisticsAM_OPTIOCHAR5
TOBDOTODO Flag: Create New StatisticsAM_TOBDOAM_TOBDO
HISTOHISTORY Flag: With HistoryAM_HISTOAM_HISTO
TDDATDate on Which the ToDo Flag Was SetAM_TDDATSYDATS
DURATEstimated runtime of table analysisAM_DURATSYTIME
PLANDCustomer Flag: Customer SettingAM_PLANDAM_PLAND

DBTMPORA related tables

TableNote
DBTMPORADB Optimizer Control (Statistics Creation)
DB6_OPTPROFILEOptimizer Profiles for SQL Statements
SQ3007_DB4iSeries: Optimizer Timed Out (Database Monitor)
/MRSS/C_OPT_FILTText Table for Definition of Optimizer Scenario
/MRSS/C_OPT_LOGCustomizing Table for Optimizer Log Definition
/MRSS/C_OPT_LOGTCustomizing Table for Definition of Optimizer Log (Texts)
/MRSS/C_OPT_MSGCustomizing for individual error level of optimizer messages
/MRSS/C_OPT_SCETText Table for Definition of Optimizer Scenario
/MRSS/C_OPT_SYSTText Table for Optimizer System Settings
/TMWFLOW/MOLOCKLock Table for Maintenance Optimizer Procedures
TIMA_CRT_ACCIO: Creation Variants for Account Creation
TIMA_CRT_ACCTIO: Creation Variants Text Table for Automatic Acct Creation
DBSTATCConfiguration of Statistics Creation
CNVCDMCUCIA_STATStatistics data collected from the Statistics system
ESH_QL_ST_STATSearchterm Statistics Table for Indexing of Statistics Data

Related tcodes for DBTMPORA

Transaction codes in the same SAP package (SDBA) as the DBTMPORA table.

TcodeDescription
DB12DBA Backup Logs
DB13DBA Planning Calendar
DB14Display DBA Operation Logs
DB16Display DB Check Results
DB17Configure DB Check
DB20Update DB Statistics
DB21Configure DB Statistics
DB24Administrative Database Operations
DB13CCentral DBA Planning Calendar
DBCODatabase Connection Maintenance
DB12OLDDBA Backup Logs (OLD)
DB13OLDDBA Planning Calendar (OLD)
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.
©2026 sapstack.com