SQLR0001 SAP ABAP Report - SQL Trace Interpreter
SQLR0001 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter SQLR0001 into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
SQLR - SQL Trace Interpreter
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT SQLR0001. "Basic submit
SUBMIT SQLR0001 AND RETURN. "Return to original report after report execution complete
SUBMIT SQLR0001 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: R3COMP = SAP Component Hierarchy
Selection Text: G_W_UP = With Update Processes
Selection Text: G_USER = Trace User
Selection Text: G_TABLES = Object Name
Selection Text: G_STTIME = Trace Start Time
Selection Text: G_STDATE = Trace Start Date
Selection Text: G_O_UP = Only Update Processes
Selection Text: G_N_UP = Without Update Processes
Selection Text: G_ENTIME = Trace End Time
Selection Text: CUSTCOMP = SQLR Customizing
Title: SQL Trace Interpreter
Text Symbol: 117 = |WPID
Text Symbol: 118 = |Typ
Text Symbol: 119 = |Transaction
Text Symbol: 120 = |Subfunction
Text Symbol: 121 = |DB
Text Symbol: 122 = |Non-DB
Text Symbol: 123 = |Time(ms)
Text Symbol: 124 = |(in %)
Text Symbol: 125 = |
Text Symbol: 126 = |
Text Symbol: 127 = Unsaved Data Will Be Lost. Do You Want to Save?
Text Symbol: 128 = Confirmation for Save
Text Symbol: 129 = 20 SQL Trace Records with Longest Non-Database Times (Gaps)
Text Symbol: 116 = ST |hh:mm:ss.ms |Luration |Program |Object
Text Symbol: 115 = |PID
Text Symbol: 114 = |Percent
Text Symbol: 113 = HH:MM:SS.MS
Text Symbol: 112 = |Program
Text Symbol: 111 = |Response
Text Symbol: 110 = |Pro Time
Text Symbol: 109 = |
Text Symbol: 108 = |Function
Text Symbol: 107 = |Appl
Text Symbol: 106 = |Records
Text Symbol: 105 = |Operation
Text Symbol: 104 = |ObjectName
Text Symbol: 070 = Confirm Overwrite
Text Symbol: 156 = 20 Client RFC Records with Longest Remote Times
Text Symbol: 155 = |Program
Text Symbol: 154 = |Duration
Text Symbol: 153 = |Non-DB Time
Text Symbol: 152 = |Buff. Object
Text Symbol: 151 = |Function (Component)
Text Symbol: 150 = |Function (Object)
Text Symbol: 149 = |Subfunction
Text Symbol: 148 = |Response |DB Resp. |CPU
Text Symbol: 147 = GUI |Wait |Memory |Load/Gen.|KBytes |Phys. DB
Text Symbol: 146 = ID |Start Time |End Time |Tcode
Text Symbol: 145 = Program |T |Scr. |WP
Text Symbol: 144 = User |Time(ms) |Time(ms) |Time(ms)
Text Symbol: 143 = Time(ms)|Time(ms) |Used(KB) |Time(ms) |Transfer |Change
Text Symbol: 142 = Program with 10
Text Symbol: 141 = Object Name with 40
Text Symbol: 140 = Object Name with 10
Text Symbol: 139 = Object Name with 30
Text Symbol: 138 = Estimated Response Time According to Statistics Records without GUI Time:
Text Symbol: 137 = GUIT Time According to Statistics Records:
Text Symbol: 136 = |Function (Object)
Text Symbol: 135 = |Function (Component)
Text Symbol: 134 = Percentage of Datbase Time for Buffered Objects:
Text Symbol: 133 = Database Time for Buffered Objects:
Text Symbol: 132 = Buffered Objects
Text Symbol: 131 = Application Logic
Text Symbol: 130 = SQL Trace Interpreter Summary:
Text Symbol: 069 = Delete Table Entry?
Text Symbol: 035 = Current Version (
Text Symbol: 034 = SQL Trace Interpreter
Text Symbol: 033 = Do You Want to Leave the SQL Trace Interpreter?
Text Symbol: 032 = Server:
Text Symbol: 031 = System ID:
Text Symbol: 030 = Instance Name
Text Symbol: 029 = User:
Text Symbol: 028 = End Time:
Text Symbol: 027 = End Date:
Text Symbol: 026 = Start Time:
Text Symbol: 025 = Start Date:
Text Symbol: 024 = Check the Database Time
Text Symbol: 023 = Estimated Database Time According to Trace Records:
Text Symbol: 022 = Estimated Duration of Application Execution According to Stats Records:
Text Symbol: 021 = Estimated Response Time According to Trace Records:
Text Symbol: 020 = Verify the Update Response Time
Text Symbol: 019 = Estimated Rem. Time
Text Symbol: 018 = ms
Text Symbol: 017 = Check the Database Time
Text Symbol: 016 = Estimated Response Time for Update Processes:
Text Symbol: 015 = Estimated Response Time According to Statistics Records:
Text Symbol: 014 = 20 SQL Trace Records with Longest Database Times
Text Symbol: 013 = Statistics Records:
Text Symbol: 012 = Is Longer Than Database Time in Statistics Records.
Text Symbol: 011 = Total Database Time for Manually Connected Trace Records
Text Symbol: 010 = Manually Connected Trace Records Do Not Match Statistics Records
Text Symbol: 009 = Some Trace Records Were Manually Connected to Statistics Records
Text Symbol: 008 = Some Trace Records Were Manually Connected with Functions
Text Symbol: 007 = Some Trace Records Were Ignored
Text Symbol: 006 = Proc.Type
Text Symbol: 005 = Trace Data
Text Symbol: 001 = Transaction/Report
Text Symbol: 036 = ) Is Higher than Loaded Version (
Text Symbol: 068 = Confirm Deletion
Text Symbol: 067 = Do You Want to Overwrite the Table Entry?
Text Symbol: 066 = New Customizing Version
Text Symbol: 065 = Do You Want to Create a New Version?
Text Symbol: 064 = Changes
Text Symbol: 063 = Transfer
Text Symbol: 062 = Time(ms)
Text Symbol: 061 = Used(KB)
Text Symbol: 060 = Time(ms)
Text Symbol: 059 = User
Text Symbol: 058 = WP
Text Symbol: 057 = Scr.
Text Symbol: 056 = T
Text Symbol: 055 = Program
Text Symbol: 054 = TCode
Text Symbol: 053 = Finish Time
Text Symbol: 052 = Start time
Text Symbol: 051 = ID
Text Symbol: 050 = Phys. DB
Text Symbol: 049 = KB
Text Symbol: 048 = Load/Gen.
Text Symbol: 047 = DB Resp.
Text Symbol: 046 = CPU
Text Symbol: 045 = Wait
Text Symbol: 044 = Memory
Text Symbol: 043 = Reply
Text Symbol: 042 = Subfunction
Text Symbol: 041 = Function
Text Symbol: 040 = New Customizing Version
Text Symbol: 039 = Create New Version Number?
Text Symbol: 038 = Ignore?
Text Symbol: 037 = ).
INCLUDES used within this REPORT SQLR0001
INCLUDE SQLR1TOP. " GLOBAL DATA
INCLUDE SQLR1F01. " FORM-ROUTINES
INCLUDE SQLR1E01. " EVENTS
INCLUDE SQLR1O01. " PBO MODULES
INCLUDE SQLR1I01. " PAI MODULES
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
No SAP FUNCTION MODULES are executed within this report code!
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name SQLR0001 or its description.