SAP Reports / Programs | Basis Components | Basis Services / Communication Interfaces | SAP Query(BC-SRV-QUE) SAP BC

RSAQ_WEBRELEASE SAP ABAP Report - SAP Query: Administration for Web Reporting







RSAQ_WEBRELEASE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program releases InfoSet Queries for the Internet/Intranet...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter RSAQ_WEBRELEASE 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

SQ11 - SAP Query: Web reporting (Admin)


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 RSAQ_WEBRELEASE. "Basic submit
SUBMIT RSAQ_WEBRELEASE AND RETURN. "Return to original report after report execution complete
SUBMIT RSAQ_WEBRELEASE 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: LAYOUT = Layout
Selection Text: FONTSIZE = Font Size
Selection Text: AUTHGRP = Authorization Group
Selection Text: P_QUER = Query
Selection Text: WS_STAND = Standard Area
Selection Text: WS_GLOB = Global Area
Selection Text: VARIANT = Variant
Selection Text: S_UGRP = User Group
Selection Text: S_QUER = Query
Selection Text: S_ISET = InfoSet
Selection Text: ROLE = Role
Selection Text: P_UGRP = User Group
Selection Text: P_ROLE = Role
Title: SAP Query: Administration for Web Reporting
Text Symbol: 102 = ERROR:InfoSet Has No Authorization Group
Text Symbol: 103 = ERROR:Query Report Does Not Exist
Text Symbol: 018 = Choose a role/user group first
Text Symbol: 009 = Work Area
Text Symbol: 010 = No action selected
Text Symbol: 011 = InfoSets: Specify Authorization Group
Text Symbol: 012 = Queries: Release for Internet/Intranet
Text Symbol: 113 = Layout Variant Not Available
Text Symbol: 112 = Selection Variant Not Available
Text Symbol: 111 = Variants Error
Text Symbol: 013 = Queries: Generate URLs for ITS
Text Symbol: 014 = Function only available from Release R/3 Basis 4.6C
Text Symbol: 015 = Font size nust be between 7 and 11 pts
Text Symbol: 016 = Query &1 does not exist
Text Symbol: 017 = Role &1 not assigned
Text Symbol: 110 = ERROR:InfoSet ALready Contains Authorization Group
Text Symbol: 108 = Adjusted
Text Symbol: 107 = Locked By User
Text Symbol: 106 = Query
Text Symbol: 105 = Authorization Group Entered
Text Symbol: 104 = ERROR:InfoSet Locked By User
Text Symbol: L10 = InfoSet
Text Symbol: U06 = Use ALV Layout
Text Symbol: U05 = Use Selection Variant





Text Symbol: U04 = MiniALV
Text Symbol: L11 = Comment
Text Symbol: L12 = User Group
Text Symbol: L13 = Authorization Group
Text Symbol: U01 = Output with...
Text Symbol: U02 = MidiALV Without Selection Screen
Text Symbol: U03 = MidiALV With Selection Screen
Text Symbol: 100 = ERROR: Could Not Generate Query Reports
Text Symbol: U18 = Edit URL
Text Symbol: U19 = Specify Query and Role
Text Symbol: U20 = ITS Web Server
Text Symbol: U22 = Options
Text Symbol: U23 = Export URL to Clipboard
Text Symbol: U24 = Style
Text Symbol: U25 = With Scroller
Text Symbol: U26 = With Scroll Keys
Text Symbol: U27 = Text Only
Text Symbol: U17 = Or
Text Symbol: U08 = pt
Text Symbol: U09 = Column Heading
Text Symbol: U10 = Small
Text Symbol: U11 = Medium
Text Symbol: U12 = Large
Text Symbol: U13 = Hide Shuffler
Text Symbol: U14 = Hide Title
Text Symbol: U15 = Generate URL with Placeholders for Workplace
Text Symbol: U16 = Start Browser with URL
Text Symbol: U28 = WAP Style
Text Symbol: U30 = General Options
Text Symbol: U31 = Service Parameter
Text Symbol: U32 = MiniALV-specific
Text Symbol: U34 = No. of Displayed Rows (Only with Scroll Keys)
Text Symbol: U07 = Set Font Size
Text Symbol: 030 = Released!
Text Symbol: 031 = Cancel Release
Text Symbol: 032 = Query has not been released for the Internet!
Text Symbol: 033 = Query has already been released!
Text Symbol: 040 = Authorization Group & included in InfoSet(s)
Text Symbol: 041 = Release Queries/Cancel Release





INCLUDES used within this REPORT RSAQ_WEBRELEASE

INCLUDE: RSAQCOMC,
RSAQCOM1,
RSAQCOM2,
RSAQCOM0.


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:

RSAQSUG_SELECT_USERGROUP call function 'RSAQSUG_SELECT_USERGROUP' exporting sug_workspace = act_workspace sug_superuser = 'X' importing sug_usergroup = s_ugrp-low.

RSAQSUG_SELECT_USERGROUP call function 'RSAQSUG_SELECT_USERGROUP' exporting sug_workspace = act_workspace sug_superuser = 'X' importing sug_usergroup = p_ugrp.

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

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

RSAQSUG_SELECT_USERGROUP call function 'RSAQSUG_SELECT_USERGROUP' exporting sug_workspace = act_workspace sug_superuser = 'X' importing sug_usergroup = s_ugrp-high.

