Skip to Content
author's profile photo Former Member
Former Member

SQ01 -Unable to upload query

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.

8) 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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Dec 14, 2011 at 09:38 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 09:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 10:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 10:27 AM

    Hi Experts,

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

    Regards

    Sandeep

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.