SAP Reports / Programs

RS_CI_ANALYZE_SQL_TRACE SAP ABAP Report - Explain and Valuation for all Statements of an SQL Trace







RS_CI_ANALYZE_SQL_TRACE 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 RS_CI_ANALYZE_SQL_TRACE into the relevant SAP transactions such as SE38 or SE80


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 RS_CI_ANALYZE_SQL_TRACE. "Basic submit
SUBMIT RS_CI_ANALYZE_SQL_TRACE AND RETURN. "Return to original report after report execution complete
SUBMIT RS_CI_ANALYZE_SQL_TRACE 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: USER = User
Selection Text: STRTTIM = Start Time
Selection Text: STRTDAT = Starting Date
Selection Text: OTHERS = Other Strategies
Selection Text: IRS = Index Range Scan
Selection Text: ICS = Index Client Scan
Selection Text: FTS = Full Table Scan
Selection Text: FIS = Full Index Scan
Selection Text: ENDTIM = Finish Time
Selection Text: ENDDAT = End Day
Selection Text: BUF_ALW = Access Buffered Tables
Title: Explain and Valuation for all Statements of an SQL Trace
Text Symbol: 300 = Explain Analysis of SQL Trace
Text Symbol: 255 = Show all accesses to tables that are or can be buffered
Text Symbol: 250 = Other Strategies
Text Symbol: 245 = Index Range Scan
Text Symbol: 240 = Index Range Scan (Range = Client)
Text Symbol: 235 = Full Index Scan
Text Symbol: 230 = Full Table Scan
Text Symbol: 200 = Show Statements with These Strategies:
Text Symbol: 125 = End Time
Text Symbol: 120 = StartTime
Text Symbol: 115 = End Day
Text Symbol: 110 = Start day
Text Symbol: 100 = Trace Period


INCLUDES used within this REPORT RS_CI_ANALYZE_SQL_TRACE

No INCLUDES are used within this REPORT code!


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:

PERFORMANCE_TRACE_SUMMARY call function 'PERFORMANCE_TRACE_SUMMARY' exporting START_DATE = STRTDAT START_TIME = STRTTIM END_DATE = ENDDAT END_TIME = ENDTIM TRACE_USER = USER * SQL_TRACE_EVA = 'X' TRACE_OFF = '' * PROVIDE_STATEMENT = 'X' * CLIENT = ' ' * STAT_SUM_CHECK_NEW = 'X' FILL_FULL_TAB = 'X' importing SCIT_SQL_ANALYZE = LT_SQL * tables * STRACSUM_TAB = * STRACRFC_TAB = * TRANS_ID_TAB = * STRACMSG_TAB = exceptions others = 12 .

REUSE_ALV_LIST_DISPLAY call function 'REUSE_ALV_LIST_DISPLAY' exporting * I_INTERFACE_CHECK = ' ' I_BYPASSING_BUFFER = 'X' * I_BUFFER_ACTIVE = 'X' I_CALLBACK_PROGRAM = L_REPID I_CALLBACK_PF_STATUS_SET = 'SET_PF_STATUS' I_CALLBACK_USER_COMMAND = 'UCOMM_ALV_NAVIGATION' I_STRUCTURE_NAME = 'SCI_CC_ALV' IS_LAYOUT = L_LAYOUT IT_FIELDCAT = LT_FIELDCAT * IT_EXCLUDING = * IT_SPECIAL_GROUPS = * IT_SORT = * IT_FILTER = * IS_SEL_HIDE = * I_DEFAULT = 'X' * I_SAVE = ' ' * IS_VARIANT = IT_EVENTS = GT_EVENTS[] * IT_EVENT_EXIT = * IS_PRINT = * IS_REPREP_ID = * I_SCREEN_START_COLUMN = 0 * I_SCREEN_START_LINE = 0 * I_SCREEN_END_COLUMN = 0 * I_SCREEN_END_LINE = 0 * IMPORTING * E_EXIT_CAUSED_BY_CALLER = * ES_EXIT_CAUSED_BY_USER = tables T_OUTTAB = LT_ALV exceptions * PROGRAM_ERROR = 1 others = 2 .

REUSE_ALV_EVENTS_GET call function 'REUSE_ALV_EVENTS_GET' exporting I_LIST_TYPE = 0 importing ET_EVENTS = RT_EVENTS.

REUSE_ALV_COMMENTARY_WRITE call function 'REUSE_ALV_COMMENTARY_WRITE' exporting IT_LIST_COMMENTARY = LT_LIST_TOP_OF_PAGE.

DB_EXPLAIN_PLAN call function 'DB_EXPLAIN_PLAN' exporting STATEMENT = L_STATEMENT * NO_DISPLAY = ' ' * STMT_LG = 0 tables VALUES = LWA_SQL-VALUES * PLAN = * ORA_PAR = exceptions * EXPLAIN_FAILED = 1 others = 2 .

RS_TOOL_ACCESS call function 'RS_TOOL_ACCESS' exporting OPERATION = 'SHOW' OBJECT_NAME = L_TABNAME OBJECT_TYPE = 'TABL' exceptions others = 3.

DB_SQL_SOURCE_DISPLAY call function 'DB_SQL_SOURCE_DISPLAY' exporting SOURCE_REF = L_NAVIGATE exceptions * SOURCE_NOT_FOUND = 1 others = 2 .



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 RS_CI_ANALYZE_SQL_TRACE or its description.