RSAQSUL_SELECT_FUNC_AREA call function 'RSAQSUL_SELECT_FUNC_AREA' exporting sul_workspace = act_workspace sul_transcode = 'SQ02' importing sul_func_area = s_iset-low.

RSAQSUL_SELECT_FUNC_AREA call function 'RSAQSUL_SELECT_FUNC_AREA' exporting sul_workspace = act_workspace sul_transcode = 'SQ02' importing sul_func_area = s_iset-high.

RSAQ_REMOTE_FUNCAREA_CATALOG call function 'RSAQ_REMOTE_FUNCAREA_CATALOG' exporting workspace = act_workspace with_system_objects = 'X' tables funcareacatalog = l_sucat.

REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING I_PROGRAM_NAME = l_repid I_INTERNAL_TABNAME = l_alv_outtabname I_STRUCTURE_NAME = p_alv_struc * I_CLIENT_NEVER_DISPLAY = 'X' * I_INCLNAME = * I_BYPASSING_BUFFER = * I_BUFFER_ACTIVE = CHANGING ct_fieldcat = l_alv_fieldcat * EXCEPTIONS * INCONSISTENT_INTERFACE = 1 * PROGRAM_ERROR = 2 * OTHERS = 3 .

REUSE_ALV_GRID_DISPLAY call function 'REUSE_ALV_GRID_DISPLAY' exporting * I_INTERFACE_CHECK = ' ' * I_BUFFER_ACTIVE = ' ' i_callback_program = l_repid i_callback_pf_status_set = l_alv_cb_status i_callback_user_command = p_alv_callback i_structure_name = p_alv_struc is_layout = l_alv_layout IT_FIELDCAT = l_alv_fieldcat i_grid_title = l_alv_title * IT_EXCLUDING = * IT_SPECIAL_GROUPS = * IT_SORT = * IT_FILTER = * IS_SEL_HIDE = * I_DEFAULT = 'X' * I_SAVE = ' ' * IS_VARIANT = * IT_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 = p_alv_outtab EXCEPTIONS * PROGRAM_ERROR = 1 OTHERS = 1 .

RSAQ_REMOTE_USERGROUP_CATALOG call function 'RSAQ_REMOTE_USERGROUP_CATALOG' exporting workspace = act_workspace with_system_objects = 'X' tables usergroupcatalog = l_bgcat.

RSAQ_REMOTE_QUERY_CATALOG call function 'RSAQ_REMOTE_QUERY_CATALOG' exporting workspace = act_workspace generic_usergroup = -num with_system_objects = 'X' tables querycatalog = l_qucat.

RSAQ_CREATE_QUERY_REPORT call function 'RSAQ_CREATE_QUERY_REPORT' exporting workspace = act_workspace usergroup = p_qucat-num query = p_qucat-query importing reportname = l_reportname exceptions others = 1.

RSAQ_REPORT_NAME CALL FUNCTION 'RSAQ_REPORT_NAME' exporting workspace = act_workspace usergroup = p_qucat-num query = p_qucat-query IMPORTING REPORTNAME = l_reportname.

RS_WORKBENCH_CUSTOMIZING call function 'RS_WORKBENCH_CUSTOMIZING' exporting choice = 'WB' suppress_dialog = 'X' importing setting = wb_setting.

CALL_BROWSER call function 'CALL_BROWSER' exporting url = url_clip * WINDOW_NAME = ' ' * BROWSER_TYPE = * CONTEXTSTRING = EXCEPTIONS OTHERS = 1.

RSAQ_REPORT_NAME



call function 'RSAQ_REPORT_NAME' exporting workspace = act_workspace usergroup = p_ugrp query = p_quer importing reportname = l_reportname.

RS_VARIANT_EXISTS call function 'RS_VARIANT_EXISTS' exporting report = l_reportname variant = variant importing r_c = l_subrc exceptions * NOT_AUTHORIZED = 1 no_report = 2 report_not_existent = 3 * REPORT_NOT_SUPPLIED = 4 others = 5.

RSAQ_CREATE_QUERY_REPORT call function 'RSAQ_CREATE_QUERY_REPORT' exporting workspace = act_workspace usergroup = p_ugrp query = p_quer importing reportname = l_reportname exceptions others = 1.

RS_VARIANT_EXISTS call function 'RS_VARIANT_EXISTS' exporting report = l_reportname variant = variant importing r_c = l_subrc exceptions no_report = 2 report_not_existent = 3 others = 5.

RSAQ_CREATE_QUERY_REPORT call function 'RSAQ_CREATE_QUERY_REPORT' exporting workspace = act_workspace usergroup = p_ugrp query = p_quer importing reportname = l_reportname exceptions others = 1.

REUSE_ALV_VARIANT_EXISTENCE call function 'REUSE_ALV_VARIANT_EXISTENCE' * EXPORTING * I_SAVE = ' ' changing cs_variant = l_disvariant EXCEPTIONS OTHERS = 1.

DYNP_VALUES_READ call function 'DYNP_VALUES_READ' exporting dyname = l_program dynumb = '3001' translate_to_upper = 'X' * REQUEST = ' ' * PERFORM_CONVERSION_EXITS = ' ' * PERFORM_INPUT_CONVERSION = ' ' * DETERMINE_LOOP_INDEX = ' ' tables dynpfields = l_dynpfield exceptions others = 1.

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



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