08-04-2009 3:08 PM
Hi All- I want to assign a trasaction code to sap query that was created using SQ01. I can do it by SE93. My question is does the program name change when the query is transported? Is there any other way to do it? In my previous project they did it from PFCG.
08-04-2009 3:24 PM
Hi,
The above solution will work if you assign the transaction in one server, If you want this will not work in quality/production boxes when transported the query..the program name will not be the same in all the servers...
For this. Do the below:
In SE93, Create a Paramter Transaction
-> Transaction = Start_report
-> In default values, give the below details:
D_SREPOVARI-REPORTTYPE = AQ
D_SREPOVARI-EXTDREPORT = Name of the Query
D_SREPOVARI-REPORT = User Group
Save the transaction..Now if the program is generated with different names in the quality/proudction, this will still work..
Regards
Shiva
08-04-2009 3:16 PM
Hi,
In the menu for SQ01->Query->More Functions->Display Program Name
If you cant find the name, Generate the program name: SQ01->Query->More Functions->Generate Program
Then check the program name from menu.
You will get the name of the program from there...
Now goto SE93 and assign the trnasaction code for the report program generated above.
Hope this helps
Regards
Shiva
Edited by: Shiva Kumar Tirumalasetty on Aug 4, 2009 7:46 PM
08-04-2009 3:24 PM
Hi,
The above solution will work if you assign the transaction in one server, If you want this will not work in quality/production boxes when transported the query..the program name will not be the same in all the servers...
For this. Do the below:
In SE93, Create a Paramter Transaction
-> Transaction = Start_report
-> In default values, give the below details:
D_SREPOVARI-REPORTTYPE = AQ
D_SREPOVARI-EXTDREPORT = Name of the Query
D_SREPOVARI-REPORT = User Group
Save the transaction..Now if the program is generated with different names in the quality/proudction, this will still work..
Regards
Shiva
06-04-2013 2:39 PM
Hi,
I am having the same issue. I tried the solution in our DEV client, and it seems to be working. But, when I created the new TCode, the system did not give me a transport number.
How do I transport the new TCode to QAS and then to PRD?
Your assistance is greatly appreciated.
Regards,
J. Brewer
07-19-2013 9:17 PM
Hi John
It sounds strange, the system should give you transport request number.
But if you don't have, you can manually create one and include your TCode in it.
With SE09, you create a TR, also create a Development/Correction task under it.
Open the task by double clicking it, switch to edit mode, then give below values and save:
Program ID = R3TR
Object Type = TRAN
Object Name = Z_YOUR_TCODE
Regards
John Lu
03-03-2015 12:43 PM
Hi All,
I have a program name AQCSSYSTQV000006Z_ASSETS======.
I want to find the User Group, Infoset and the query name for the particular program.
Can anyone tell me how can I find those details in Development.
Regards,
Ashish
03-03-2015 12:51 PM
02-23-2016 5:57 AM
Hi
I think following information is more appropriate.
D_SREPOVARI-REPORTTYPE "AQ"
D_SREPOVARI-REPORT "USER GROUP" + "Space" + "G"
*if User Group is Global Area, we need set "G" at 13th characters.
D_SREPOVARI-EXTDREPORT "Query Name"
[Example]
D_SREPOVARI-REPORTTYPE "AQ"
D_SREPOVARI-REPORT "MM G"
D_SREPOVARI-EXTDREPORT "MM0001"
Regards,
03-15-2016 11:05 AM
Yes you are right; for Global Query Area,
13th Character of the D_SREPVARI-REPORT should be 'G' like 'ZHR G'
Thanks for sharing this.