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

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,364
Tepki puanı
7
Puanları
6
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.
Untitled.png


Collect Objects


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

Untitled-1.png


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

Untitled-2.png


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

Untitled-3.png


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

Untitled-4.png


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

Run Macro


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

Untitled-5.png


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

Untitled-7.png


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

Untitled-8.png


Untitled-9.png


Untitled-10.png


Untitled-11.png


Untitled-12.png


Untitled-13.png


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!

Okumaya devam et...
 
Üst