BW/BI Transport - Order of Object list

Posted by vimal murugan
We can attach all objects in one Transport request, being separated under different tasks and transport it to target system. Provided that the release of the tasks are in the dependent order and then the parent transport is released.

Order of Object list

1R/3 Objects
2Development Class - for backend objects
3Developer Security Roles
4R/3 Application Component
5Custom Tablespace /  Custom Data Class
6InfoObject & InfoObject Catalogs
7BW Data targets
8BW Data Mart Data Sources - After Replication & Activation
9BW InfoSource
10BW Communication Structure
11BW Transfer Structure
12BW Transfer Rules
13BW Update Rules
14BW MultiCubes
15Development Class - for frontend objects
16BW Custom Tables & Contents
17BW infoPackages & Groups
18InfoSet Queries
19End user security roles
20BW Function Modules
21BW "ABAP Reports"
22BW Customer Exit Objects
23Variables Customer Exit code
24BW Reporting Objects
25BW Queries - Structures / Calculated Key Figure / Restricted Key Figure
26BW Queries
27BW Query variants
29BW APD variants
30BW Workbooks
31BW Workbook Folders
32Jump Targets' settings
33Process Chains - start / process variants

Extra tips -

In addition to the Syntax check and the Request Consistency check, another important check is necessary at certain cases – Inactive Objects’ Check. We can use TCode - SE10, where this option is available – Request/Task Menu -> Complete Check -> Display Inactive Objects

In attaching the query elements, if any of the fields are having different ‘Package’ other that your current project works’

      1. For $tmp – mandatory to change it into your current package. You can even do this at one shot by selecting all        such objects, clicking on the change package button over the top screen and proceed.

       2. For other packages – Right click on the object; Select the object Attributes in the context – menu, See if there is a    tick mark in the ‘Repair Flag’ checkbox. If so the DO NOT collect this object in your current transport request, as it will      fail during target import. The reason is any object with ‘Repair flag’ will not take the “M” version from other (lower)   systems on transport write.

In attaching the query elements, if any of the fields are already attached to any other transport number, but not yet released, system will show a warning message about the order of transporting the dependent requests. For reusable components like Restricted key Figures, Calculated Key Figures, structures, user Exits, etc.., one best way is to unlock the other transport requests which is holding these objects and you can proceed with your current transport collection.

Use TCode – SE03, Select Unlock Objects (Expert Tool) below the Requests/Tasks folder.