Tasting the mix of Python and SAP – Volume 3

Hello and welcome back to this little corner of Scripting Languages fun -:)

Today, we’re going to see how can we use wxPython and SAP to make an SE16 emulation.

So, what’s wxPython? It’s a Python wrapper of the C++’s wxWidgets that allows us to create rich UI applications.

For this blog I was tempted to use Tkinter but gotta admit that I like wxPython more…as I have already used it in my Ruby projects. Anyway in Ruby it was a little bit easier than in Python -:P

Enough talk, let’s go to the source code…(That could fit nice on a T-Shirt, right?)

Again, and as always in my Python/SAP projects…I used YAML to host the SAP connections parameters.

sap.yml

ashost: localhost sysnr: “00” client: “001” lang: EN trace: 1 loglevel: warn

import wx import sapnwrfc import wx.grid as wxGrid conn = “” table = “” class MyApp(wx.App): def OnInit(self): self.frame = MyFrame(None, title=”Login”) self.SetTopWindow(self.frame) self.frame.Show() return True class MyFrame(wx.Frame): def __init__(self, parent, id=wx.ID_ANY, title=””, pos=wx.DefaultPosition, size=(210, 150), style=wx.DEFAULT_FRAME_STYLE, name=”MyFrame”): super(MyFrame, self).__init__(parent, id, title, pos, size, style, name) self.panel = wx.Panel(self) self.text_font = wx.Font(12, wx.DEFAULT, wx.NORMAL, wx.NORMAL) self.t_user = wx.StaticText(self.panel, -1, “User”, size=(40, 20), pos=(10, 12)) self.t_password = wx.StaticText(self.panel, -1, “Password”, size=(40, 20), pos=(10, 32)) self.t_user.SetFont(self.text_font) self.t_password.SetFont(self.text_font) self.user = wx.TextCtrl(self.panel, value=””, pos=(90, 10)) self.password = wx.TextCtrl(self.panel, value=””, pos=(90, 30), style=wx.TE_PASSWORD) self.btnConnect = wx.Button(self.panel, label=”Connect”, pos=(70, 80)) self.Bind(wx.EVT_BUTTON, self.OnButtonConnect, self.btnConnect) def OnButtonConnect(self, event): global conn user = self.user.GetValue() password = self.password.GetValue() sapnwrfc.base.config_location = “sap.yml” sapnwrfc.base.load_config() conn = sapnwrfc.base.rfc_connect({‘user’: user, ‘passwd’: password}) self.Close() myGrid = GridFrame(None, title=”SE16 Emulator”) myGrid.Show() class GridFrame(wx.Frame): def __init__(self, parent, id=wx.ID_ANY, title=””, pos=wx.DefaultPosition, size=(600, 400), style=wx.DEFAULT_FRAME_STYLE, name=”GridFrame”): super(GridFrame, self).__init__(parent, id, title, pos, size, style, name) self.panel = wx.Panel(self) self.text_font = wx.Font(12, wx.DEFAULT, wx.NORMAL, wx.NORMAL) self.t_table = wx.StaticText(self.panel, -1, “Table”, size=(40, 20), pos=(180, 12)) self.t_table.SetFont(self.text_font) self.table = wx.TextCtrl(self.panel, value=””, pos=(225, 10)) self.btnShow = wx.Button(self.panel, label=”Show Table”, pos=(330, 10)) self.Bind(wx.EVT_BUTTON, self.OnButtonShow, self.btnShow) def OnButtonShow(self, event): global conn table = self.table.GetValue() fields = [] fields_name = [] func_disc = conn.discover(“RFC_READ_TABLE”) func = func_disc.create_function_call() func.QUERY_TABLE(str(table)) func.DELIMITER(“|”) func.invoke() data_fields = func.DATA.value data_names = func.FIELDS.value long_fields = len(func.DATA()) long_names = len(func.FIELDS()) for line in range(0, long_fields): fields.append(data_fields[line][“WA”].strip()) for line in range(0, long_names): fields_name.append(data_names[line][“FIELDNAME”].strip()) self.grid = wxGrid.Grid(self.panel, pos=(0, 40), size=(853, 320)) self.grid.EnableEditing(False) self.grid.CreateGrid(long_fields, long_names) for line in range(0, long_names): field_name = fields_name[line] self.grid.SetColLabelValue(line, field_name) for line_f in range(0, long_fields): data_split = fields[line_f].split(“|”) for line_n in range(0, long_names): self.grid.SetCellValue(line_f, line_n, data_split[line_n]) def onClose(self, event): global conn conn.close() if __name__ == “__main__”: app = MyApp(False) app.MainLoop()

Now, the images:

So basically, what we have here is a Login screen with the Username and Password and a connection button. When we connect to SAP, then the window dissapeared and a new window pops out. This new windows ask us for a table name and displays a grid containing all the information.

See ya next time -;)

2 Comments

You must be Logged on to comment or reply to a post.

Steve Oldner July 18, 2011 at 2:51 am

Haven’t used wx, this make me want to try it. What version Python?

like (0)
1. Alvaro Tejada Galindo Post authorJuly 18, 2011 at 3:34 am
  
  Steve:
  
  I’m using the same version as before -:) Python 2.6 mostly because the only Python:RFC that I found compiled for Windows as an installer was for that version -;)
  BTW, I’m glad you enjoyed my blog -;)
  
  Greetings,
  Blag.
  
  like (0)