Skip to Content

How to assign a Query into Transport request and Package in SAP BW?

We can use 2 ways to assign Query into Transport request and Package:-

Option 1:

Ex: Query ZPLANT_Q_003 was default saved in $TMP package. We need to assign this query to transportable package

  1. Go to T-code: RSA1–>Transport connection–>Object types–>Query elements–>click on select objects (find the Query based on the Info area and info provider) select the Query–>ok (on right side panel we can able to see the Query)…

Capture.JPG

Right click on Query–> select the Change package

Or

2.JPG

Click Truck Icon, –> change the Package –>save…

3.JPG

4.JPG

Use Existing TR or Create new TR using the Icon “create request”–> write Description of TR–>Save…

Now the system automatically Generated new TR Number.( below screen shot)–>click OK..

5.JPG

Then   click the Refresh button on à now the Query is assigned with Transport request along with Package.

6.JPG

Then check the same TR request is available on Modifiable (T-Code: SE09)..

Option 2:

Ex: Query Z_MDAT was default saved in $TMP package. We need to assign this query to transportable package.

T-code: RSA1–>Transport connection–>Object types–>Query elements–>click on select objects (find the Query based on the Info area and info provider) select the Query–>OK( on right side panel we can able to see the Query)…

7.JPG

Then Click on BEx icon (as shown in the below screenshot)–> then click on Assign/delete Button–> create new request (click create request option)–>write description of TR,(ex: sample Query)–>Save….

8.JPG

9.JPG

Now Transport request is automatically generated (BW1K900019),

  Click on “+”insert button–>Then click on pencil icon, select Package (which one we need to assign)–>OK….

10.JPG

click on  save Icon,Now the Transport request is assigned with selected Package (below screen)….

11.JPG

Assigning the Query to Transport request


Click on Truck Icon or Right click on the Query- -> select change package –>display/change Package–>change the Package $tmp to Z_BW (which ever currently used for Transportation).–> Save.

12.JPG

Then select the Transport request( with help of work bench request)–>click on OK option.

13.JPG

a new pop-up,A new task will be created screen will come, click ok…

14.JPG

16.JPG

Br,

Kamal

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply