Skip to Content
Author's profile photo Former Member

Step by step procedure to transport SAP BI/BW Objects

Summary: This document is intended to show the step by step procedure to import SAP BW objects from one system to another.

Contents

Introduction
Including a BW object into a transport request
Release a transport request
Import queue
Importing Requests
a) Starting the Import for Individual Requests (Single Transport Strategy)   
b) Starting the Import of All Requests in an Import Queue
c) Starting the Import of All Requests in One or More Projects
Import History and Return Codes
Re-import a transport request
Delete a transport request from the Import Queue
Updating the Import Overview and the Import Queues

Introduction
A transport request is a package that is used to collect developed objects and move them from one SAP system to another. It is not encouraged to implement newly created objects directly in the production environment to prevent risk factors like loss of data, data flow changes etc., and hence transport request is used. The required developed objects are included in the transport request and transported from development systems to many testing systems (like Quality Assurance, Regression, Pre-Production), tested and finally moved to Production. So initially the required object(s) is included in the transport request and released from the source system then it is imported in the target system.   

Including a BW object into a transport request                                   
There are many ways to include a BW Object in a request of which one is shown here. Call T-Code RSA1 in the Source system (here DEV) > Transport Connection functional area > Search for the object that needs to be transported and drag/drop it on the right side of the screen as shown in Figure 1. Consistent requests that take object dependencies into consideration are especially important in BI because the metadata objects are activated in the import post processing step. If dependent objects are missing in the transport request, this results in errors during activation. These dependencies are mapped to the grouping modes when the objects are collected.


                                                                             Figure 1

Grouping Mode

Only Necessary Objects:
Only those objects that are really required for the action (copying or transporting the selected objects) are taken into account (minimal selection).

In Data Flow Before:
The objects that pass data to a collected object are collected. For an InfoCube, for example, all the objects those are in the data flow before the InfoCube, and are therefore necessary for providing data to the InfoCube, are collected. This includes transformation rules and InfoSources, for example.

In Data Flow Afterwards:
The objects that get their data from a collected object are collected. For an InfoCube, for example, all the objects that are in the data flow after the InfoCube, and are therefore reporting objects that display the data stored in the InfoCube, are collected. This includes queries and Web templates, for example.

In Data Flow Before and Afterwards:
All objects that provide or pass on data are collected. For example, if you are using an InfoCube, the objects required to activate the InfoCube are collected together with other objects that are required to activate those objects as well. This includes objects positioned both before and after the InfoCube in the data flow.

Save for System Copy:
This setting is used when a source system needs to be copied and renamed. Hence having to re-create objects for both SAP systems and BI systems and be avoided.

Collection Mode

Collect Automatically (default setting): The data is collected as soon as the objects are selected.
Start Manual Collection: The data is not collected until you choose Collect Dependent Objects.

Once Grouping and Collection modes are selected, click on   symbol to create a transport request (see Figure 2), select the Package name (Specific for a project, get it from the Basis Team) and save. Request ID is generated as SIDKXXXXXX, (SID-System ID). By default all the objects are included in the package $TMP.

                                                                         Figure 2

Release a transport request

Use: Initially the request will be in Modifiable state, it should be released from the development system to move it into further systems.

Procedure
Call T-Code SE01/SE09 in the source system (here DEV) > Enter the transport request, release the task (here DEVK123452) and then the main transport (here DEVK123456) as shown in Figure 3.

/wp-content/uploads/2012/03/3_88086.jpg
                     Figure 3

To release a request Click on Release directly. As soon as the transport request is released, it should be available in the Import Queue of the target system (here testing system). Make sure that the connection exists between these two systems. 

Import queue

Use: The import queue displays all transport requests flagged for import for a particular SAP System.

Procedure
To check the Import queue Call T-Code STMS in the target system (here TST). It will take you to the TMS screen shown in Figure 4. Now click on symbol, it will take you to Import Overview (Figure 5) where all the systems defined can be seen. Double click on target system (here testing system) to check the import queue.

/wp-content/uploads/2012/03/18_88099.jpg

Import queue is shown in Figure 6, where

Number- Serial number
Request- Transport request
Clt- Client ID
RC-Return Code (Explained in further section)
Owner- Developer name
Project- Project ID
Short Text- Description of the transport request

For performance reasons, the data required in the queue is read from the transport directory the first time the TMS is called. After that, information buffered in the database is always shown. To refresh the buffered information, choose Edit > Refresh (F5). Sometimes even after refreshing the queue appears next to the transport request as shown in Figure 7. Click on (Adjust Import Queue) and choose ‘Yes’ (Figure 8). Here TMS transfers the data files and co-files belonging to this project and confirms the transfer in the import queue. Now the transport request is ready to be imported into the target system.

/wp-content/uploads/2012/03/19_88102.jpg

Importing requests

Before you import the requests from an import queue into an SAP System, ensure that no users are importing other objects in this SAP System because only one transport request can be imported at a particular instant of time. If multiple transports are imported simultaneously then the transports are imported only one after the other i.e. in parallel. There are three ways to import the request.

