CNVCDOPCA_SQLTRA - CDOP : SQL Trace File analysis results
CDOP : SQL Trace File analysis results information is stored in SAP table CNVCDOPCA_SQLTRA.
It is part of development package CNV_CDOP_CA_00 in software component CA-LT. This development package consists of objects that can be grouped under "CDOP: Clearing Analysis - Dictionary Objects".
It is part of development package CNV_CDOP_CA_00 in software component CA-LT. This development package consists of objects that can be grouped under "CDOP: Clearing Analysis - Dictionary Objects".
Fields for table CNVCDOPCA_SQLTRA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| PROJECT_ID | CDOP - Project ID | X | CNVCDOP_PROJECT_ID | CHAR | 10 | * |
| SYSID | Name of SAP System | X | SYSYSID | CHAR | 16 | |
| OBJ_TYPE | Object Type | X | TROBJTYPE | CHAR | 8 | |
| OBJ_NAME | CDOP - Name of an object in Object Directory Entry (TADIR) | X | CNVCDOP_OBJ_NAM | CHAR | 80 | |
| IND_1 | Row Index of Internal Tables | X | SYTABIX | INT4 | 4 | |
| TOTALEXEC | Total Number of Executions of Identical SQL Statements | TOTALEXEC | DEC | 6 | ||
| EXECTIME | Total Runtime for SQL Statements (in Microseconds) | EXECTIME | DEC | 7 | ||
| RECPROCNUM | Total Number of Database Records Passed to Program | RECPROCNUM | DEC | 6 | ||
| TIMEPEREXE | Average Execution Time per SQL Statement (in ms) | TIMEPEREXE | CHAR | 20 | ||
| RECPEREXE | Average Number of Database Records per SQL Statement | RECPEREXE | CHAR | 20 | ||
| AVGTPERREC | Average Processing Time per Database Record | AVGTPERREC | CHAR | 20 | ||
| MINTPERREC | Minimum Processing Time per Database Record | MINTPERREC | CHAR | 20 | ||
| TABROWLEN | Record Length of Specified Table | TABROWLEN | CHAR | 12 | ||
| BUFTYPE | Type of Buffer for Specified Table | BUFTYPE | CHAR | 10 | ||
| SQLSTAT | Sql statement | CNVCDOP_SQLSTAT | CHAR | 510 |