topic Re: Assign transaction code to SAP Query (created via SQ01) in Application Development and Automation Discussions

Assign transaction code to SAP Query (created via SQ01)

former_member214999 — Tue, 04 Aug 2009 14:08:22 GMT

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.

Re: Assign transaction code to SAP Query (created via SQ01)

Former Member — Tue, 04 Aug 2009 14:16:35 GMT

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

Re: Assign transaction code to SAP Query (created via SQ01)

Former Member — Tue, 04 Aug 2009 14:24:32 GMT

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

Re: Assign transaction code to SAP Query (created via SQ01)

Former Member — Tue, 04 Jun 2013 13:39:13 GMT

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

Re: Assign transaction code to SAP Query (created via SQ01)

Former Member — Fri, 19 Jul 2013 20:17:56 GMT

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

Re: Assign transaction code to SAP Query (created via SQ01)

Former Member — Tue, 03 Mar 2015 12:43:05 GMT

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

Re: Assign transaction code to SAP Query (created via SQ01)

jogeswararao_kavala — Tue, 03 Mar 2015 12:51:42 GMT

Start a new discussion. You might get responses.

Re: Assign transaction code to SAP Query (created via SQ01)

Former Member — Tue, 23 Feb 2016 05:57:53 GMT

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,

Re: Assign transaction code to SAP Query (created via SQ01)

Former Member — Tue, 15 Mar 2016 11:05:18 GMT

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.