topic Re: TR for SQL query in Application Development and Automation Discussions

TR for SQL query

kiran_k8 — Thu, 31 Jan 2008 04:52:57 GMT

Hi,

I have a query which I want to attach it to a tcode and then move to quality as well as production.I am getting the program name for the query from the additional functions options under the Quick View in the menu bar of SQVI.The same I am using to create a tcode.How to create a transport request for the query as well as this program.Can I assign the same program which is AQA0SYSTQV000015ZMI===== to a package?

Thanks,

K.Kiran.

Re: TR for SQL query

Former Member — Thu, 31 Jan 2008 04:54:46 GMT

You can assign the TR for the same and to create t code also you can use the system generated report name

Regards

Shiva

Re: TR for SQL query

kiran_k8 — Fri, 01 Feb 2008 07:56:18 GMT

Hi,

Can anyone here please let me know how to create a TR for a SQL query.

Thanks,

K.Kiran.

Re: TR for SQL query

JozsefSzikszai — Fri, 01 Feb 2008 08:12:03 GMT

hi Kiran,

tcode for query, pls. have a look:

Create a transaction calling transaction START_REPORT with the following parameters/attributes filled :

D_SREPOVARI-REPORTTYPE= AQ "parameter indicating Abap Query

D_SREPOVARI-REPORT= 'ZGRP' "Query User group

D_SREPOVARI-EXTDREPORT= 'ZNAME' "Query name

to transport queries, pls. use the following program: RSAQR3TR

you have to follow the following steps:

1. With the above program, choose Export and add the objects you want to transport. after execution you get a transport request from the system.

2. Release this transport request

3. Import this transport request into the target system (like any other transport request)

4. In the target system run the above program, but choose Import now and add the transport request name

hope this helps

Re: TR for SQL query

kiran_k8 — Fri, 01 Feb 2008 08:22:34 GMT

Transport Request not T code.

Re: TR for SQL query

JozsefSzikszai — Fri, 01 Feb 2008 08:29:14 GMT

I wish you would read my whole answer... The fiirst half is about the tcode, the second half about how to transport queries.

To transport queries.... and then you get the steps (I provided the tcode only, because you got wrong information before - as it usually happens in these Expert forums)

Re: TR for SQL query

Former Member — Fri, 01 Feb 2008 08:29:25 GMT

Kiran,

You can do it with program: RSAQR3TR

Execute RSAQR3TR.

Radio Button which has below columns

1. Transport InfoSets and quer

2. InfoSets

3. Queries

Enter the names

Execute it.

Don't forget to reward if useful...

Re: TR for SQL query

kiran_k8 — Fri, 01 Feb 2008 09:25:39 GMT

Eric,

Sorry.

I had already created a tcode and assgined the report name of the query.This tcode got transported to Quality.

Now to transport the query I am using RSAQR3TR

EXPORT

TRANSPORT QUERIES

it is giving me an message no objects found.

Where I am going wrong.

K.Kiran.

Re: TR for SQL query

JozsefSzikszai — Fri, 01 Feb 2008 09:52:33 GMT

be sure you enter correct name for the query and for the user group as well!