From this architecture and from the object hierarchy of the Function OCX, the following steps can be derived:
- The OLE client application communicates with the Function OCX via the OLE 2 Automation interface. This requires a Function OCX collective object to be created as container for explicit function objects in the client application.
This container contains objects for opening the connection, for calling functions or defining parameters, and for handling return values.
- Connecting to the R/3 system.
- Creating a specific function object for defining the values for export parameters and tables.
- Calling the function via the RFC interface.
- The application server executes remote calls and delivers the R/3 data to the OLE client. Display the data on the active EXCEL worksheet.
- Storing the R/3 data from the EXCEL worksheet locally.
- Disconnecting from R/3.