Assign transaction code to SAP Query (created via SQ01)

[former_member214999]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[adholi]

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

[jogeswararao_kavala]

Start a new discussion. You might get responses.

[Former Member]

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,

[Former Member]

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.