query tool

[former_member204457]

hi experts,

I'm not an ABAPer by training more on the functional side. I'm fairly familiar with SAP Query and Infoset. I was wondering once I generate the query in the development box, I could transport it to Production. If so what I should consider for successful migration to Prod. Furthermore once I generate the query, can I assign it to a custom Tcode. If so how would I do that.

thanks

[Former Member]

SAP Query is Client Dependent , so u cannt Transport from one sys to another one.

as u know SAP query generates client dependent Program , that y.

2.Yeah u can create Tcode for SAP query , u have to create parameter Tcode , and sorry i forgoteen parametres to be passed .

Regards

Prabhu

[Former Member]

i am not sure whether this is the only technique or not what i am doing is after creating the sap query and running it in another session go to se38 it will show you a prog name with some ===or special character just copy it to a z prog and activate the z prog. now in se93 create the tcode for the zprogram .. now transport this zprog and tcode...

regards

shiba dutta

[former_member204457]

Thanks for all the useful info

given that the end user doesn't have access to the Query, only access to run the report generated as the result of Query would this still work. How would I copy the generated prog name to z program and activate it, what are the steps

[Former Member]

after creating the sap query just go to se38 and check whether any program name ( name will be big enough) . there in menu program--->copy one popup will come give a zprogname there to which z prog you want to copy . now give the zprog name in se38 prog name input box and press change button it will go to se38 editor here in application tool bar you can get the activate button (ctrl+F3) it will activate your prog. Run that(F8) and check whether it is same like the sap query or not? if it is same go to se93 give your ztransaction code press create in the pop up choose the 2nd radio button (for report). and give the zprogname in the next screen save that..

now run the tcode to test the prog

regards

shiba dutta

[Former Member]

Hi Cyrus,

Yes we can transport the query and Infoset to Production from Dev.

For this, what u need to do is that go to SQ01--> Infoset Screen.

There u select and infoset and in the Application Toolbar there is a Transport button. Click on that.

Uncheck the checkbox for 'Test run'.

Then fill the relevant info e.g. if Only infoset needs to be transported, give the infoset's name and so on.

Press Execute. It will create a request which u can transport to the desired system.

Once the transport reaches the Production, u need to import the query. by going to SQ01 --> Infoset screen. Press Transport and press Import button.

Give the transport request number in the field 'Dataset with import'.

Regards,

Himanshu

[Former Member]

Cyrus,

To Transport,

There are 2 ways

1.

To convert Quickview made in SQVI to Query, follow these steps:

1. Go to Sq01. First select user group in which you wnat to create your query, then go to Query > Convert QUickview

2. Give your QUickview name, press enter

3. Give your query name and FUnction area . Press enter, quickview is now created in Qurey

4. Then Run RSAQR3TR, give your query and functional area. Run the report it will create a TR.

2.

Goto SQ02. Select the proper query area. Press the transport button in the application bar.

Now u have two options...

1. Download and upload

2. Export and import.

The first option downloads the user/infoset & query on ur local server and then using upload u can bring it into other system. The second option creats transport request and u can use the normal way of transporting to the other system.

Copy and Tcode :

1. Generate first query.-After excute the query in SQ01 go to se38 query generated program name will come into se38.Press display and copy in zprogram.

3. Attach tcode to THIS z program.Using SE93 tcode

4. Transport

3. Now,

whener the query is generated again,

AGAIN COPY THE CODE

TO OUR Z PROGRAM (2ND STEP ABOVE)

(which has already been created)

AND TRANSPORT JUST THIS Z PROGRAM.

REST WILL TAKE CARE OF ITSELF.

Don't forget to reward if useful....

[former_member204457]

thanks so much to all of u