topic Re: SAP Query in Application Development and Automation Discussions

SAP Query

Former Member — Tue, 06 Jan 2009 21:38:16 GMT

Hi all,

I have created query from SQVI and assigned T-code also in development.I need to move dev to quality and production .Is it possible to transport this query with t-code?Please suggest ..

Regards

Rajjj

Re: SAP Query

Former Member — Tue, 06 Jan 2009 21:41:27 GMT

Welcome to SCN.

Please from next time atleast search twise before posting the queries.

Check =>[Transporting of ABAP Query from one server to another server|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/10563] [original link is broken] [original link is broken] [original link is broken];

Re: SAP Query

nkr1shna — Tue, 06 Jan 2009 21:57:19 GMT

Hi Shri,

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

Best Regards,

Krishna

Re: SAP Query

nkr1shna — Tue, 06 Jan 2009 21:58:39 GMT

Hi Shri,

Here is the step by step process

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

Best Regards,

Krishna

Re: SAP Query

Former Member — Wed, 07 Jan 2009 04:03:29 GMT

Hi,

if the Query belong to a Global area it can be saved in a Transport Request and can be transported normally.

if the Query belong to a standard area then system will not ask for any Transport request while saving, in this case we need to transport it in different way from system to system.

the process is:

goto SQ02--> give the Infoset name which the Query belong to ~~-> select Environment (menu bar)~~>Transports ---> select Import RB ~~>select RB Transport Infosets and queries~~> here provide the Query name and infoset name in the fields and execute.

By doing above, system will generate a new request number.

then u need to merge this request no to the actual request number and transport it to Quality...

Hope it helps!!

Regards,

Pavan