topic RE: SAP Gridview Capturing in Product Forum

SAP Gridview Capturing

AsitabhaDeb — Mon, 16 Nov 2020 05:27:00 GMT

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
------------------------------

RE: SAP Gridview Capturing

JanSkarbek — Mon, 16 Nov 2020 13:10:00 GMT

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

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

RE: SAP Gridview Capturing

zdenek.kabatek — Mon, 16 Nov 2020 14:04:00 GMT

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
------------------------------

RE: SAP Gridview Capturing

AsitabhaDeb — Mon, 16 Nov 2020 15:16:00 GMT

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
------------------------------

RE: SAP Gridview Capturing

_Amlansahoo — Mon, 16 Nov 2020 18:08:00 GMT

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
------------------------------

RE: SAP Gridview Capturing

AsitabhaDeb — Mon, 23 Nov 2020 13:21:00 GMT

Hello Experts,

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

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

RE: SAP Gridview Capturing

zdenek.kabatek — Mon, 23 Nov 2020 15:51:00 GMT

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
------------------------------

RE: SAP Gridview Capturing

AsitabhaDeb — Tue, 24 Nov 2020 00:58:00 GMT

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
------------------------------

RE: SAP Gridview Capturing

StefanSchnell — Tue, 24 Nov 2020 14:17:00 GMT

@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
------------------------------

RE: SAP Gridview Capturing

AsitabhaDeb — Wed, 25 Nov 2020 01:05:00 GMT

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
------------------------------

RE: SAP Gridview Capturing

zdenek.kabatek — Wed, 25 Nov 2020 07:51:00 GMT

Hi, Asitabha,

as Stefan said - this is ABAP List with Labels so it will be difficult to make it work any other way than saving the content into file and then read the file back into BP and process it. And yes if there is 50 sales orders (SO) you need to do it 50 times. If you need help with the second part - processing file - let us know - as there are prepared actions in Utilities - File Management VBO.

Regards,

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

RE: SAP Gridview Capturing

AsitabhaDeb — Wed, 25 Nov 2020 08:47:00 GMT

HI Zdeněk ,

Let me try with the way as you both mentioned.
Thanks for the help. I will also try the Action Utilities - FM VBO.

As you can see after I paste it to excel the date of Receive Row will be (For e.g H5), for another Order the Cell No of Receive will be H10.
Can you please help me how to copy the "Different date from different cell no and paste it to another excel"

For E.g - I need to copy Received date 10/14 from H5 Cell and paste it another excel cell Value will be Suppose D2.
For next order Receive date will be suppose 10/20 from H10 Cell No and paste it another excel with Cell No D3.

Because the destination file I have, list of Sales Order with Column Name "Received Date" and I need to paste Receive date of 50 orders (Which one is early Date) from this SAP screen and paste in that Excel. I need to copy all the fields from this SAP screen and paste in the excel (First Date and Last Date).

Quite trick process.

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

RE: SAP Gridview Capturing

EduardoGS_Carva — Fri, 28 May 2021 17:26:00 GMT

Hello, good day, @StefanSchnell

Would you kindly inform what is this program you are using to read SAP Script ID and Text?

Thank you so much!

Regards

------------------------------
Eduardo
------------------------------

RE: SAP Gridview Capturing

StefanSchnell — Sat, 29 May 2021 04:17:00 GMT

@EduardoGS_Carva

Hello Eduardo,

sure, it is Scripting Tracker, I develop this program since nearly 9 years. It is an analyzer for SAP GUI for Windows screens, a recorder for SAP GUI Scripting, an SAP GUI Scripting API viewer and much more in the context of automating SAP GUI for Windows.

You can find Scripting Tracker at my site.

Best regards
Stefan

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

RE: SAP Gridview Capturing

EduardoGS_Carva — Sat, 29 May 2021 20:15:00 GMT

@StefanSchnell

Congratulations, very nice work!

I tought it was similar to AHK SAP ScreenReader, but it's more advanced!

------------------------------
Eduardo
------------------------------

RE: SAP Gridview Capturing

StefanSchnell — Mon, 31 May 2021 05:12:00 GMT

Thank you very much @EduardoGS_Carva

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