Skip to Content
Technical Articles

How to export BW Object List to Excel from BW Transport Connection

Hi, in this post I would like to share an approach for exporting list of objects from Transport Connection in Data Warehouse Workbench.

Problem 

We need to save in excel file objects from DWW Transport Connection. By default I could not find a way to export them into file from SAP GUI.

Solution

I created a macro that could process export file or files from DWW Transport Connection.

Before usage

1.Save MacroBW_eng.xlsm file to your PC. File is shared by link MacroBW_eng.

2.Create folders in C:\Temp\Export\In and C:\Temp\Export\Out

3.Check and Modify name list of object types and list of BW sources systems at Types sheet.

Collect Objects

1.Go to DWW Transport Connection and collect objects that your need.

2.For Display use List and select Expand All, select all rows in collected objects and Copy.

3.Paste to Excel and Save file, e.i. as “Export1.xlsx“. Place file in C:\Temp\Export\In.

Note: Your could make not only one file here, 2 or more if needed.

As you could see all information is placed by rows, but in 1 column.

This my test export file could be downloaded from here.

Run Macro

1.Run MacroBW_eng.xlsm file and get this control form.

2.Press Start and Get Object_List.xlsx result file.

At first sheet there is a Table of Contents with number of objects information. Objects are organized by types in different sheets.

Summary

In real use cases there are more than one file and many thousands of objects. Manual processing of them is time consuming task, especially in case of duplicates problem in different files.

With help of this macro you could make collection of objects in you BW system for documentation or analysis purpose.

 

Thank you for attention!

Be the first to leave a comment
You must be Logged on to comment or reply to a post.