SAP Reports / Programs | Basis Components | Basis Components | Operational Data Provisioning (ODP)(BC-EIM-ODP) SAP BC

RODPS_SQL_STUDIO SAP ABAP Report - Simple Browser for an Operational Data Provider







RODPS_SQL_STUDIO 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 RODPS_SQL_STUDIO 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 RODPS_SQL_STUDIO. "Basic submit
SUBMIT RODPS_SQL_STUDIO AND RETURN. "Return to original report after report execution complete
SUBMIT RODPS_SQL_STUDIO 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: P_CNTXT = ODP Context
Selection Text: P_MROWS = Maximum Number of Hits
Selection Text: P_NOTREX = Do Not Use TREX
Selection Text: P_TECHN = Technical name
Title: Simple Browser for an Operational Data Provider
Text Symbol: 001 = ODP-Based SQL
Text Symbol: 002 = Parameters
Text Symbol: 003 = No. of Data Records


INCLUDES used within this REPORT RODPS_SQL_STUDIO

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:

REUSE_ALV_GRID_DISPLAY CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING * I_INTERFACE_CHECK = ' ' * I_BYPASSING_BUFFER = ' ' * I_BUFFER_ACTIVE = ' ' * i_callback_program = sy-repid * i_callback_pf_status_set = 'SET_PF_STATUS' * i_callback_user_command = 'ALV_USER_COMMAND' * I_CALLBACK_TOP_OF_PAGE = ' ' * I_CALLBACK_HTML_TOP_OF_PAGE = ' ' * I_CALLBACK_HTML_END_OF_LIST = ' ' * I_STRUCTURE_NAME = * I_BACKGROUND_ID = ' ' * I_GRID_TITLE = * I_GRID_SETTINGS = is_layout = ls_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 = * it_event_exit = lt_event_exits * 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 * I_HTML_HEIGHT_TOP = 0 * I_HTML_HEIGHT_END = 0 * IT_ALV_GRAPHICS = * IT_HYPERLINK = * IT_ADD_FIELDCAT = * IT_EXCEPT_QINFO = * IR_SALV_FULLSCREEN_ADAPTER = * IMPORTING * E_EXIT_CAUSED_BY_CALLER = * ES_EXIT_CAUSED_BY_USER = TABLES t_outtab = EXCEPTIONS program_error = 1 OTHERS = 2 .

DDUT_DOMVALUE_TEXT_GET CALL FUNCTION 'DDUT_DOMVALUE_TEXT_GET' EXPORTING name = 'RODPS_SEGMENT_ROLE' value = l_value * LANGU = SY-LANGU texts_only = abap_true IMPORTING dd07v_wa = ls_dd07v EXCEPTIONS not_found = 1 illegal_input = 2 OTHERS = 3.

VRM_SET_VALUES CALL FUNCTION 'VRM_SET_VALUES' EXPORTING id = 'G_COMPNAME' values = gt_compnames.

RODPS_REPL_CONTEXT_GET_LIST CALL FUNCTION 'RODPS_REPL_CONTEXT_GET_LIST' TABLES et_context = lt_context.

VRM_SET_VALUES CALL FUNCTION 'VRM_SET_VALUES' EXPORTING id = 'P_CNTXT' values = lt_value EXCEPTIONS OTHERS = 0.



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