Question Re: Going through a table in SAP returns errors in Technology Q&A

Going through a table in SAP returns errors

Former Member — Mon, 27 Aug 2018 20:34:51 GMT

Hi,

I have been struggling with understanding how to loop through a table in SAP. Just to give some context, here is what I basically need to do:

1. Go to a page in SAP with a table

2. Double click on a line, which brings me to a window with values that I need to copy and insert it in a spreadsheet.

3. Loop through an entire table in the same fashion and repeat a procedure.

The object I am going through has the following code:

Session.FindById("wnd[0]/usr/cntlUSAGE_TREE_CONTAINER/shellcont/shell/shellcont[1]/shell").selectedNode = " 5" Session.FindById("wnd[0]/usr/cntlUSAGE_TREE_CONTAINER/shellcont/shell/shellcont[1]/shell").doubleClickNode " 5"

I am new to SAP and googled many instances already. I still have not figured out how to write the code in my case. Any recommendations will be appreciated.

My code returns error "The object does not support this property or method" (RowCount)

Dim Table As Object
Dim rows As Long
Dim i As Long

Set Table = Session.FindById("wnd[0]/usr/cntlUSAGE_TREE_CONTAINER/shellcont/shell/shellcont[1]/shell[1]")
rows = Table.RowCount - 1

For i = 0 To rows
Session.FindById("wnd[0]/usr/cntlUSAGE_TREE_CONTAINER/shellcont/shell/shellcont[1]/shell").selectedNode = "          i"
Session.FindById("wnd[0]/usr/cntlUSAGE_TREE_CONTAINER/shellcont/shell/shellcont[1]/shell").doubleClickNode "          i"

Next i

Re: Going through a table in SAP returns errors

Stefan-Schnell — Thu, 30 Aug 2018 05:47:45 GMT

Hello Olesia,

welcome in the SAP Community.

Are you sure that you are using a table...

...or an ALV-Grid?

An ALV-Grid is a GuiShell with the SubType GridView, like in your example. The table is GuiTableControl and, in a normal case, without a shell. That would explain why the RowCount property is not available.

Let us know your results.

Cheers
Stefan

Re: Going through a table in SAP returns errors

Former Member — Mon, 03 Sep 2018 21:36:57 GMT

Hello Stefan,

I figured that. Indeed, my object was a tree. However, I have also grids and tables. I am wondering if there is a difference in declaring grids and tables. I am currently trying to find column names for a grid.

My grid goes under the line: session.findById("wnd[0]/usr/lbl[6,5]") I am trying to figure how to find the column identifiers for this grid. Just a click on the column heading returns the same line with [6,5] at the end.

Thank you for your help!