SAP Integration

[girabor]

Hi everyone,

I'm currently working on an automation involving an SAP interface and I'm having some difficulty interacting with a table where reports/files are listed for download.

Blue Prism is able to identify the whole table using SAP Mode, and these are the attributes when spied as a full table:

ComponentType = GuiShell
ID = /app/con[0]/ses[0]/wnd[0]/usr/cntlGRID_CONT0050/shellcont/shell
SubType = GridView

However, I'm unable to individually identify or read a specific row or column within the table. What I'm trying to achieve is to dynamically identify the position/row of each file in the table so that Blue Prism can select and download the correct report.

I don't want to rely on a fixed row position using Region Mode, since new files can be added to the table, which would shift the positions. I've tried making a Region Mode-spied row dynamic so the automation could identify different rows based on the report/file name or its position, but I haven't been able to achieve this.

Ideally, I'd like the process to identify a newly added file based on its name or variant name and right-click to download the corresponding report, regardless of where it appears in the table.

Has anyone worked with a similar SAP interface scenario in Blue Prism, or knows of a recommended approach for dynamically identifying the row/position of a specific file in a GuiShell/GridView table?

Any guidance or examples would be greatly appreciated. Thanks!

[Denis__Dennehy]

So, there were always some SAP element types that were not open to the SAP interface which mean we had to use Surface Automation.

For a certain large energy customer I had to create a couple of reusable object assets that had inputs that could be used to decipher the item in the table to search for or click on - the action would then use surface automation to very rapidly grab the rows in the table, check those items to see if it was the items required, go to the next page of the table if not found.  It would return coordinates for future actions with the row to be done.
From memory the tables in question looked more like treeviews.

[plnarayana777]

Hi,

Not sure if you found the solution 

Look for these possibilities

1. Check if your screen has find icon > click on it > search the name > ok > click on "Position cursor" > use send key V2 to click on the position cell

2. Try to use record option then click on cell ( note the column and row positions for 4 to 5) check the pattern then using this dynamically to read the read the cell value and click to download

Hope this helps