SQ01 -Unable to upload query

[Former Member]

Dear Experts,

I had tried to upload query in QA Client after downloading it from DEV Client. But still I am unable to find query in QA client. I can only see User Group & infoset which are uploaded successfully. I checked in both standard & Global areas of query, but only I found are user group & infoset which I had created in DEV Client. I had followed the following steps to upload & download. Please correct me if I did anything wrong. Please suggest..

DOWNLOAD ABAP QUERY ( From DEV Client )

1. Go to SQ02 .

Select Environment -> Query Areas..

Select Standard Area (Client specific)

(If Query does not exist in Standard Area then You will have to copy that Query From Global Area to Standard Area.)

For Coping Query From Global To standard first select that query from list.

2)Now select Environment-> Transports

3)In next screen select Copy Global to standard radio button.

Check Overwriting allowed (only with import/upload/copy)

Remove Check for Test Run

Select Transport InfoSets and queries radio button

Fill Infoset and Query with corresponding names.

4)Now Press Execute button.Copy Log will be displayed.

Now Query exist in Global & Standard Area.

5) Go to SQ02 .

Select Environment -> Query Areas..

Select Standard Area (Client specific)

Select Infoset from list.

6) Select Environment -> Transports

7)Select Download radio button

Check Overwriting allowed (only with import/upload/copy)

Remove Check for Test Run

Select Transport InfoSets and queries radio button

Fill Infoset and Query with corresponding names.

😎 Click on Execute button

Now It will ask you to save file.save it.

Now Opened another system (QA Client) to make copy of that infoset.

In the same way transport the User Groups using the Transport User GRoups radio button.

UPLOAD ABAP QUERY

1. Go to SQ02 .

Select Environment -> Query Areas

Select Standard Area (Client specific)

2. Select Environment -> Transports

3)Select Upload radio button

Check Overwriting allowed (only with import/upload/copy)

Remove Check for Test Run

Select Transport InfoSets and queries radio button

Fill Infoset and Query with corresponding names.

4) Click on Execute button.

It will ask you for the place for uploading file.

Select that place (from where you downloaded file).

Now infoset & query is uploaded.Log will be displayed.

in the same way download the user group also.

5)Go to SQ02

Select Environment -> Query Areas

Select Standard Area (Client specific)

SQ02 -> Infoset -> Generate.

Enter Yes.

6)Go to SQ01

Select Environment -> Query Areas

Select Standard Area (Client specific)

Enter your Query Name.

I entered the same query name, but still system is showing error message as"Query ZDMS1 has not yet been created"

Please help.

Regards,

Sandeep

[Former Member]

Hi Joshi,

1.Goto SE93 and enter your transaction code.

2. Screen Fields :

I. D_SREPOVARI-REPORTTYPE : should be 'AQ' in case of SQ01 queris.

II. D_SREPOVARI-REPORT: Gives the name of the user group and query areas/environment

for ex. D_SREPOVARI-REPORT = TEST G

Means user group 'TEST' from 'Global Area' i.e. 'G' stands for global area and if G is not there then user group is in 'Standard

area'

III. D_SREPOVARI-EXTDREPORT : Gives the name of the query.

3. Then from SQ01 select the respective area global or standard.

4. Select respective user group by clicking on 'Other User Group ' button (Ctrl + F7 ) and then you can find out the required query in that user group.

Regards,

Ravi

[mithun_shetty4]

What was the message that u got after upload. ?

1) Check if your user id is added in the user Group.

2) Once u enter SQ01 check the user group that you are in ! on the Top u can see "Query from User Group "XXXXX: Initial Screen".

if ur not on the correct one select the correct one by pressing the left most button

[Former Member]

Hi,

First you have to create infoset and have to generate in SQ02

After you have to create authorization in SQ03 (you must have to assign infoset in initial screen of SQ03)

Then you can create a Query in SQ01

Regards

kk

[Former Member]

Hi Experts,

Thanks for your replies. I resolved it by myself. So closing this thread.

Regards

Sandeep