SACC_TRACE SAP (Processed Trace Records) Structure details

Dictionary Type: Structure
Description: Processed Trace Records




ABAP Code to SELECT data from SACC_TRACE
Related tables to SACC_TRACE
Access table SACC_TRACE




Structure field list including key, data, relationships and ABAP select examples

SACC_TRACE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or 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.

The SACC_TRACE table consists of various fields, each holding specific information or linking keys about Processed Trace Records data available in SAP. These include TRANS_ID (Transaction GUID), TCODE (Transaction Code for Performance Trace Analysis), PID (Work Process Number for Performance Trace Analysis), PTYPE (Work Process Type for Performance Trace Analysis).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP SACC_TRACE structure 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
TRANS_IDTransaction GUID SQLTTRANIDCHAR32CHAR32
TCODETransaction Code for Performance Trace Analysis SQLTTCODECHAR20Assigned to domainTCODE
PIDWork Process Number for Performance Trace Analysis SQLTPIDCHAR2CHAR2
PTYPEWork Process Type for Performance Trace Analysis SQLTPTYPECHAR3WPTYP
CLIENTClient in which performance trace is evaluated SQLTCLIENCLNT3Assigned to domainMANDT
USER_LUser name for performance trace evaluation SQLTUSERCHAR12AS4USER
DATERecording Date of Trace Record SACCDATEDATS8SYDATS
TIMEExecution time for SQL trace SQLTTIMECHCHAR12CHAR12
DURATIONExecution Time of an SQL Statement SACCDURADEC16SACCDURAD
MODULEName of program that triggered SQL statement SQLTPROGCHAR40CHAR40
TABNAMEObject used in trace statement SQLTTABLECHAR30SQLTAS4TAB
OPERATIONExecuted Operation SQLTOPERCHAR7CHAR7
CURSCursor Number for the Logged SQL Statement SQLTCURSCHAR4CHAR4
ARRAYSIZEArray SQLTASIZEINT410INT4
NO_OF_ROWSNumber of records SQLTRECINT410INT4
SQL_RCReturn Code for Logged SQL Statement SQLTRCINT410INT4
CON_NAMELogical database connection name -> DBCON-CON_NAME SQLTCON_NCHAR5CHAR5
CON_IDDatabase Connection ID SACCCONIDCHAR9CHAR9
STATSTRWVARStatement String with Replaced Placeholders SACCSTATWVARSTRG0SACCSTRING
TRACE_TYPETrace Record Type SACCTRACETYPECHAR1SACCTRACETYPED
TRECNUMBERTrace Record Number SACCTRECNUMBERINT410
EPP_ROOT_IDEPP Root ID SACC_EPP_ROOT_IDCHAR32
EPP_CONNECTION_IDEPP Connection ID SACC_EPP_CONN_IDCHAR32
EPP_CONNECTION_COUNTEREPP Connection Counter SACC_EPP_CONN_CNTINT410
STATSTRStatement String with Placeholders SACCSTATSTRG0SACCSTRING
VARSTRVariable String from the Trace Record SACCVARSTRG0SACCSTRING
OFFSTIDOffset of Statement IDs in Trace Record SACCOFFSTIDINT410
LSTATSTRLength of the Statement String with Placeholders SACCLSTATSTRINT410SACCLSTATSTRD
NVARNumber of Variables in Variable String SACCLVARSTRINT410SACCLVARSTRD
PSECTime value in raw statistics record STA_TIMEREINT410STAT_TIMI0
LINKNUMBERLink Number for Detail Records SACCLINKNUMBERINT410
LINE_COLORGrid ALV Line Color SACCCOLORCHAR4CHAR4
COLOR_DEFGrid ALV Line Color SACCCOLORCHAR4CHAR4

Key field Non-key field



How do I retrieve data from SAP structure SACC_TRACE using ABAP code?

As SACC_TRACE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SACC_TRACE as there is no data to select.

How to access SAP table SACC_TRACE

Within an ECC or HANA version of SAP you can also view further information about SACC_TRACE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!