SAP Reports / Programs
QUERY_CHECK SAP ABAP Report - Query Check
QUERY_CHECK 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 QUERY_CHECK 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
QCHECK - Check Query
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 QUERY_CHECK. "Basic submit
SUBMIT QUERY_CHECK AND RETURN. "Return to original report after report execution complete
SUBMIT QUERY_CHECK VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
OLAP acceptance check for query definition
Selection Text: P_ERROR = Display Error Messages Only
Selection Text: G_SO_USR = Last Changed By
Selection Text: G_SO_OWN = Created By
Selection Text: G_SO_LUS = Last Used On
Selection Text: G_SO_ID = Query Technical Name
Selection Text: G_SO_IC = InfoProvider Technical Name
Selection Text: G_SO_DAT = Last Changed On
Selection Text: G_P_V7 = 7.x Version
Selection Text: G_P_V3 = 3.x Version
Selection Text: G_P_V = All Versions
Title: Query Check
Text Symbol: 040 = InfoProvider is not available in active version
Text Symbol: 039 = InfoProvider is inactive
Text Symbol: 038 = MultiProvider part not available
Text Symbol: 037 = BW 7.x
Text Symbol: 036 = BW 3.x
Text Symbol: 035 = All
Text Symbol: 034 = Technical Name
Text Symbol: 033 = InfoProvider
Text Symbol: 032 = Last Used On
Text Symbol: 031 = Last Changed On
Text Symbol: 030 = Last Changed By
Text Symbol: 029 = Created By
Text Symbol: 001 = Select Queries
Text Symbol: 002 = Selection Criteria
Text Symbol: 003 = Technical Name of Query
Text Symbol: 004 = Technical Name of InfoProvider
Text Symbol: 005 = Status
Text Symbol: 006 = Reading queries...
Text Symbol: 007 = Reading from table RSZELTXREF...
Text Symbol: 008 = Reading from table RSZELTDIR...
Text Symbol: 009 = Checking query:
Text Symbol: 011 = Technical name:
Text Symbol: 012 = Queries Selected:
Text Symbol: 013 = Queries With Errors:
Text Symbol: 014 = Queries Without Errors:
Text Symbol: 015 = No queries found for selection criteria
Text Symbol: 016 = Query definition is inconsistent
Text Symbol: 019 = InfoProvider is no longer available in the system
Text Symbol: 022 = Check completed.
Text Symbol: 023 = No errors found for selected queries.
Text Symbol: 024 = The program has detected problems with the definitions of some selected queries.
Text Symbol: 025 = Click the message icon to display the error details.
Text Symbol: 026 = Follow the instructions on how to adjust the query definition.
Text Symbol: 027 = Query Version
Text Symbol: 028 = Display Results
INCLUDES used within this REPORT QUERY_CHECK
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:
HELP_OBJECT_SHOW CALL FUNCTION 'HELP_OBJECT_SHOW' EXPORTING dokclass = 'NA' doklangu = sy-langu dokname = l_dokname doktitle = 'Long Text' "#EC NOTEXT msg_var_1 = l_s_msg-msgv1 msg_var_2 = l_s_msg-msgv2 msg_var_3 = l_s_msg-msgv3 msg_var_4 = l_s_msg-msgv3 TABLES links = l_links EXCEPTIONS object_not_found = 1 sapscript_error = 2 OTHERS = 3.
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = text-006.
RSZ_DB_COMP_LIST_GET CALL FUNCTION 'RSZ_DB_COMP_LIST_GET' EXPORTING i_deftp = rzd1_c_deftp-report i_objvers = rs_c_objvers-active IMPORTING e_th_complist = g_th_components EXCEPTIONS OTHERS = 0.
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = text-007.
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = text-008.
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = l_message.
RRMS_MESSAGE_OFF_RESET CALL FUNCTION 'RRMS_MESSAGE_OFF_RESET'.
RSZ_X_COMPONENT_GET CALL FUNCTION 'RSZ_X_COMPONENT_GET' EXPORTING i_compuid =
-compuid i_designtime_call = rs_c_false IMPORTING e_subrc = l_subrc TABLES c_t_eltdir = l_t_eltdir c_t_eltprop = l_t_eltprop c_t_eltprio = l_t_eltprio c_t_eltattr = l_t_eltattr c_t_eltxref = l_t_eltxref c_t_compdir = l_t_compdir c_t_compic = l_t_compic c_t_select = l_t_select c_t_range = l_t_range c_t_calc = l_t_calc c_t_cell = l_t_cel c_t_var = l_t_var c_t_uid_server = l_t_uid_server EXCEPTIONS OTHERS = 1.
RSZ_X_MESSAGES_GET CALL FUNCTION 'RSZ_X_MESSAGES_GET' TABLES e_t_mesg = l_t_msg.
RSZ_X_QUERY_CHECK CALL FUNCTION 'RSZ_X_QUERY_CHECK' EXPORTING i_compuid =
-compuid IMPORTING e_subrc = l_subrc TABLES c_t_eltdir = l_t_eltdir c_t_eltprop = l_t_eltprop c_t_eltprio = l_t_eltprio c_t_eltattr = l_t_eltattr c_t_eltxref = l_t_eltxref c_t_compdir = l_t_compdir c_t_compic = l_t_compic c_t_select = l_t_select c_t_range = l_t_range c_t_calc = l_t_calc c_t_cell = l_t_cel c_t_var = l_t_var.
RSZ_X_MESSAGES_GET CALL FUNCTION 'RSZ_X_MESSAGES_GET' TABLES e_t_mesg = l_t_msg.
RRMS_MESSAGE_OFF CALL FUNCTION 'RRMS_MESSAGE_OFF'.
RSZ_DB_COMP_EXIST CALL FUNCTION 'RSZ_DB_COMP_EXIST' EXPORTING i_return_deftp = i_queries_only "want to have...
CALL FUNCTION 'RRMS_MESSAGE_OFF_RESET'.
RRMS_MESSAGE_OFF CALL FUNCTION 'RRMS_MESSAGE_OFF'.
RRMS_MESSAGE_OFF_RESET CALL FUNCTION 'RRMS_MESSAGE_OFF_RESET'.
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 QUERY_CHECK or its description.