SAP Reports / Programs

SAP_QUERY_AD_HOC_ROLE SAP ABAP Report - Role Call-up SAP Query for Ad Hoc Reporting







SAP_QUERY_AD_HOC_ROLE 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 SAP_QUERY_AD_HOC_ROLE 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

SQ_DEMO_ADHOC - Demo: Start InfoSet Query (Ad Hoc)


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 SAP_QUERY_AD_HOC_ROLE. "Basic submit
SUBMIT SAP_QUERY_AD_HOC_ROLE AND RETURN. "Return to original report after report execution complete
SUBMIT SAP_QUERY_AD_HOC_ROLE 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_QUNAME = Query
Selection Text: P_ROLE = Role
Selection Text: P_SGNAME = InfoSet
Title: Role Call-up SAP Query for Ad Hoc Reporting


INCLUDES used within this REPORT SAP_QUERY_AD_HOC_ROLE

INCLUDE RSAQCOMC.


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:

RS_SUBMIT_INFO call function 'RS_SUBMIT_INFO' importing p_submit_info = subinfo.

SAP_QUERY_AD_HOC_ROLE call function 'SAP_QUERY_AD_HOC_ROLE' exporting i_role = p_role i_infoset = p_sgname i_query = p_quname i_check_only = 'X' i_user_check = space exceptions others = 1.

SAP_QUERY_AD_HOC_ROLE call function 'SAP_QUERY_AD_HOC_ROLE' exporting i_role = p_role i_infoset = p_sgname i_query = p_quname i_check_only = 'X' i_user_check = 'X' exceptions others = 1.

SAP_QUERY_AD_HOC_ROLE call function 'SAP_QUERY_AD_HOC_ROLE' exporting i_role = p_role i_infoset = p_sgname i_query = p_quname exceptions others = 1.

PRGN_F4_HELP_FOR_AGR call function 'PRGN_F4_HELP_FOR_AGR' exporting ranges_parameter_for_select = p_role importing agr_name = p_role.

RS_SELECTIONSCREEN_READ call function 'RS_SELECTIONSCREEN_READ' exporting program = l_program tables fieldvalues = l_selvalues.

RSAQSUL_SELECT_FUNC_AREA call function 'RSAQSUL_SELECT_FUNC_AREA' exporting sul_workspace = l_workspace sul_queryname = 'XXX' sul_transcode = 'SQ01' sul_usergroup = l_usergroup importing sul_func_area = p_infoset.

RS_SELECTIONSCREEN_READ call function 'RS_SELECTIONSCREEN_READ' exporting program = l_program tables fieldvalues = l_selvalues.

RSAQSQU_SELECT_QUERY call function 'RSAQSQU_SELECT_QUERY' exporting squ_workspace = l_workspace squ_user_group_in = l_usergroup squ_complete = space squ_tcode = 'SQ00' squ_hflag = 'X' importing squ_query_out = p_query.



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