topic Search Correct No in SAP in Product Forum

Search Correct No in SAP

AsitabhaDeb — Thu, 10 Dec 2020 14:11:10 GMT

HI Experts,

In my process There are 5 component no in SAP.
Out of that 5no, 1 component no is in another excel file. (Source Excel File)
My requirement is BOT will match the correct component no from SAP and Source excel and after find the correct component no BOT will double click on the line no.

I hope I make you understand.
Attachment for ref.
I need to click on line# 2 because that component is matching with my source excel file.
For next material# line# can be change.

NEED TO CLICK ON LINE# NOT IN COMPONENT#.

BR/Deb

Re: Search Correct No in SAP

expertcr — Fri, 16 Apr 2021 19:34:59 GMT

I think your problem is to click one of the elements in that table?
Without thinking in Excel, can you click with no problems in these elements in SAP?

Re: Search Correct No in SAP

remko.bouwens — Mon, 26 Apr 2021 15:09:00 GMT

When working in SAP, you can use three ways (I can think of) to find it.
1. Setting a filter, using the component no as filter. This should leave one result (you check this by reading the cell value of the first row).
2. Using the FIND (Ctrl+F or the binocular button) menu and search for the component no. After searching it should highlight/select your component no.
3. Loop through the list until you find the correct value (if you are able to spy all cells(.