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.
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.
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.
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.
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.
The options you have depend on which import type you have chosen (project or individual import, import all requests, transport workflow).
- Immediate: If you want the import to start immediately in a dialog, choose Immediate.
- 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.
- 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:
- 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.
- 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).
(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.
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.
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.
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)
Hi Sai,
Very good document on transportation.
Regards,
Venkatesh
Thank you Venkatesh.. 🙂
Hi Prasad,
Use full document on transportation.
Thanks & Regards
P.Anand
Hi masters can any one tell me how to transport objects in bi?
I guess, the above document will help you. 😐
Let me know if it doesn't. 🙂
Hi Sai,
Its Nice doc, keep it up.
Regards
Thank you Raman.. 🙂
HI Sai,
Very useful document on transportation.
Thanks Regards
Aakash Gujja
Thanks Aakash... 😉
Good learning from this document... 🙂
Thanks Sai!!!
Regards,
Jyoti Raheja
Thanks Jyoti.. 🙂
can I have your contact info?
Nagendra you may find it here
http://scn.sap.com/people/sai.prasad5
Nice documentation..
Thanks Sai.
is there a way..where i can download this as a document other than PDF(as my system does not support pdf 🙁 )??
Srivasulu: You may try copying into a word document. 😉
Thanks Sai. This was very clearly explained. 🙂
You shared nice information Sai.
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
kannan,
this was covered all info regarding transport collection sequence to release. so its really useful one.
Thanks
Nice sai. your step by step explanation is simple and clear.
Very good document.
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?
Multiple instances of BW cannot be moved to a single HANA system. May I know what exactly you are trying to do?
Very nice Blog, thanks
Really useful . Thank you
Regards,
Jose
Hi Sai Prasad
Nice documentation!
Very clear and useful! 🙂
Thanks
Venkat
hi sai
Nice Documentation..
thank u so much..... 🙂
Nice Formatted Document 🙂
Thanks,
Purushotham.
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.
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.
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,
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
Really helpful content sai....
Nice document.
Very well explained..Keep doing the great work.
Thanks buddy
Really usefull......
Dear Sai Prasad,
Great thanks to share this document. I have cleared my confusions. Thanks.
Hi Sai,
It is really help full and clear.
Regards,
Vivek