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
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 DBTMPORA Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| DBOBJ | Name of Database Object | AM_DBOBJ | AM_DBOBJ |
| DOTYP | Type of Database Object | AM_DOTYP | AM_DOTYP |
| OBJOW | Owner of the Database Object | AM_DBOWN | CHAR30 |
| DBTYP | Database | DBSYSTEM | DBSYSTEM |
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | AM_VWTYPE |
| ACTIV | Control Flag for Update of Statistics | AM_ACTVE | AM_ACTIVE |
| OBJEC | Identification of EDM cluster | UDCLUID | UDCLUID |
| AEDAT | Change/Insert Date in Control Table | AM_AENDDAT | SYDATS |
| SIGNI | Significance for Collection of Statistics | AM_SIGNI | AM_SIGNI |
| AMETH | Analysis Method for Collecting Statistics | AM_AMETH | AM_AMETH |
| OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR5 |
| TOBDO | TODO Flag: Create New Statistics | AM_TOBDO | AM_TOBDO |
| HISTO | HISTORY Flag: With History | AM_HISTO | AM_HISTO |
| TDDAT | Date on Which the ToDo Flag Was Set | AM_TDDAT | SYDATS |
| DURAT | Estimated runtime of table analysis | AM_DURAT | SYTIME |
| PLAND | Customer Flag: Customer Setting | AM_PLAND | AM_PLAND |
DBTMPORA related tables
| Table | Note |
|---|---|
| DBTMPORA | DB Optimizer Control (Statistics Creation) |
| DB6_OPTPROFILE | Optimizer Profiles for SQL Statements |
| SQ3007_DB4 | iSeries: Optimizer Timed Out (Database Monitor) |
| /MRSS/C_OPT_FILT | Text Table for Definition of Optimizer Scenario |
| /MRSS/C_OPT_LOG | Customizing Table for Optimizer Log Definition |
| /MRSS/C_OPT_LOGT | Customizing Table for Definition of Optimizer Log (Texts) |
| /MRSS/C_OPT_MSG | Customizing for individual error level of optimizer messages |
| /MRSS/C_OPT_SCET | Text Table for Definition of Optimizer Scenario |
| /MRSS/C_OPT_SYST | Text Table for Optimizer System Settings |
| /TMWFLOW/MOLOCK | Lock Table for Maintenance Optimizer Procedures |
| TIMA_CRT_ACC | IO: Creation Variants for Account Creation |
| TIMA_CRT_ACCT | IO: Creation Variants Text Table for Automatic Acct Creation |
| DBSTATC | Configuration of Statistics Creation |
| CNVCDMCUCIA_STAT | Statistics data collected from the Statistics system |
| ESH_QL_ST_STAT | Searchterm Statistics Table for Indexing of Statistics Data |
Control of inspection lot creation (lot creation) TablesExchange rate for statistics (exch.rate at time of creation) TablesControl of inspection lot creation (lot summary) TablesCreation date of control cycle TablesCondition is used for statistics Tables"statistics-relevant delivery date" TablesStatistics-relevant delivery date TablesStatistics update indicator (post in/post out) Tables
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output 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