CNVCDOPCA_SQLTRA SAP (CDOP : SQL Trace File analysis results) Table details
Dictionary Type: Table
Description: CDOP : SQL Trace File analysis results
Description: CDOP : SQL Trace File analysis results
ABAP Code to SELECT data from CNVCDOPCA_SQLTRA
Related tables to CNVCDOPCA_SQLTRA
Access table CNVCDOPCA_SQLTRA
Related tables to CNVCDOPCA_SQLTRA
Access table CNVCDOPCA_SQLTRA
Table field list including key, data, relationships and ABAP select examples
CNVCDOPCA_SQLTRA is a standard SAP Table which is used to store CDOP : SQL Trace File analysis results data and is available within R/3 SAP systems depending on the version and release level.
The CNVCDOPCA_SQLTRA table consists of various fields, each holding specific information or linking keys about CDOP : SQL Trace File analysis results data available in SAP. These include SYSID (Name of SAP System), OBJ_TYPE (Object Type), OBJ_NAME (CDOP - Name of an object in Object Directory Entry (TADIR)), IND_1 (Row Index of Internal Tables).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP CNVCDOPCA_SQLTRA table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
PROJECT_ID | CDOP - Project ID | CNVCDOP_PROJECT_ID | CHAR | 5 | Assigned to domain | ALPHA | CNVCDOP_PROJ_ID | ||
SYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
OBJ_TYPE | Object Type | TROBJTYPE | CHAR | 4 | OBJECT | SCTSOBJECT | |||
OBJ_NAME | CDOP - Name of an object in Object Directory Entry (TADIR) | CNVCDOP_OBJ_NAM | CHAR | 40 | CNVCDOP_OBJ_NAM | ||||
IND_1 | Row Index of Internal Tables | SYTABIX | INT4 | 10 | SYST_LONG | ||||
TOTALEXEC | Total Number of Executions of Identical SQL Statements | TOTALEXEC | DEC | 10 | DECI10 | ||||
EXECTIME | Total Runtime for SQL Statements (in Microseconds) | EXECTIME | DEC | 12 | DEC12 | ||||
RECPROCNUM | Total Number of Database Records Passed to Program | RECPROCNUM | DEC | 10 | DECI10 | ||||
TIMEPEREXE | Average Execution Time per SQL Statement (in ms) | TIMEPEREXE | CHAR | 10 | CHAR10 | ||||
RECPEREXE | Average Number of Database Records per SQL Statement | RECPEREXE | CHAR | 10 | CHAR10 | ||||
AVGTPERREC | Average Processing Time per Database Record | AVGTPERREC | CHAR | 10 | CHAR10 | ||||
MINTPERREC | Minimum Processing Time per Database Record | MINTPERREC | CHAR | 10 | CHAR10 | ||||
TABROWLEN | Record Length of Specified Table | TABROWLEN | CHAR | 6 | CHAR6 | ||||
BUFTYPE | Type of Buffer for Specified Table | BUFTYPE | CHAR | 5 | SQLTDBTYP | ||||
SQLSTAT | Sql statement | CNVCDOP_SQLSTAT | CHAR | 255 | CHAR255 |
Key field | Non-key field |
How do I retrieve data from SAP table CNVCDOPCA_SQLTRA using ABAP code
The following ABAP code Example will allow you to do a basic selection on CNVCDOPCA_SQLTRA to SELECT all data from the tableDATA: WA_CNVCDOPCA_SQLTRA TYPE CNVCDOPCA_SQLTRA.
SELECT SINGLE *
FROM CNVCDOPCA_SQLTRA
INTO CORRESPONDING FIELDS OF WA_CNVCDOPCA_SQLTRA
WHERE...
How to access SAP table CNVCDOPCA_SQLTRA
Within an ECC or HANA version of SAP you can also view further information about CNVCDOPCA_SQLTRA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects