SQL 2003

["SQL:2003 has finally achieved final publication as an International Standard, replacing SQL:1999. SQL:2003 is popularly believed to be largely a “bug-fix release” of the SQL standard — except, of course, for the SQL/XML work on which we have previously reported."]

Hot APO

SearchSAP.com: Jon Reed interview ["SAP CRM is the hottest area -- followed by SAP SCM and SAP APO. The overall CRM market is on the rebound, and SAP's own CRM product is becoming progressively more sophisticated. Any area of supply chain management is on fire right now. Companies are trying to get their supply chain updated online in real-time updates from retailers about customer demand and SAP Advanced Planner and Optimizer will be part of that."]

Python and SAP (take II)

The pysaprfc module by Klavdij Voncina is quite a clever way to connect python and SAP systems. The module is pure python using ctypes. No need to build and link librfc!

A quick example from the prompt:

>>> import pysap
>>> sap_conn=pysap.Rfc_connection(conn_file='c:/tmp/sapconn.ini')
>>> sap_conn.open()
>>> f=sap_conn.get_interface('RFC_GET_TABLE_ENTRIES')
>>> f['TABLE_NAME']='T005T'
>>> itab.append_from_table(f['ENTRIES'])
>>> f['MAX_ENTRIES']=20
>>> rc=f('TABLE_NAME','MAX_ENTRIES','ENTRIES')
>>> itab=sap_conn.get_table('T005T')
>>> itab.append_from_table(f['ENTRIES'])
>>> for row in itab: print '%(landx)s' % row
... 
Andorra
Ver.Arab.Emir.
Afghanistan
Antigua/Barbuda
Anguilla
Albanien
Armenien