Question Re: Loop though specific table column and select row when found in Technology Q&A

Loop though specific table column and select row when found

former_member549453 — Mon, 15 Mar 2021 10:40:10 GMT

If I want to update specific quota I need to script to check for the Quota Arr. Number column in below displayed table. If the number is same as in excel input file (COL3) than it should select the same row as the number is found. In below example it should select row 2.

I tried below code but the script stops at: session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]").text

Runtime error ‘619’:

The control could not be found by id.

i = 0

Do

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]").text
session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3," & CStr(i) & "]").caretPosition = 5

If session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]").text = COL3 then

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205").getAbsoluteRow(i).selected = true

Exit Do
End if

i = i + 1

Loop

Re: Loop though specific table column and select row when found

Sandra_Rossi — Mon, 15 Mar 2021 13:45:15 GMT

Error easy to find, check twice your code before asking 😉

"wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]"

Re: Loop though specific table column and select row when found

former_member549453 — Mon, 15 Mar 2021 13:59:41 GMT

I found the error line as well. It's stated in my post. Read my post twice before commenting 😉

Re: Loop though specific table column and select row when found

MateuszAdamus — Mon, 15 Mar 2021 14:23:32 GMT

Hello

What is this line for?

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]").text

You're not assigning read value nor setting any new value. What is it for?

Why aren't you concatenating the i value to ID string all the time as you do in the IF statement?

Might be good to have a local variable with the ID concatenated string and use that variable everywhere.

Kind regards,

Mateusz

Re: Loop though specific table column and select row when found

former_member549453 — Mon, 15 Mar 2021 16:53:46 GMT

Thank you Mateusz!

Updated code like this instead. Still don't know what

CStr(i) exactly does but it certanly seems to do the trick 🙂

i = 0

Do

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3," & CStr(i) & "]").caretPosition = 5
If session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3," & CStr(i) & "]").text = COL3 then
session.findById("wnd[0]/usr/tblSAPDM06QTC_0205").getAbsoluteRow(i).selected = true

Exit Do
End if

i = i + 1

Loop

Re: Loop though specific table column and select row when found

Sandra_Rossi — Mon, 15 Mar 2021 19:25:59 GMT

What I meant is that in the line below that line, you have solved the error ([3," & CStr(i) & "]"), so it's just that you didn't check twice 😉

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3," & CStr(i) & "]").caretPosition = 5

Re: Loop though specific table column and select row when found

former_member549453 — Mon, 15 Mar 2021 20:06:57 GMT

Thanks! I whish it was that easy though. I just copied from something that looked similar when googled. It didn't work for my code. Much easer to find the error if you know what to look for 🙂

Re: Loop though specific table column and select row when found

MateuszAdamus — Tue, 16 Mar 2021 07:59:12 GMT

It's always good to check the documentation: https://docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/functions/type-conversion-functions#cstr-example

Kind regards,
Mateusz

Re: Loop though specific table column and select row when found

former_member549453 — Wed, 17 Mar 2021 18:27:16 GMT

Hello

If want the script to loop through Valid from, Valid to and Quota Arr. Columns (3 columns) to find exact match before selecting the row can same approach be used?

The solution is more for a Source List ME01. For this t code the script would need to check for exact match in 6 diffrent columns. Valid from, Valid to, Vendor ID, Agreement, Line item and MRP. Basically same as above but with more columns to check for exact match.

I did several tries today with no success.

Re: Loop though specific table column and select row when found

former_member549453 — Fri, 19 Mar 2021 12:22:35 GMT

Here is my best try.

It gives error: The conrol could not be found by id. Code:800A026B on session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-VDATU[0," & CStr(i) & "]").caretPosition = 0

i = 0
Do
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-VDATU[0," & CStr(i) & "]").caretPosition = 0'Valid From date

session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-BDATU[1," & CStr(i) & "]").caretPosition = 0'Valid To date
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-LIFNR[2," & CStr(i) & "]").caretPosition = 0'Vendor ID
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-EBELN[6," & CStr(i) & "]").caretPosition = 0'Agreement number
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-EBELP[7," & CStr(i) & "]").caretPosition = 0'Item line
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-AUTET[10," & CStr(i) & "]").caretPosition = 0 'MRP flag


If session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-VDATU[0," & CStr(i) & "]").Text = COL3 AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-BDATU[1," & CStr(i) & "]").Text = COL4 AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-LIFNR[2," & CStr(i) & "]").Text = COL5AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-EBELN[6," & CStr(i) & "]").Text = COL7 AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-EBELP[7," & CStr(i) & "]").Text = COL8 AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-AUTET[10," & CStr(i) & "]").Text = COL12  Then


session.findById("wnd[0]/usr/tblSAPLMEORTC_0205").getAbsoluteRow(i).selected = true 


Exit Do
End if
i = i + 1
Loop

Re: Loop though specific table column and select row when found

former_member549453 — Fri, 19 Mar 2021 13:02:36 GMT

Am I on the right track or is diffrent approach needed? 🙂