a) Starting the Import for Individual Requests (Single Transport Strategy)
The TMS allows importing individual requests from the import queue. The requests you choose are imported in the order in which they are placed in the import queue. Select the Transport request and click on Transport Request as shown in figure 5. The screen displayed (Figure 9) helps you in choosing the options to import the transport request which is explained below.

Starting an Import: Date Tab

All the options for starting an import in TMS are listed here.

/wp-content/uploads/2012/03/9_88112.jpg
                                               Figure 9

The options you have depend on which import type you have chosen (project or individual import, import all requests, transport workflow).

  1. Immediate: If you want the import to start immediately in a dialog, choose Immediate.
  2. At start time: If you want the import to start at a later time, choose this option. The import is scheduled as a background job in the target system. If you enter a date and time in the field No start after, the import is started in the time frame between Planned start and No start after. If there is no background process available in this window, the import will not happen. If you want the import to be performed regularly, you must choose a period in the field Period. The Period option does not exist for single transports and the transport workflow.
  3. After event: If you want the import to start only after an event is triggered, choose this option. If you choose the option Execute import periodically, the import is started each time the specified event is triggered. Otherwise, the import is started only when the event is triggered the first time. The Execute import periodically option does not exist for single transports and the transport workflow.


Starting an Import: Execution Tab

On the tab page Execution, you can specify how you want the transport control program tp to start:

/wp-content/uploads/2012/03/20_88104.jpg

  1. Synchronously: If you want the dialog or background process to wait until the import has been completely performed by tp, choose this option (figure 10). It is useful, for example, if subsequent actions are to be performed in the system after the import. If you schedule the import to run synchronously in the background, the background job, which performs the subsequent actions, can wait until the end of the import. A dialog process or background process is blocked until the import has ended.
  2. Asynchronously: If you want to release the dialog or background process after the transport control program has been started, choose this option (figure 11). It is useful if there are a lot of requests waiting for import, which would make the import take a long time. After tp has been started by the dialog or background process on the operating system level, the SAP process ends and tp imports the requests.

    The option Asynchronously is the default setting for importing projects or importing all the requests in an import queue. However, the option Synchronous is the default setting for importing single requests. For other import types, it is always asynchronous.

Starting an Import: Options Tab

All the options for starting an import in TMS are listed here (Figure 12). The options you choose depend on which import type you have chosen (project or individual import, import all requests, transport workflow).

/wp-content/uploads/2012/03/12_88114.jpg

(Import History).

Return Codes

Use: To check whether a transport request has been successful imported, the return codes (Figure 13) are generated by the programs used for the transport.

Procedure:
Click on (Import History) in the Import Queue Screen. Return code for a particular request can be seen next to it./wp-content/uploads/2012/03/13_88108.jpg
                                                                        Figure 13

Re-import a transport request

Use Sometimes there exists a situation where the transport request needs re-import. So the transport request should be moved from history to the import queue.

Procedure

Go to History > Extras > Other Requests > Add.
Enter the transport request needs re-import, Target Client and check the Import again as shown in Figure 14 and Figure 15.

21.JPG

Now the transport request will be ready in the import queue for importing again. Select the request and click on Transport Request > Now select required options in Date and Execution Tab. In Options tab you need to select the below options (Figure 16) because the request needs re-import. The use of each option is same as explained in previous section.

/wp-content/uploads/2012/03/16_88115.jpg

                                              Figure 16

Delete a transport request from the Import Queue

Use In exceptional cases, you may have to delete a transport request from the import queue so that the request is not imported into the target system. If you delete change requests from the import queue, inconsistencies may occur during the next import due to shared objects. Suppose you delete request 1 containing a data element which is not imported. In request 2, you transport a table that references this data element. Since the referenced data element does not exist in the target system, there is an Activation error when request 2 is imported.

Procedure
To Delete a Request from the queue > Select the transport request (F9) > Request (Menu) >Delete

Updating the Import Overview and the Import Queues

Use You can refresh the display of the import overview and individual import queues. However, it is more convenient to update the import queues periodically in the background.

Procedure
To update import queues in the background > Enter transaction STMS > Choose The Import Overview appears > Choose Extras > Update all import queues. The dialog box Update All Import Queues in Background appears. > Choose the correct option (from Immediate, At start time, Period) and enter the required data. Use input help to select a period > Choose Continue.

Schedule a periodic update of the import queues, at least in the SAP System where you use TMS the most (default period Daily is recommended).

Related Content

http://help.sap.com/saphelp_nw2004s/helpdata/en/3d/ad5a8a4ebc11d182bf0000e829fbfe/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/0b/5ee7377a98c17fe10000009b38f842/content.htm
http://help.sap.com/printdocu/core/print46c/en/data/pdf/bcctstms/bcctstms.pdf

