Script to copy ABC Indicator in the IL03 Panel

[former_member1004437]

I'm trying to write a script to copy the value in the ABC Indicator field from the IL03 panel. So far I can launch SAP from an excel macro, go to the IL03 using a functional location that I specify in Excel, but from here I'm lost. Once I get to the IL03 panel, how do I take the value in the ABC Indicator field and put it in either the clipboard or directly into an Excel cell?

' Opens SAP

Dim SapGuiAuto
    Dim SetApp
    Dim Connection
    Dim Session

    Set SapGuiAuto = GetObject("SAPGUI")
    Set SetApp = SapGuiAuto.GetScriptingEngine
    Set Connection = SetApp.Children(0)
    Set Session = Connection.Children(0)
    
'Goes to IL03 Panel

Session.findById("wnd[0]").resizeWorkingPane 169, 41, False
Session.findById("wnd[0]/tbar[0]/okcd").Text = "/nIL03"
Session.findById("wnd[0]").sendVKey 0

'Inserts Value from Functional Location in Excel

Session.findById("wnd[0]/usr/ctxtIFLO-TPLNR").Text = Sheet1.Cells(9, 3).Value
Session.findById("wnd[0]").sendVKey 0

I can see that the field appears to be F[T370C_T-ABCTX] with location [11,31], but I'm not sure what do with that.

[mynynachau]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards

Mynyna

SAP Community moderator

[former_member1004437]

Ok so I've got the ABC indicator stored as a variable now.

ABCIndicator = Session.findById("wnd[0]/usr/tabsTABSTRIP/tabpT\01/ssubSUB_DATA:SAPLITO0:0102/subSUB_0102A:SAPLITO0:1050/ctxtITOB-ABCKZ").Text

Now to get it out to an excel cell.

[mynynachau]

Your question was alerted for containing an incorrect tag. SAP Engineering Control Center doesn't seem to be correct. Could you please select the most suitable tag?

Thanks.