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 -;)