R/3 RFC from MS Office Via Visual Basic

The Microsoft Office suite incorporates with Visual Basic for Applications (VBA) a fully object oriented language. JavaScript and JAVA are naturally object oriented. Therefore you can easily connect from JavaScript, JAVA, WORD, EXCEL and all the other VBA compliant software to R/3 via the CORBA compatible object library (in WINDOWS known also DLLs or ACTIVE-X (=OLE/2) components).

Visual Basic is finally designed as an object oriented language compliant to DCOM
standard.

JavaScript is a typical object oriented language which is compliant to basic CORBA,
DCOM and other popular object standards.

SAP R/3 provides a set of object libraries, which can be registered with Visual
Basic. The library adds object types to VBA which allow RFC calls to R/3.
The libraries are installed to the workstation with the SAPGUI installation. They are
technically public linkable objects, in WINDOWS these are DLLs or ACTIVE-X
controls (which are DLLs themselves).

The object library SAP contains among others the object type FUNCTIONS whose
basic method CALL performs an RFC call to a specified R/3 function module. With
the call you can pass object properties which will be interpreted as the interface
parameters of the called function module.

If the RFC call appear not to be working, you should first try out to call one of the
standard R/3 RFC function like RFC_CALL_TRANSACTION_USING (calls a
specified transaction or RFC_GET_TABLE (returns the content of a specified R/3
database table).

SAP R/3 provides a set of object libraries, which can be registered with JavaScript
to allow RFC calls to R/3.

The object library SAP contains among others the object type FUNCTIONS whose
basic method CALL performs an RFC call to a specified R/3 function module.
If the RFC call appears to be not working, you should first try out to call one of the standard R/3 RFC functions like RFC_CALL_TRANSACTION_USING (calls a
specified transaction) or RFC_GET_TABLE (returns the content of a specified R/3
database table).



Call Transaction From Visual Basic for WORD 97

This is a little WORD 97 macro, that demonstrates how R/3 can be called with a mouse click directly from within WORD 97.

This macro calls the function module RFC_CALL_TRANSACTIION_USING .
This function executes a dynamic call transaction using the transaction code
specified as the parameter.

You can call the macro from within word, by attaching it to a pseudo-hyperlink.
This is done by adding a MACROBUTTON field to the WORD text. The macrobutton statement must call the VBA macro R3CallTransaction and have as the one and only parameter the name of the requested transaction MACROBUTTON R3CallTransaction VA02
This will call transaction VA02 when you click on the macrobutton in the text
document. You can replace VA02 with the code of your transaction.


R/3 RFC from JavaScript

JavaScript is a typical object oriented language which is compliant to basic CORBA,
DCOM and other popular object standards.

SAP R/3 provides a set of object libraries, which can be registered with JavaScript
to allow RFC calls to R/3.

The libraries are installed to the workstation with the SAPGUI installation.
The object library SAP contains among others the object type FUNCTIONS whose
basic method CALL performs an RFC call to a specified R/3 function module.

If the RFC call appears to be not working, you should first try out to call one of the standard R/3 RFC functions like RFC_CALL_TRANSACTION_USING (calls a
specified transaction) or RFC_GET_TABLE (returns the content of a specified R/3
database table).