How to find the table ID in SAP and copy to excel?

[knight999]

Hi ,

Can anybody tell me how to find out the table ID in SAP ?

Cells(1,1) = Session.findById("?").Text

Type in my query and new sap window popup which shows the data i need. I want to copy that data to excel but i just don't know how to get the ID.

thanks for your help

Rookie

[Sandra_Rossi]

SAP provides an EXE program (and Stefan has one in his own web site too) to display the ID of all fields in the current screen -> cf note 1441550 - SAP GUI scripting: Sample applications

[Stefan-Schnell]

Hello Rookie,

here a tiny approach to detect a GuiTableControl ID on the UserArea.

Set UserAreaChildren = session.findById("wnd[0]/usr").Children
For Each Child In UserAreaChildren
  If Child.TypeAsNumber = 80 Then '80 = GuiTableControl
    MsgBox Child.ID
  End If
Next

Best regards
Stefan

[former_member713672]

Thanks a lot Stefan, it worked and rightly said, am a Rookie 🙂 I see you all over the internet, and i appreciate if you could provide me with links to your resources or any books you have written on SAP Scripting or SAP Automation - Hara