Get Company codes form SAP Sytem using BAPI Private Sub CommandButton1_Click()If login = False Then’ Setting the necessary variables for R/3 connectionSet objBAPICortrol = CreateObject(“SAP.Functions”)Set objConnection = objBAPICortrol.Connection’ Establish a connectionIf objConnection.Logon(0, False) Then login = True MsgBox “Connection Established” CommandButton1.Caption = “Disconnect”End IfElseCommandButton1.Caption = “Connect 2 SAP”login = FalseobjConnection.LogoffSet objConnection = NothingSet objBAPICortrol = NothingEnd IfEnd Sub ‘ Declaration for the necessary objectsDim objBAPICortrol, objConnection, objCompan圜odes As ObjectDim login As BooleanĬonnecting and Disconnecting to SAP System

Here the source code is broken as per their operation. This application will fetch all the company codes from the SAP System. There are many other SAP ActiveX Components which will provide you a very rich functionality.įor this test application a simple form as shown below is required. Here we are using the SAP BAPI ActiveX Component and SAP Table Factory ActiveX Component to access SAP and fetch some data to display in Excel. You can find all the availabe SAP controls in the Controls ToolBox of Excel. These SAP ActiveX Components will be available if the SAP Front End is installed in your machine. The first important thing is to add the required SAP ActiveX Components to Microsoft Excel. This weblog explains how to make Remote Function Calls to SAP system with a much familiar Microsft Excel.Īdd the necessary SAP ActiveX Components to Excel We have quite a few techniques to make RFC to SAP using connectors like JCo. Remote Function Call to SAP System is quite important and useful feature when we require SAP data for a non SAP application. run over the dynamic result table and pull out the values and insert into corresponding Excel cellsįor (r=4 rcolumns = tbldisplay.getElementsByTagName('th')

Var rows = tbldisplay.getElementsByTagName('tr') Store the sheet header names in an array Var xlApp = new ActiveXObject('Excel.Application') I have some Javascript code, that sucessfully exports Project data from an HTML table to an Excel SpreadSheet:

Activex microsoft excel 2011