SAP TABLES | Basis Components | Use Subcomponents | Monitoring(BC-CCM-MON) SAP BC

TRACETABLE SAP Trace Table for SQL Trace Interpreter Structure and data







TRACETABLE is an SAP Structure so does not store data like a database table does but can be used to process "Trace Table for SQL Trace Interpreter" Information within sap ABAP programs. This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TRACETABLE TYPE TRACETABLE .

Below is the documentation avaialable and full details of the fields which make up this Structure.

You can view further information about this via relevant transactions such as SE11 or SE80. Also check out the Comments section below to view or add related contributions and example screen shots.



Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Not classified
See here for more information about this and other SAP enhancement categories


SAP TRACETABLE Structure fields within data Dictionary





Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDETRACETAB Table Structure for SQL Trace
DURATION1SQLRREMTIINT410 SQLR: Remaining Time
TIMESTAMPSQLRSTAMPCHAR12 SQLR: Execution Time for SQL Trace
DURATIONSQLRDURAINT410 SQLR: Datbase Time
PROGRAMSYREPIDCHAR40
*
ABAP Program: Current Main Program
TABLETABNAMECHAR30
*
Table Name
BUFFERINGSQLRBUFFCHAR8 SQLR: Buffering Table
OPERATIONCHAR8CHAR8 Character field, 8 characters long
RECORDSINT4INT410 Natural Number
RETCODECHAR8CHAR8 Character field, 8 characters long
PTR_STARTINT4INT410 Natural Number
PTR_ENDINT4INT410 Natural Number
LEN_STARTINT4INT410 Natural Number
LEN_ENDINT4INT410 Natural Number
NDBDURASQLRNBDTDEC18 Non-Database Time
SQLRAPIDSQLRPOSIDCHAR24 SQLR: Application Component ID
SQLRPIDSQLRPIDCHAR10 SQLR: Process ID
SQLRWPIDSQLRWPIDINT410 SQLR: Workprocess ID
SQLRTCODSQLRTCODCHAR4 SQLR: Transaction Code
SQLRTRANSSQLRTRANSCHAR3 SQLR: Transaction Type



Key field
Non-key field