SAP Query(SQ01) need to be transported

[Former Member]

Hi All,

I want to transport a tcode which is using SAP query. Now I am able to send the tcode to other system but when I go to SAP query under queries and standard query area I am not able to see the version management details. I also tried going to the SAP query report through double clicking on the report name under SE93, and when I am into the report it also does not show any version details. It says "No version found".

What I am thinking is just get the active request number from the version management and transport it to the other system.

Can anyone of you tell me how to transport a SAP query.

Thanks,

Mahen

[Former Member]

Sorry Mark I am using ur ID for the time being. I know that you know about this.

Thanks,

Mahen

[Former Member]

Hey I was off the office for some days, Its okay for me. You are always welcome my friend.

Thanks,

Mark

[Former Member]

If u have transported the Query & Infoset.....using SQ02...

then after the transportation.. u need to import the query & infoset again in the the production server...

Then run the query & get the program name and craete the TCODE

[Former Member]

i can give you a solution which i follow...

run the query. now come to se38 you can see a defullt prog name ( very big with spl characters) copy this prog to z prog activate it . go to se 93c and create a tcode for that and save it . now transport zprog and tcode.

regards

shiba dutta

[Former Member]

Hey Shiba,

I think I gave you this answer yesterday?

[Former Member]

sorry to say i never ask this question in forum .. just cross check it... i think you are confusing with some other name...

regards

shiba dutta

[Former Member]

OK Shiba,

No hard feeling..Even I just cross checked...

Just Chill

[Former Member]

no no nothing just update your confusion ... dont bother. have a nice day...

regards

shiba dutta

[Former Member]

Step 1. Run RSAQR3TR in 'old' system. Select EXPORT and specify the objects to be transported.

(System includes these in an automatically created transport request)

Step 2. Release this transport and request it be transported to 'new' system.

(This results in the entries being populated in transport table AQTDB in 'new' system).

Step 3. Run RSAQR3TR in 'new' system. Select IMPORT and tick the Overwrite checkbox. Specify the transport number in the field labelled 'dataset with imports'.

(RSAQR3TR gives the message that stuff has been imported OK).

[Former Member]

Hey dont copy the program in any ZPROGRAM.. first u need to import the query in Production or testing server, and then get the program name...

[Former Member]

Hi All,

You can't transport queries from one system to other.You have to explicitely develop them in the other clients like QUALITY and PRD or whereever you want them to function..

reward if useful

regards,

ANJI

[Former Member]

Hi Anji,

Querys can be very well trasnported..

The only thing you have to take care is after relasing the transport number, u have to import the query along with the infoset in the client in whcih u have transported.

[Former Member]

Hello everyone,

I am having problem in fixing this up. Let me tell you all what I have done.

I first transported the tcode from souce system to target system.

Because I transported the tcode so in the target system. Tcode has the report/program name as it is existing in the source system.

Now when I transported the everything like user group, infoset and the query, I was able to see them in the target client. I tried to run the tcode.

Tcode does not run, It says there are inconsistensies in the tcode.

I tried to trouble shoot the problem. I found that when I was trying to run the tcode it was not able to find the report/program.

What I did was, I generated the program for SAP query existing in the target client.

When program was generated, I observed that It is different with the one that is currently existing for the tcode in the target client.

This is the main problem report name are different. When I see in the se93 report name is the old one which I transported from the source system for the tcode, but when I see the report name for the SAP query by going into SQ02 it is coming different. I want to know when you create the program name for the SAP query, On what basis is the namespace of the program generated.

SAP query program name existing for the tcode and in the source system and also in the target system(When you see it in se93) is :

AQ01FI==========ZBSAK_LFB1====

SAP query program name when I generated it in the target client is :

AQFKFI==========ZBSAK_LFB1====

Bythe way the query name is ZBSAK_LFB1

Kindly throw some light on this.

Thanks,

Mahen

[Former Member]

Hi Mark.

The name of the SAP query report in source and target systems will always be diffrent..

hence you need to transport the query & infoset first and then the Tcode.

Now, wht u can do is copy the target system query name i.e AQFKFI==========ZBSAK_LFB1====

and modify the tcode with this name and again transport the tcode to target client.. it will work..

First four letter of the report name AQFKFI==========ZBSAK_LFB1====

are name given by system , then FI is the user group name and the ZBASK_LFB1 is the query name

I hope this works

[Former Member]

Hey Mark,

Is your query solved?

Please reward points and mark your question as solved

[Former Member]

Hi All,

When I run the tcode which has SAP query attached to it, it says you do not have authorization to run this transaction. That is okay with me, What I did was I copied the SAP query name from SE93 and directly run it through SE38, Selection screen appears which is okay and then when finally I execute the report it also displays the data. This is fine with me.

But when Some other user who has the authorization to run this transaction runs it he is able to run the tcode but the problem is that when selection screen comes he is not able to see the selection text(in general levels of select-options,parameters, radio buttons and checkboxes), only fields appear on the selection screen. I tried to see them using ->go to->selection text.

But system says inconsistensies.

Could some one let me know when other user runs the SAP query transaction he is not able to see the selection texts on the selection screen.

Thanks,

Mahen

[Former Member]

This message was moderated.