CNVCDMCCA_SQLTRA - CDMC : SQL Trace File analysis results

CDMC : SQL Trace File analysis results information is stored in SAP table CNVCDMCCA_SQLTRA.
 It is part of development package CNV_CDMC_DDICOBJS in software component SV-SMG-CCM-CDM. This development package consists of objects that can be grouped under "CDMC : Data Dictionary Objects".

Fields for table CNVCDMCCA_SQLTRA

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
PROJECT_IDCDMC - Project IDXCNVCDMC_PROJECT_IDCHAR5*
SYSIDName of SAP SystemXSYSYSIDCHAR8
OBJ_TYPEObject TypeXTROBJTYPECHAR4
OBJ_NAMECDMC - Name of an object in Object Directory Entry (TADIR)XCNVCDMC_OBJ_NAMCHAR40
IND_1Row Index of Internal TablesXSYTABIXINT44
TOTALEXECTotal Number of Executions of Identical SQL Statements CDMCCNV_CDMC_TOTALEXECDEC6
EXECTIMETotal Runtime for SQL Statements (in Microseconds) for CDMCCNV_CDMC_EXECTIMEDEC7
RECPROCNUMTotal Number of Database Records Passed to Program for CDMCCNV_CDMC_RECPROCNUMDEC6
TIMEPEREXEAverage Execution Time per SQL Statement (in ms) for CDMCCNV_CDMC_TIMEPEREXECHAR10
RECPEREXEAverage Number of Database Records per SQL Statement forCDMCCNV_CDMC_RECPEREXECHAR10
AVGTPERRECAverage Processing Time per Database Record for CDMCCNV_CDMC_AVGTPERRECCHAR10
MINTPERRECMinimum Processing Time per Database Record for CDMCCNV_CDMC_MINTPERRECCHAR10
TABROWLENRecord Length of Specified Table for CDMCCNV_CDMC_TABROWLENCHAR6
BUFTYPEType of Buffer for Specified Table for CDMCCNV_CDMC_BUFTYPECHAR5
SQLSTATSql statementCNVCDMC_SQLSTATCHAR255
Privacy Policy