How to find the transport request that changed a BW Object in the system >> (http://scn.sap.com/docs/DOC-25248)

Assigned Tags

      39 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Sai,

      Very good document on transportation.

      Regards,

      Venkatesh

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Venkatesh.. 🙂

      Author's profile photo Former Member
      Former Member

      Hi Prasad,

      Use full document on transportation.

      Thanks & Regards

      P.Anand

      Author's profile photo Former Member
      Former Member

      Hi masters can any one tell me how to transport objects in bi?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      I guess, the above document will help you. 😐
      Let me know if it doesn't. 🙂

      Author's profile photo CH Raman
      CH Raman

      Hi Sai,

      Its Nice doc, keep it up.

      Regards

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Raman.. 🙂

      Author's profile photo Former Member
      Former Member

      HI Sai,

      Very useful document on transportation.

      Thanks Regards

      Aakash Gujja

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Aakash... 😉

      Author's profile photo Jyoti Raheja
      Jyoti Raheja

      Good learning from this document... 🙂

      Thanks Sai!!!

      Regards,

      Jyoti Raheja

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Jyoti.. 🙂

      Author's profile photo Former Member
      Former Member

      can I have your contact info?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Nagendra you may find it here
      http://scn.sap.com/people/sai.prasad5

      Author's profile photo Former Member
      Former Member

      Nice documentation..

      Thanks Sai.

      Author's profile photo Former Member
      Former Member

      is there a way..where i can download this as a document other than PDF(as my system does not support pdf 🙁 )??

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Srivasulu: You may try copying into a word document. 😉

      Author's profile photo Former Member
      Former Member

      Thanks Sai. This was very clearly explained. 🙂

      Author's profile photo Satendra Mishra
      Satendra Mishra

      You shared nice information Sai.

      Author's profile photo Former Member
      Former Member

      Hi Sai,

      Great post on Transport management. Thank you for the exceptional contribution. And thank you CH Raman for pointing to this post.

      Regards

      Kannan

      Author's profile photo CH Raman
      CH Raman

      kannan,

      this was covered all info regarding transport collection sequence  to release. so its really useful one.

      Thanks

      Author's profile photo Former Member
      Former Member

      Nice sai. your step by step explanation is simple and clear.

      Author's profile photo Former Member
      Former Member

      Very good document.

      Author's profile photo Ajay Venkatesh
      Ajay Venkatesh

      When importing multiple instances of SAP BI/BW into a common HANA system using the transport connection, please let me know if there is an easy way to avoid 'duplicate object name' error? or should we rename all source objects so that they are unique?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Multiple instances of BW cannot be moved to a single HANA system. May I know what exactly you are trying to do?

      Author's profile photo Colm Boyle
      Colm Boyle

      Very nice Blog, thanks

      Author's profile photo Former Member
      Former Member

      Really useful . Thank you

      Regards,

      Jose

      Author's profile photo Former Member
      Former Member

      Hi Sai Prasad

      Nice documentation!

      Very clear and useful! 🙂

      Thanks

      Venkat

      Author's profile photo Former Member
      Former Member

      hi sai

      Nice Documentation..

      thank u so much..... 🙂

      Author's profile photo Former Member
      Former Member

      Nice Formatted Document 🙂

      Thanks,

      Purushotham.

      Author's profile photo Former Member
      Former Member

      We have a scenario where in we have to import the transports of SAP BW 7.3 System on HANA SPS6 Rev 61  into SAP BW 7.3 System on SQL 2012.

      Does SAP supports the conversion of In-Memory optimized infocubes or DSO's of SAP BW 7.3 on HANA  in the source system automatically into basic BW infocubes or DSO's of SAP BW 7.3 on SQL in the target system by doing the transport imports? Any SAP Note / Patch ?

      Please could you provide any solution or suggestions for performing the aforementioned activity. Thanks in advance.

      Author's profile photo vivek singh
      vivek singh

      Hi ,

      I have a question - whether the co files and data files contain the complete object or just the change.

      Suppose I create a cube and keep it in TR -X , move it to Quality.

      then I make some change in cube suppose delete a info object and move new TR - Y to Q.

      Now I add another info object - and move the new TR Z to Q.

      what I know that usually we move all three TR in the same sequence.

      But what if i just move "Z" to Production and leave X and Y in Q.

      thanks.

      Author's profile photo goud balakrishna
      goud balakrishna

      Hi Sai,

      After copying BW objects to another system, can we replicate the old object values/data (master data, hierarchy and transactional data) to new objects, if yes, could you please share the info.

      My client want to migrate BW functionality from SAP BW to SAP ECC system (BCS live in SAP ECC system from one year).

      Appreciate your inputs.

      rgds,

      Author's profile photo Former Member
      Former Member

      Hi Sai,

      Very nice document,Very neat and clean explanation.I have problem i missed object can export  the object with same TPR id ? or new TPR ?

      Vickram

      Author's profile photo Former Member
      Former Member

      Really helpful content sai....

      Author's profile photo Former Member
      Former Member

      Nice document.

      Author's profile photo Former Member
      Former Member

      Very well explained..Keep doing the great work.

      Thanks buddy

      Author's profile photo saharoon musathick
      saharoon musathick

      Really usefull......

      Author's profile photo Rajeev Singh
      Rajeev Singh

      Dear Sai Prasad,

      Great thanks to share this document. I have cleared my confusions. Thanks.

      Author's profile photo VIVEK SELVARAJ
      VIVEK SELVARAJ

      Hi Sai,

      It is really help full and clear.

      Regards,

      Vivek