Providing TCode to SAP SQ01 query-generated program

479 Views Asked by At

There is a client-specific query (SQ01) in all three clients, DEVELOPMENT, QUALITY and PRODUCTION. The query is exactly same in QUALITY and PRODUCTION clients. But there are some changes in DEVELOPMENT client. I have to create a new transaction code and put the query generated report under that TCode. The name of the query-generated program is same in all the clients.

My question is, if I create a TCode in DEVELOPMENT client, put the query-generated report under it, and move this to QUALITY, then the changes of DEVELOPMENT client query report will change the query-generated report of QUALITY client or not?

If yes, then suggest some other way of creating a TCode and putting the query-generated report under it. I want the query report under the TCode as it is in QUALITY and PRODUCTION.

1

There are 1 best solutions below

2
József Szikszai On

By creating a transaciton code for an ABAP Query, a different approach has to be followed:

Start SE93, enter the transaction code, a description and choose "Transaction with parameters..." (the last option).

enter image description here

The transaction has to be: "START_REPORT" and select the checkbock "Skip initial screen"

enter image description here

Scroll to the bottom and three parameters have to be entered. The first one is: Name: D_SREPOVARI-REPORTTYPE Value: AQ

enter image description here

And then the name and the user group from your query have to be entered: Name: D_SREPOVARI-REPORT Value: The user group from SQ03 and Name: D_SREPOVARI-EXTDREPORT Value: Query name from SQ01

enter image description here

Following this approach, the query will be executed correctly in all systems (DEV, QUALITY, PROD), despite the different names of the program behind the query.