SAP TABLES | Basis Components | Basis Components | Performance Analysis (Transaction ST05)(BC-TWB-TST-P-PA) SAP BC

SACC_TRACE SAP Processed Trace Records Structure and data







SACC_TRACE is an SAP Structure so does not store data like a database table does but can be used to process "Processed Trace Records" 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_SACC_TRACE TYPE SACC_TRACE .

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: Cannot Be Enhanced
See here for more information about this and other SAP enhancement categories


SAP SACC_TRACE Structure fields within data Dictionary





Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDESACC_FIELDCAT Extended Field Catalog for Accessible Trace List
TRANS_IDSQLTTRANIDCHAR32 Transaction GUID
TCODESQLTTCODECHAR20
*
Transaction Code for Performance Trace Analysis
PIDSQLTPIDCHAR2 Work Process Number for Performance Trace Analysis
PTYPESQLTPTYPECHAR3 Work Process Type for Performance Trace Analysis
CLIENTSQLTCLIENCLNT3
*
Client in which performance trace is evaluated
USER_LSQLTUSERCHAR12 User name for performance trace evaluation
DATESACCDATEDATS8 Recording Date of Trace Record
TIMESQLTTIMECHCHAR12 Execution time for SQL trace
DURATIONSACCDURADEC16 Execution Time of an SQL Statement
MODULESQLTPROGCHAR40 Name of program that triggered SQL statement
TABNAMESQLTTABLECHAR30 Object used in trace statement
OPERATIONSQLTOPERCHAR7 Executed Operation
CURSSQLTCURSCHAR4 Cursor Number for the Logged SQL Statement
ARRAYSIZESQLTASIZEINT410 Array
NO_OF_ROWSSQLTRECINT410 Number of records
SQL_RCSQLTRCINT410 Return Code for Logged SQL Statement
CON_NAMESQLTCON_NCHAR5 Logical database connection name -> DBCON-CON_NAME
CON_IDSACCCONIDCHAR9 Database Connection ID
STATSTRWVARSACCSTATWVARSTRING Statement String with Replaced Placeholders
TRACE_TYPESACCTRACETYPECHAR1 Trace Record Type
TRECNUMBERSACCTRECNUMBERINT410 Trace Record Number
EPP_ROOT_IDSACC_EPP_ROOT_IDCHAR32 EPP Root ID
EPP_CONNECTION_IDSACC_EPP_CONN_IDCHAR32 EPP Connection ID
EPP_CONNECTION_COUNTERSACC_EPP_CONN_CNTINT410 EPP Connection Counter
STATSTRSACCSTATSTRING Statement String with Placeholders
VARSTRSACCVARSTRING Variable String from the Trace Record
OFFSTIDSACCOFFSTIDINT410 Offset of Statement IDs in Trace Record
LSTATSTRSACCLSTATSTRINT410 Length of the Statement String with Placeholders



NVARSACCLVARSTRINT410 Number of Variables in Variable String
PSECSTA_TIMEREINT410 Time value in raw statistics record
LINKNUMBERSACCLINKNUMBERINT410 Link Number for Detail Records
LINE_COLORSACCCOLORCHAR4 Grid ALV Line Color
COLOR_DEFSACCCOLORCHAR4 Grid ALV Line Color



Key field
Non-key field