Skip to Content
author's profile photo
Former Member

SAP Query(SQ01) need to be transported

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

Add comment
10|10000 characters needed characters exceeded

10 Answers

  • author's profile photo
    Former Member
    Posted on Apr 12, 2007 at 10:34 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 12, 2007 at 10:29 AM

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

    Thanks,

    Mahen

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 12, 2007 at 10:30 AM

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

    Thanks,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 12, 2007 at 10:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 12, 2007 at 10:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 12, 2007 at 10:35 AM

    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...

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 12, 2007 at 11:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo
    Former Member
    Posted on Apr 13, 2007 at 11:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 19, 2007 at 06:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 11:33 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded