topic Re: transporting query in Application Development and Automation Discussions

transporting query

Former Member — Thu, 24 Jan 2008 05:38:54 GMT

Hi ,

When i was transporting a query from DEV system to QA system i am facing problem.

here are the steps I follow.

step1. go to the sq02 tcode and select the transports(ctrl

+F3) button it will display one new screen.

in that i have selected Transport action Export option

and selected radion button transports infosets and queries

and given the name of the InfoSets, Queries

it automatically created a Table Contents with AQTDB.

and transported to QA sytem .

step2. similary i did in QA system but with import option

and dataset with transport request number in dataset with imports .

it is saying that

InfoSet exists (overwriting not allowed)

Query exists (overwriting not allowed).

and when i check Query SQ01 in QA system it is sayin that

it has not yet been created

Please let me know what i have to do? Query are any user specific? any authorization is required?

Thanks in advance.

viswanath reddy

Re: transporting query

Former Member — Thu, 24 Jan 2008 05:46:22 GMT

Reddy,

Check this..

HI,

Query objects are transported in different ways according to the query area in which they were created.

In order to know which transport options are available, you must first understand how query objects are created.

Standard Area

Query objects are stored in the client-specific table AQLDB. They are not connected to the Change and Transport Organizer.

Global Area

Query objects are stored in the cross-client table AQGDB. They are connected to the Change and Transport Organizer.

http://help.sap.com/saphelp_47x200/helpdata/en/d2/cb467f455611d189710000e8322d00/content.htm

Global area objects can be transported into other systems. Standard area query objects can not only be transported to other clients within their own system, but into all clients of other systems as well. In addition, query objects can be transported from the global query area to the standard query area and back within the same system.Transports are normally performed by the system administrator, not by end-users. For this reason, you need the appropriate authorizations

Check the below links for detailed explanation

Transporting Global Area Objects

http://help.sap.com/saphelp_47x200/helpdata/en/ec/052786a30411d1950a0000e82de14a/content.htm

Transporting Standard Area Objects

http://help.sap.com/saphelp_47x200/helpdata/en/ec/052789a30411d1950a0000e82de14a/content.htm

General Transport Description

http://help.sap.com/saphelp_47x200/helpdata/en/d2/cb4699455611d189710000e8322d00/content.htm

Generating Transporting Datasets

http://help.sap.com/saphelp_47x200/helpdata/en/d2/cb46a6455611d189710000e8322d00/content.htm

Reading Transport Datasets

http://help.sap.com/saphelp_47x200/helpdata/en/d2/cb46e7455611d189710000e8322d00/content.htm

Managing Transport Datasets