Read SAP Tables into DataTables

Sonal Patil

Hi,

I need help with SAP Table reading. I have requirement of reading SAP table into DataTable and then loop through DataTable for processing. There is no SAP activity to read entire SAP Table into DataTable. Has anyone done this before? Please help me to achieve this requirement.

Thanks in advance

Allan Zimmermann

SAP is still in beta ( I lost access to sap, so couldn't finish it )
The sap addon kind of consist of 2 addons. First I added support for recording raw SAP GUI Scripting commands using Get Property, Set Property, Invoke Method.
To the best of my knowledge this works for all sap clients with no issues.
This is the default, you are using this if you have "Get elements disabled"

Then I started adding a more "openrpa way" of working with SAP using Get element, this would allow to add things more complex things, like getting data out in a datatable. This is NOT completed, and specifically it cannot find and work with data tables or gui trees with to many leaf levels. For most basic UI elements you can still interact with those using Get Element. Using the the recorder in "get element" is so slow, I would consider it broken in it's current state.
Get Element it self is fine and it's super handy having access to the "Open Selector" and browse though the UI, but using the recorder is not a good experience.

Using for each loops ( and remembering to set focus once in a while, to by pass lazy loading in tables ) works well for grabbing data, but it's does require a little bit more work, than just pointing to a table and selecting "extract"