TR for SQL query

[kiran_k8]

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.

[Former Member]

Hi

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

Regards

Shiva

[kiran_k8]

Hi,

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

Thanks,

K.Kiran.

[JozsefSzikszai]

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

ec

[kiran_k8]

Transport Request not T code.

[JozsefSzikszai]

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)

[kiran_k8]

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.

[JozsefSzikszai]

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

[Former Member]

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...