During a recent project a requirement was identified for directly uploading data from MS Excel into SAP BW. Various options were considered to address this requirement; amongst others:
SAP BW IP Planning Layout, which would have been too expensive to develop and maintain.
High frequency flat-file uploads, which was deemed too tedious from an end-user perspective.
Making a Remote Function Call (RFC) through VBA to a Function Module (such as RSDRI_ODSO_INSERT_RFC) in SAP BW. Even though I have done this before this technique requires the SAP GUI to be installed on the user’s desktop.
Instead I decided to create a Web Service DataSource with Real-time Data Acquisition to stage the data in SAP BW. The challenging bit was creating the client-side VBA to generate the required XML and then to make a call to the SAP BW Web Service. I have previously done bits of this in VBA, but I have never before attempted to make a call to a SAP BW DataSource from VBA.