RS_CI_CC_ANALYZE_ORA 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_CC_ANALYZE_ORA into the relevant SAP transactions such as SE38 or SE80
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.
Selection Text: P_TOP = Top ... of Cursor Cache
Selection Text: P_EXE = No. of Executions
Selection Text: P_DIR = Disk Reads
Selection Text: P_CPU = CPU Time
Selection Text: P_BIG = CPU Time, all Tables GK>=3
Selection Text: P_BFG = Buffer Gets
Selection Text: P_AVE = Medium CPU Time
Selection Text: P_ALL = Show Other Strategies also
Title: Examination of Top x Statements of Cursor Caches
Text Symbol: 220 = Show Statements with the Following Strategies:
Text Symbol: 212 = (Max. 255) Statements in Cursor Cache Sorted by ...
Text Symbol: 211 = For the Top
Text Symbol: 206 = Display Statements with Other Strategies also
Text Symbol: 205 = Index Range Scan (Range = Client)
Text Symbol: 204 = Hash Join
Text Symbol: 203 = Index Range Scan
Text Symbol: 202 = Full Index Scan
Text Symbol: 201 = Full Table Scan
Text Symbol: 200 = Examine Cursor Cache
Text Symbol: 116 = Buffer Gets
Text Symbol: 115 = Disk Reads
Text Symbol: 114 = CPU Time (Accesses to Large Tables only [GK >= 3])
Text Symbol: 113 = Medium Execution Time
Text Symbol: 112 = No. of Executions
Text Symbol: 111 = CPU Time
Text Symbol: 110 = Sorted by
Text Symbol: 100 = Cursor Cache Analysis of Top &1 Statements
No INCLUDES are used within this REPORT code!
No SAP DATABASE tables are accessed within this REPORT code!
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 = * 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 .
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.