cancel
Showing results for 
Search instead for 
Did you mean: 

How to transport queries SQ00 from Production to Development

Former Member
0 Kudos

Team,

I want to know how to transport ABAP queries from one system to another system. What is the proper sequence:

Should I transport Infosets or UserGroup/queries first?

Once the queries are in Development environment I will be attaching ztransaction codes to them and will move these transaction codes to production via transport.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Or goto->Sq02 , You`ll see "Truck" button ..click it .

Cheers

Usman

Former Member
0 Kudos

What should be the sequence... There are four radio buttons as shown below... I am planning to transport one USerGroup at a time... Do I need to transport Infoset before Exporting Usergroups and queries.

-


Transport User groups

-


TransportInfoSets

-


Transport InfoSets

Queries

-


Transport User groups

Queries

Thanks

Naved

former_member181966
Active Contributor
0 Kudos

user Groups

infoset

ABAP query

Thanks

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

You know clicking on the truck in SQ02 is the same as calling the RSAQR3TR program that I mentioned.

Regards,

Rich Heilman

Former Member
0 Kudos

Yes. I know.

What the 'Import option REPLACE' means in each of the radio buttons...

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

Please see the help documentation.

<b>....

The import option REPLACE first deletes the assignment of the InfoSet to user groups in the target client, provided there are no queries dependent on the InfoSet. The InfoSet is then transported to the target client and the assignment of the InfoSet to user groups is copied from the source client, if user groups also exist in the target client.

....</b>

<i>

Short text

Description

The report RSAQR3TR handles all tasks concerning the transport of queries, InfoSets and user groups.

General information

Queries, InfoSets and user groups are stored in the table AQDB. This table is client-specific. For the transport of queries, InfoSets and user groups, there is a special client-independent transport table called TAQTS. You can carry out transports either

from a client (source client) of an SAP system to another client (target client) in the same SAP system or

from a client (source client) of an SAP system (source system) to a client (target client) in another SAP system (target system).

In both cases, you have to perform similar actions.

The objects to be transported must first be copied from the source client using an export from the table AQDB into the transport table TAQTS. At the same time, a transport request is created for the transport system that includes all entries created by the export from table TATQS (transport dataset). The name of this transport request conforms to the transport system naming conventions (sysKnnnnnn) and is included in the export log. The transport dataset is stored in the table TAQTS under a key which matches the name of the transport request.

If you are transporting within one SAP system (from one client to another), you can import the transport dataset from the target client. The name of the transport request to use for this purpose is that specified during the export, since it should match the key of the transport dataset in the table TAQTS. With this import, the transport dataset is read from the transport table TAQTS and inserted into the table AQDB, where extensive checks ensure that there are no inconsistent statuses in the table AQDB.

If you are transporting from one SAP system to another, you must first use the transport system to release and export the transport request generated by the export. This transports the transport dataset from the transport table TAQTS into the target system. Then, you can import from the target client of the target system, as described above.

The transport datasets generated by exports in the transport table TAQTS are not deleted after successful import unless this is explicitly requested. Therefore, you can import a transport dataset several times (when copying a functional area to several different clients, for example).

This report handles exports (generation of transport datasets), imports (reading of transport datasets) as well as the management (display and deletion) of transport datasets.

As transport action, you must specify one of the values EXPO (export), IMPO (import), SHOW (display transport dataset) or DELE (delete transport dataset).

Transport action EXPO (exports)

If you select the 'Test only' parameter when exporting (no blank characters), the system determines only those queries, InfoSets and user groups that would be selected according to the selections for transport described below and generates an appropriate log. A transport dataset is not generated in the table TAQTS. This allows you to check whether a selection really includes the queries, InfoSets and user groups to be transported.

With exports, there are four different options for selecting objects (user groups, InfoSets, queries) to be transported. These are 'Transport of user groups', 'Transport of InfoSets', 'Transport of InfoSets and queries' and 'Transport of queries'. You must choose exactly one of these transport types.

In each case, you can also define an import option depending on the transport type. This allows you to determine how the transport dataset is inserted in the table AQDB of the target client during a later import.

The import options, each of which has an abbreviated syntax,

are as follows:

REPLACE or R

MERGE or M

GROUP=ug or G=ug (ug = name of a user group)

UNASSIGN or U

If you use the transport type 'Transport of user groups', all user groups are transported according to the select option 'user groups' and the selected import option. The import options REPLACE and MERGE are allowed.

If you use the transport type 'Transport of InfoSets', all InfoSets are transported according to the select option 'InfoSet' and the selected import option. The import options REPLACE, MERGE, GROUP=ug and UNASSIGN are allowed.

If you select the transport type 'Transport of InfoSets and queries', all InfoSets are transported according to the select option 'InfoSets' and the selected import option. The import options REPLACE and MERGE are allowed. Also, all queries are transported for each functional area selected, according to the select option 'queries'. In this case, the user groups of the queries are irrelevant and only the import option REPLACE is allowed.

This transport type allows you to transport a modified InfoSet and all the associated queries.

For the transport type 'Transport of queries', all queries are transported according to the select option 'User groups' and the select option 'Queries' as well as the selected import option. The import options REPLACE and GROUP=ug are allowed.

The export log displays which user groups, which InfoSets and which queries are transported, as well as the import options used.

Transporting a user group

Transporting a user group means transporting all members of the group from the source client. However, the InfoSet assignment to the user group in the source client is NOT transported.

The import option REPLACE first deletes all members of the group in the target client and then enters the members from the source client.

The import option MERGE leaves all members of the group assigned in the target client and adds the members of the group from the source client.

Entering a new member in a user group in the target client is possible only if a user master record exists.

In the target client, the assignment of InfoSets to this user group remains.

Transporting an InfoSet

Transporting an InfoSet means transporting the InfoSet and the InfoSet assignment to user groups in the source client.

Importing an InfoSet is possible only if the same logical database exists in the target client. Extensive checking is also performed to ensure that there are no inconsistencies between the InfoSet and the logical database.

The import option REPLACE first deletes the assignment of the InfoSet to user groups in the target client, provided there are no queries dependent on the InfoSet. The InfoSet is then transported to the target client and the assignment of the InfoSet to user groups is copied from the source client, if user groups also exist in the target client.

The import option GROUP=ug first deletes the assignment of the InfoSet to user groups in the target client, provided there are no queries referring to the InfoSet. The InfoSet is then transported to the target client and assigned to the user group ug of the target client, if such a user group exists.

The import option MERGE leaves the assignment of the InfoSet to user groups in the target client and transports it to the target client. It then copies the assignment of the InfoSet to user groups from the source client if user groups also exist in the target client.

The import option UNASSIGN first deletes the assignment of the InfoSet to user groups in the target client, provided there are no queries referring to the InfoSet. The InfoSet is then transported to the target client. No assignment of the InfoSet to user groups is performed.

Transporting a query

Transporting a query means only the query itself is transported.

Importing a query is possible only if a corresponding user group (see below) and a corresponding InfoSet exist in the target client and if the InfoSet is assigned to the user group. To demonstrate the effect of the import options, suppose that the query has the name QU and belongs to the user group BQ in the source client.

The import option REPLACE overwrites the query QU of the user group BQ in the target client if the user group exists.

The import option GROUP=ug overwrites the query QU of the user group UG in the target client if the user group exists. In this case, the query is explicitly assigned to a user group in the target client. This target user group may be differnet from the user group in the source client.

Transport action IMPO (imports)

If you choose the 'Test only' parameter with imports, only a test import is performed. This means that the system performs checks as for a real import and generates an import log. The import log contains information on the locks that have to be set. With a test import, you can check whether a transport dataset can be imported without any problem and which changes it would make in the table AQDB of the target client. A test import itself never makes changes in the table AQDB of the target client.

All transport datasets are imported according to the select option 'transport request'. In this case, the system outputs a detailed log of all checks carried out and all changes made in the table AQDB.

If you select the parameter 'Delete after successful import', the transport dataset in the table TAQTS is deleted after the import of each transport dataset if no errors occur during the import.

Transport action SHOW (display)

All transport datasets included in the transport table TAQTS are output with name (also the name of the transport request) and contents in the form of an overview.

Transport action DELE (delete)

All transport datasets are deleted according to the select option 'transport request'. To avoid unintentional deletion, the select option 'transport request' must contain values, meaning that the transport action DELE is not performed if this select option is empty.

</i>

Regards,

RIch Heilman

former_member181966
Active Contributor
0 Kudos

Please close the topic and <b>Rich</b> deserve 10 points

Former Member
0 Kudos

Thanks Rich...

Correction... Rich deserves twelve points not ten

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

Hey, I just pointed you in the right direction, that's all. Now its up to you to learn/apply it.

Regards,

Rich Heilman

Answers (2)

Answers (2)

ferry_lianto
Active Contributor
0 Kudos

Hi,

Also please check this link for transport of ABAP query.

http://www.sap-img.com/basis/transport-of-abap-query.htm

Hope this will help.

Regards,

Ferry Lianto

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

Please have a look at program RSAQR3TR

Regards,

RIch Heilman