How to import queries

[Former Member]

Hi,

How to import queries once User group moved to PRD.

Chinna.

Edited by: Chinna on Sep 17, 2008 8:05 AM

[Former Member]

Done.

[suzy_bijnens]

Hi,

I always use SE38 RSAQR3TR

Regards,

Suzy

[Former Member]

You must have an appropriate user group and an appropriate InfoSet in the target client in order to import a query. You also need the InfoSet to be assigned to the user group. Example:

1. SQ02 Environment > Transports (truck)

a) Click Export and Transport user group and the name of User group, then execute (you can click "Test run" to see the log before you execute).

Check the log.

This will generate a Transport of User group components to the table AQTDB.

b) Click Export and Transport InfoSets and queries and the name of Infoset and query, then execute.

c) Release the transports in SE09 (Transport organizer)

2. When transports are completed in QA environment:

SQ02 Environment > Transports

a) Click Import and enter the transport request in "Dataset with imports"

b) Do the same for each query transport.

[Former Member]

Hi,

1. First of all go sq01 from the system where your query works fine and from where your have to transport that query to PRD system.

2. Go to Environment --> Query Areas -->select Standard Area

3. Go to Edit --> other user group and select user group in which query was created.

4. Go to Environment --> Infosets

5. Now click truck button

6. Click download radio button in the transport action selection. and in transport option selection select transport quries radio button.

7. write down the user groups and query name and press F8

8. It will create query file, save it to your machine.

Now login into PRD system. and repeat step 1 to 5.

In step 6 instead of download select upload radio button and repeat remaining steps as it is.

It will import the query to PRD system.

after that go to sq01 and write down query name in the query.

go to query --> more function --> generate program

It will generate program for that query. You have to use that program name in your tcode.

[Former Member]

Hi,

Pls see the below link.

http://help.sap.com/saphelp_sm32/helpdata/en/d2/cb46da455611d189710000e8322d00/content.htm

Anil

[Former Member]

sorry satya its not useful for me in this case.

Thanks for your reply.