Skip to Content
avatar image
Former Member

ABAP query

How to export ABAP query from one landscape to another landscape?

Let me know if there is any way out.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 06, 2007 at 05:22 AM

    Hi

    Take a look at OSS note 672784.

    You can transport queries between systems in SQ02 (hit the lorry button) or run program RSAQR3TR.

    You download the infosets, queries etc into a file and load them into whichever system you wish.

    Just wanted to share my experience of transporting queries:

    I needed to move a user group, 2 infosets and 3 queries from a 4.6 system to a 4.7 system.

    When I tried doing this via the SQ* transactions I did not get the import/export option, so instead ran RSAQR3TR.

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

    Step 4. In my example I still couldn't find the queries, so ran RSAQR3TR one more time, this time specifying 'Copy Standard Area -> Global Area'.

    Regards

    Pavan

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 06, 2007 at 05:09 AM

    Hi Murthy....

    We face one issue long back... I feel it is not possible, you have to re-create all work done... in one location....

    If in the same landscape then YES....

    If the hint is useful… Say thanks by reward….

    Regards,

    Prabhu Rajesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2007 at 05:06 AM

    If it is a local query, you can download Query and all related objects and upload in another landscape.

    If it is a global query, you can assign Transport Request and release the same to your test / another environment.

    Hope this helps.

    ashish

    PS: check this link for more details

    transporting a ABAP query

    Message was edited by:

    Ashish Gundawar

    Add comment
    10|10000 characters needed characters exceeded