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

RSAQCOPY SAP ABAP Report - SAP Query: Special Copy Functions







RSAQCOPY is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Special copy function for SAP Query This report has special copy functions that offer more than the normal copy functions within the individual areas of SAP Query...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 RSAQCOPY 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 RSAQCOPY. "Basic submit
SUBMIT RSAQCOPY AND RETURN. "Return to original report after report execution complete
SUBMIT RSAQCOPY 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: DEST_IS = InfoSet (Target)
Selection Text: DEST_UGR = User Group (Target)
Selection Text: DST_QUNA = Query Name
Selection Text: DST_UGR = User Group (Target)
Selection Text: SEL_UGR = Queries from User Groups
Selection Text: TESTMODE = Test Run
Selection Text: TMP_ISET = Prefix for Copied InfoSet
Selection Text: TMP_QUNA = Prefix for Copied Queries
Selection Text: USERGRP = User Group (Source)
Selection Text: PA_WSID = Global Query Area
Selection Text: QUNAME = Query (Source)
Selection Text: QU_ISET = Assigned InfoSet
Selection Text: SC_IS = InfoSet (Source)
Selection Text: SC_UGR = User Group (Source)
Title: SAP Query: Special Copy Functions
Text Symbol: 180 = InfoSet $ is not assigned to target user group $
Text Symbol: 172 = Query is locked by user $
Text Symbol: 012 = Copy InfoSet with Queries
Text Symbol: 010 = Copy User Group with InfoSets and Queries
Text Symbol: 004 = Copy Function
Text Symbol: 002 = Copy in User Group
Text Symbol: 001 = Settings
Text Symbol: 130 = Target query $ of user group $ already exists
Text Symbol: 120 = Query $ does not exist
Text Symbol: 110 = Error when locking query
Text Symbol: 100 = Error when importing query
Text Symbol: 014 = Copy Query with Changed InfoSet
Text Symbol: 193 = Target InfoSet $ already exists
Text Symbol: 213 = InfoSet catalog cannot be read
Text Symbol: 212 = User group catalog cannot be read
Text Symbol: 210 = Copied user group $
Text Symbol: 209 = InfoSet $ cannot be copied
Text Symbol: 206 = Error when calling up corrections to the system (user group $)
Text Symbol: 235 = User group $ was successfully copied to user group $
Text Symbol: 231 = The user group was not copied
Text Symbol: 230 = InfoSet $ has been successfully copied to InfoSet $
Text Symbol: 220 = User group catalog is locked by $
Text Symbol: 214 = Error when copying InfoSet $





Text Symbol: 200 = User group $ does not exist
Text Symbol: 197 = InfoSet catalog could not be locked
Text Symbol: 196 = Therefore copying is not possible
Text Symbol: 195 = Query $ contains errors that are not defined in InfoSet $
Text Symbol: 194 = Source InfoSet $ is not generated or is locked (you may have to regenerate it)
Text Symbol: 205 = User group catalog is locked by $
Text Symbol: 204 = Error when calling up correction system (InfoSet $)
Text Symbol: 203 = The name $ is not permitted
Text Symbol: 202 = Target user group $ already exists
Text Symbol: 201 = The name $ is not permitted
Text Symbol: 190 = InfoSet $ could not be loaded
Text Symbol: 281 = however, the InfoSet assigned to it has not
Text Symbol: 280 = The query has been defined using a logical database,
Text Symbol: 272 = (Function 'Compare' in query maintenance transaction)
Text Symbol: 271 = Compare the Query $
Text Symbol: 270 = There are differences between InfoSet and Query
Text Symbol: 600 = Copy query $ from user group $ in global area
Text Symbol: 240 = Test mode only (not written to database)
Text Symbol: 250 = Query $ uses InfoSet $ and was not copied
Text Symbol: 256 = InfoSet $ was successfully copied
Text Symbol: 261 = Error or termination when writing correction record
Text Symbol: 263 = Error or termination when writing correction record (query $)
Text Symbol: 333 = Error when calling up correction system (query $)
Text Symbol: 334 = Query $ has been added
Text Symbol: 335 = Error when copying query report $ with variants
Text Symbol: 336 = Error when copying variants (report name $)
Text Symbol: 340 = User group $ queries
Text Symbol: 612 = Copy user group $ in standard area
Text Symbol: 611 = Copy InfoSet $ in standard area
Text Symbol: 610 = Copy query $ of user group $ in standard area
Text Symbol: 602 = Copy user group $ in global area
Text Symbol: 601 = Copy InfoSet $ in global area
Text Symbol: 282 = It is therefore not possible to assign InfoSet $ to query $
Text Symbol: 284 = The query has not been defined using a logical database
Text Symbol: 285 = but the InfoSet assigned to it has.
Text Symbol: 320 = InfoSet or user group assignment cannot be read
Text Symbol: 321 = Target query $ already exists
Text Symbol: 170 = An error has occurred when copying query
Text Symbol: 161 = Error when assigning the user group to InfoSet $





Text Symbol: 160 = InfoSet $ is not assigned to user group $
Text Symbol: 150 = Target user group $ is not assigned to InfoSet $
Text Symbol: 140 = User group/InfoSet catalog cannot be read when copying
Text Symbol: 192 = Source InfoSet $ is not available
Text Symbol: 191 = Query $ could not be loaded


INCLUDES used within this REPORT RSAQCOPY

INCLUDE RSAQCOMC.
INCLUDE RSAQCOM0.
INCLUDE RSAQCOM1.
INCLUDE RSAQCOM2.
INCLUDE RSAQIEXQ.
INCLUDE RSAQIEXB.
INCLUDE RSAQIEXS.
INCLUDE RSAQENQQ.
INCLUDE RSAQENQS.
INCLUDE RSAQENQB.


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 = pa_wsid sug_superuser = 'X' importing sug_usergroup = sc_ugr.

RSAQSUG_SELECT_USERGROUP call function 'RSAQSUG_SELECT_USERGROUP' exporting sug_workspace = pa_wsid sug_superuser = 'X' importing sug_usergroup = dest_ugr.

RSAQSUL_SELECT_FUNC_AREA call function 'RSAQSUL_SELECT_FUNC_AREA' exporting sul_workspace = pa_wsid sul_transcode = 'SQ02' importing sul_func_area = sc_is.

RSAQSUL_SELECT_FUNC_AREA call function 'RSAQSUL_SELECT_FUNC_AREA' exporting sul_workspace = pa_wsid sul_transcode = 'SQ02' importing sul_func_area = dest_is.

RSAQSUG_SELECT_USERGROUP call function 'RSAQSUG_SELECT_USERGROUP' exporting sug_workspace = pa_wsid sug_superuser = 'X' importing sug_usergroup = sel_ugr-low.

RSAQSUG_SELECT_USERGROUP call function 'RSAQSUG_SELECT_USERGROUP' exporting sug_workspace = pa_wsid sug_superuser = 'X' importing sug_usergroup = sel_ugr-high.

RSAQSUG_SELECT_USERGROUP call function 'RSAQSUG_SELECT_USERGROUP' exporting sug_workspace = pa_wsid sug_superuser = 'X' importing sug_usergroup = usergrp.

RSAQSUG_SELECT_USERGROUP call function 'RSAQSUG_SELECT_USERGROUP' exporting sug_workspace = pa_wsid sug_superuser = 'X' importing sug_usergroup = dst_ugr.

RSAQSQU_SELECT_QUERY call function 'RSAQSQU_SELECT_QUERY' exporting squ_workspace = pa_wsid squ_user_group_in = usergrp squ_complete = space squ_tcode = 'SQ00' squ_hflag = 'X' importing squ_query_out = quname squ_user_group_out = usergrp squ_rcode = l_flag.

RSAQSQU_SELECT_QUERY call function 'RSAQSQU_SELECT_QUERY' exporting squ_workspace = pa_wsid squ_user_group_in = dst_ugr squ_complete = space squ_tcode = 'SQ00' squ_hflag = space importing squ_query_out = dst_quna squ_user_group_out = dst_ugr squ_rcode = l_flag.

RSAQSUL_SELECT_FUNC_AREA call function 'RSAQSUL_SELECT_FUNC_AREA' exporting sul_workspace = pa_wsid sul_transcode = 'SQ02' importing sul_func_area = qu_iset.




RSAQ_CHECK_OBJECT_NAME call function 'RSAQ_CHECK_OBJECT_NAME' exporting workspace = pa_wsid object_name = dest_ugr object_type = 'B' exceptions illegal_name = 1 illegal_namespace = 2 others = 3.

RSAQ_REPORT_NAME call function 'RSAQ_REPORT_NAME' exporting workspace = pa_wsid usergroup = dest_ugr query = qucat-qnum importing reportname = new_reportname.

RSAQ_CHECK_OBJECT_NAME call function 'RSAQ_CHECK_OBJECT_NAME' exporting workspace = pa_wsid object_name = dest_name object_type = 'Q' exceptions illegal_name = 1 illegal_namespace = 2 others = 3.

RSAQ_REPORT_NAME call function 'RSAQ_REPORT_NAME' exporting workspace = p_workspace usergroup = p_usergroup query = p_sourcename importing reportname = old_reportname.

RSAQ_REPORT_NAME call function 'RSAQ_REPORT_NAME' exporting workspace = p_workspace usergroup = p_target_usergroup query = p_targetname importing reportname = new_reportname.

RSAQ_DELETE_QUERY_REPORT * call function 'RSAQ_DELETE_QUERY_REPORT' * exporting * reportname = p_new_reportname.

RS_TEXTLOG_GET_PARAMETERS * call function 'RS_TEXTLOG_GET_PARAMETERS' * importing * masterlanguages = master_languages.

RS_COPY_SELECTION_SETS * call function 'RS_COPY_SELECTION_SETS' * exporting * source_report = p_old_reportname * target_report = p_new_reportname * exceptions * others = 1.

RSAQ_COPY_QUERY_REPORT CALL FUNCTION 'RSAQ_COPY_QUERY_REPORT' EXPORTING REPORTNAME = p_old_reportname NEW_REPORTNAME = p_new_reportname EXCEPTIONS NO_REPORT = 1 OTHERS = 2 .

TR_SYS_PARAMS call function 'TR_SYS_PARAMS' importing systemtype = systype.



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