SAP Click and Scroll

Hello Forum members,

I have a situation in SAP. I extracted a table and saved it in dt1. I need to click on all rows in the “Department” column where the value is WE. I’m using the index (SAP row index starts from 6), so I can click on the required rows successfully—as long as the number of rows is below 30.

However, if the matching rows are beyond index 30, the bot is unable to click them because they are not visible on the screen. To view those rows, I need to scroll down. But when I scroll, the index positions change, so the bot gets confused or clicks the wrong rows.

Also, Simulate Click is not supported in this SAP environment.

Any suggestions on how to handle scrolling and selecting the right rows dynamically would be appreciated.

1 Like

@Darkfighter

As the index is getting reset..after scroll you need to reset as well..for example after 30 if you are scrolling then start from 6 again..and use it as index to click

Cheers

1 Like

You can try using Activities - Invoke VBScript for SAP automation. Record SAP scripting ( Script Recording & Playback for Dummies - SAP Community), click 1 row to record to .vbs file, edit the file to implement click for each row. It’s fast and accurate.

1 Like

Hi @Darkfighter ,

You can record using SAP Scripting Recorder and change things dynamically inside . You can use “Invoke VB Script” to run in UiPath. It would be much faster and Accurate

Hope are you using Activities under SAP in UiPath Activity. Let me know, if yes, we wiill sort this out. Thanks!

2 Likes

Can you provide me steps how can i do that

Hi Darkfighter,

Firstly, the row index part sounds very sketchy. The row index is absolute in our selectors, not relative to the screen/scroll position.

So this :backhand_index_pointing_up: should not happen.
For further investigation and to be able to offer you a proper solution, I would need more information:

  1. A full screenshot of the SAP screen and element(cell) that you are trying to click, along with a screenshot of UiExplorer after indicating the element of interest(table cell). I am interested especially in the selector generated for that cell.
  2. The SAP transaction that you are using and step by step instructions on how to reach the table you are working on.

Thank you and looking forward to your reply!

1 Like

@LevKushnir can you help me out

@Darkfighter - see above. We are waiting for you response

1 Like

ok i’ll provide you the details


@LevKushnir @husone @Yoichi any approach guys or sample workflow

From your image and selector, that is not a table. It looks like a table, but it’s an ALV list, which is just a collection of labels.
@LevKushnir found an alternative approach that might work for you. Go in the menu Settings → Switch List and SAP will display a proper table. On that you can use Table Cell Scope or other activities that suit your needs. You will also have absolute row indices in the table.
Let us know if switching to a normal table works for you and if you need further guidance.

1 Like

Can you make a replica demo of those steps it will be more helpful…

hi @Darkfighter

SAP Grid Table are perfectly suitable for automation. Read more here: https://docs.uipath.com/studio/standalone/2024.10/user-guide/supported-sap-wingui-elements#sap-grid-table

We (UiPath) have full control and information about all elements and their attributes in such tables.

Check the filtering here: Studio - Supported SAP WinGUI Elements

This should suite you exact needs.

Best regards, Lev