Download data in SAP

Help Activities
, , ,
1

Hi guys,

I am using SAP GUI 760. My task is to download big file in ZORDLST transaction.
It will take me 10min to half of hours. (depend on data volume).
So I use Wait for Download Activity to wait big file download.
But I found once download is completed, Excel workbook will be automatically opened.
It will cause Wait for Download not work until I close excel workbook manually.
How Can I do for this case? I tried to use Close workbook activity, and I need to use open excel scope activity. It’s still not working .

Another problem is for big file download , not sure it works if I open multiple SAP GUI windows and download the file at the same time. Does it work or not? I want to try but I don’t know how to identify individual SAP GUI windows .

image
image1560×570 161 KB

Thank you
Best Regards
Kenny Chen

2

HI @Chen_Kenny

I would suggest to use this solution don’t open automatically the excel file during download in SAP - SAP Q&A

Sounds pretty good for me.

Best regards, Lev

1 Like
3

Hi Lev,

Thanks a lot, another question,
May I open multiple SAP GUI windows view at the same time ? Is it possible uipath can identify individual SAP GUI window ?

Thank you
Kenny Chen

Thank you.

4

HI @Chen_Kenny

Yes, you can open multiple windows, and yes, we can identify them.

BUT

  • open multiple windows will not speed up the download of one huge file

  • I would suggest actually not to download all at once and wait uncertain amount of minutes but to use SAP filter to setup a smaller packages and then perform download a few times, but always fast to avoid any timeouts on SAP side.

  • and when I am thinking about huge export the best way is use SAP Background jobs, which will collect all data in background and you will get the file done

  • or even it would make sense to try out SAP BAPI to download a lot of date.

There are plenty of options. Please speak to your SAP IT guys, explain the use case and it should be a better option, that just wait and wait for SAP WinGUI to respond

Best regards, Lev

2 Likes
5

Hi Lev,

Thanks for your detailed explanation. If I don’t focus on download data, but I use parallel activity to do two different SAP processes at the same time. is it possible?

6

Yes, it is possible. Here the guys discussing different options Tip: How to Detect SAP Connection and Session Number in the Context of Project

1 Like