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

DBTMPORA Table in SAP | DB Optimizer Control (Statistics Creation) Table & Fields List

DBTMPORA is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DBTMPORA in SAP.

  • Table description : DB Optimizer Control (Statistics Creation)
  • Module : BC-DB-ORA-CCM
  • Parent Module : BC
  • 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
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