SAP Gridview Capturing

[AsitabhaDeb]

Hi Experts,

I would to like to capture below SAP Grid View screen for my automation and transfer this data in to collection.
Can you please help me to do that.  It's capturing as a label but no action showing under the label.
Any VBA code can help me to accomplish this. Please reply ASAP. 

Please download the attachment.

------------------------------
Asitabha Deb
------------------------------

[JanSkarbek]

I think the best approach would be to download this as an Excel file and create a collection from there.

------------------------------
Jan Skarbek
------------------------------

[ZdeněkKabátek]

Hi,

as recommended by @JanSkarbek if you can export to Excel that would be the best. The other option could be if you can change the view to be "true" Grid. As far as I know this is just textual representation of the grid and it is very difficult to work with it. But usually this can be converted into "true" Grid and with that you can work pretty well - moving by lines, extracting to collection, etc.

Regards,
​

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

[AsitabhaDeb]

Thanks Zdeněk for your suggestion.

I will try to do it. It will be very help full if you can help me to understand how to convert this to "True" Grid.
I cannot see any option in that screen.


------------------------------
Asitabha Deb
------------------------------

[_Amlansahoo]

Hi Deb,

You can turn on SAP recorder and get the table name by performing some action. Then it will generate VBScript. You can easily convert it VB.net

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

[AsitabhaDeb]

Hello Experts,

Can anybody help me on my issue. 
Still not yet solve.

------------------------------
Asitabha Deb
------------------------------

[ZdeněkKabátek]

Hi, Asitabha,

happy to jump on a call with shared screen and look at it. I do not have SAP access at my disposal 😉 so I can't show it to you at this moment. If you can take a few screen shots from menus I may help you navigating to the right option. Or there might not be that option for that particular screen.

Regards,

Zdenek

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

[AsitabhaDeb]

Hi Zdenek,

Please  find the attachment. I want to capture this SAP grid view data and convert it into collection.
IF you can help me with any code it will be very helpful.


------------------------------
Asitabha Deb
------------------------------

[StefanSchnell1]

@Asitabha Deb​

Hello Asitabha,
it is not a grid view, it is an ABAP standard list with labels. Labels contains the data.

As @Zdeněk Kabátek wrote, store the data as local file ...

... and work with the file.

Best regards
Stefan
​​

------------------------------
Stefan Schnell
Senior Systems Engineer at BWI GmbH
------------------------------

[AsitabhaDeb]

Hi stefan,

Thanks for clarification, I have put only one sales order details, there will be min 50 sales order's data need to generate every time. Do you want every time BOT will save the file in system from this screen?
Or do you have any other idea.
Please let me know.

------------------------------
Asitabha Deb
------------------------------