Question Re: SAP GUI with Python: Failed to get value from SAP using session.findById().text in Technology Q&A

SAP GUI with Python: Failed to get value from SAP using session.findById().text

former_member716327 — Tue, 01 Dec 2020 20:45:42 GMT

Hi there,

I've just started using python to automate SAP GUI scripting (have been using VBA for that). However, it wouldnt work when I was trying to extract data from SAP.

In this case I was trying to get the value contract number in T-code VA03-Additional Data B.

I suppose this is probably little things i have completely ignored but would be good if someone can point it out...

It seems this particular field cannot be found by Python. However i tried the same method and it worked with VBA very well.

Here's the code:

# Import modules
import sys
import win32com.client


# SAP function
def sapconnection():
    try:

        SapGuiAuto = win32com.client.GetObject("SAPGUI")
        if not type(SapGuiAuto) == win32com.client.CDispatch:
            return

        application = SapGuiAuto.GetScriptingEngine
        if not type(application) == win32com.client.CDispatch:
            SapGuiAuto = None
            return

        connection = application.Children(0)
        if not type(connection) == win32com.client.CDispatch:
            application = None
            SapGuiAuto = None
            return

        session = connection.Children(0)
        if not type(session) == win32com.client.CDispatch:
            connection = None
            application = None
            SapGuiAuto = None
            return

        # Check VC number
        session.findById("wnd[0]").maximize()
        session.findById("wnd[0]/tbar[0]/okcd").text = "/nva03"
        session.findById("wnd[0]").sendVKey(0)
        session.findById("wnd[0]/usr/ctxtVBAK-VBELN").text = soNbr  #HERE IS WHERE I PUT THE SO
        session.findById("wnd[0]").sendVKey(0)
        session.findById("wnd[0]/mbar/menu[2]/menu[1]/menu[14]/menu[1]").select()
        #HERE IS WHERE IT THROWS AN ERROR
        vc = session.findById("wnd[0]/usr/tabsTAXI_TABSTRIP_HEAD/tabpT\13/ssubSUBSCREEN_BODY:SAPMV45A:4312/sub8309:SAPMV45A:8309/txtVBAK-ZZCON").text

    except:
        #print(sys.exc_info()[0])
        print(sys.exc_info())

    finally:
        session = None
        connection = None
        application = None
        SapGuiAuto = None

#main
if __name__ == "__main__":
    sapconnection()

Re: SAP GUI with Python: Failed to get value from SAP using session.findById().text

Former Member — Tue, 01 Dec 2020 20:46:11 GMT

Thank you for visiting SAP Community to get answers to your questions. Since you're new in asking questions here, 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 now by selecting Actions, then Edit.

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

Mariah

SAP Community moderator

Re: SAP GUI with Python: Failed to get value from SAP using session.findById().text

Sandra_Rossi — Wed, 02 Dec 2020 06:44:01 GMT

What error message do you get?

Could you check whether the issue is about getting the menu object, or calling the method?

Re: SAP GUI with Python: Failed to get value from SAP using session.findById().text

Stefan-Schnell — Fri, 04 Dec 2020 04:44:47 GMT

vincentthelibra

Hello,

your code works so far, I tried it on my test system. But there is an error in your string.

"wnd[0]/usr/tabsTAXI_TABSTRIP_HEAD/tabpT\13/ssubSUBSCREEN_BODY:SAPMV45A:4312/sub8309:SAPMV45A:8309/txtVBAK-ZZCON"

The string contains a backslash and it is necessary to escape them. Try it on this way...

"wnd[0]/usr/tabsTAXI_TABSTRIP_HEAD/tabpT\\13/ssubSUBSCREEN_BODY:SAPMV45A:4312/sub8309:SAPMV45A:8309/txtVBAK-ZZCON"

...and let us know your result.

Best regards
Stefan

Re: SAP GUI with Python: Failed to get value from SAP using session.findById().text

former_member716327 — Fri, 04 Dec 2020 09:58:04 GMT

I think it was a "control ID not found" type of error. but it seems, like Stefan said below, to be a simple error of not escaping the backslash... will try again with the correct string... thanks anyway.

Re: SAP GUI with Python: Failed to get value from SAP using session.findById().text

former_member716327 — Fri, 04 Dec 2020 10:28:42 GMT

Thanks this is exactly the mistake...I knew it would be a very basic mistake. 😞