ME51 Textbox Value

[Former Member]

I'm trying to auto populate the ME51 screen from my Excel VBA. Basically, I'll input all the data on my excel, and when I hit the button it will populate the ME51 screen.

Document Type: <default>

Item Category: <default>

Acct Assignment Cat.: <default>

Delivery Date: <default> + <date today>

Plant: <from excel column R>

Purchasing Group: <from excel column Q>

Material Group: <default>

End Receiver: <from excel column D>

I have here a code when I click the button it will auto open my SAP, then go to my server and fill up my credentials and logins. What is the "wnd[0]/usr/txtRSYST-MANDT" of ME51 for each text box? I'll try to play with it.

session.findById("wnd[0]/usr/txtRSYST-MANDT").Text ="750"
session.findById("wnd[0]/usr/txtRSYST-BNAME").Text ="TID" ' change
session.findById("wnd[0]/usr/pwdRSYST-BCODE").Text ="PASSWORD" ' change
session.findById("wnd[0]/usr/txtRSYST-LANGU").Text ="EN"
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]").maximize
session.findById("wnd[0]/tbar[0]/okcd").Text ="/nzca_tbl" 'change
session.findById("wnd[0]").sendVKey 0