SAP

Overview

Adele works with SAP Servers. At the moment the main connectivity option working with SAP a RFC enables interface to SAP NetWeaver systems. Other SAP related connectors are planned for the future (e.g. SAP HANA, SAP BW, ...).

Activating the SAP RFC Connector

The built in SAP RFC connector uses the SAP Java Connector (SAPJCo). The SAPJCo is available for all customers at http://service.sap.com/connectors. Download the SAP JCo 3.0 for your plattform and place all files (e.q. sapjco.jar) within the lib directory of Adele.

After restarting Adele the SAP RFC option should be available.

Please note: The full functionality of the SAP RFC Connector is not available for productive systems because of security reasons. If you want all the functionality in productive scenarios too you will need an addon to the SAP. This addon comes as a transport request with object in non-customer namespace. Please contact the author if you want to use this addon.

Using the SAP Clipboard format

From Adele version >=0.4 there is a import filter available especially for the SAP clipboard format. You can extract data within the SAPGUI from many transactions using the ALV grid component (e.g. SE16, SAP Query,..). Export the data and select "to clipboard" there. After exporting the data you can import this into Adele using the clipboard import.

ABAP Query suppport

From Adele version >=0.7 the ABAP Query API is supported. You can use global and local queries. The queries from the Quickviewer (transaction SQVI) are usable too. Because of the limited functionality at the SAP site no statistical preview or count of records are possible. But the main usage - the filtered extracting of data - is available.

Keep in mind there are some drag and drop options to set the SAP filters automatically from other datasets: e.g. "extract all customers from SAP query where the customer number is used in dataset x".

The SAP RFC connector has to be configured for the ABAP query support. Additionally the SAP users need some authorizations to use the ABAP query functionality from external. Check this with transaction ST01.

ABAP Remote Function Support

Since version 0.15.0 Adele supports remote function modules with a special signature. The SAP Java Connector have to be installed.

Three types of integration scenarios are available:
- simple extraction of table (e.g. customizing values)
- extraction with selection options (e.g. normal tables and view)
- extraction with selection options and olap features (e.g. big tables and views)

A special include file (ABAP macros) is required to use this. The file can be downloaded at the sourceforge files section under "plugins/saprfc".

ABAP Import Interface

With Adele version 0.31.0 support for exporting data to SAP Systems via RFC is available. The SAP Java Connector is required and the function modules has support a special signature.

The API and examples are included in a abap include file. This can be downloaded from "plugins/saprfc".