Overview
Version
FineDataLink Version | Functional Change |
4.1.12.2 |
|
Application Scenario
User data is stored in SAP, but due to data security concerns or limited knowledge of underlying tables in SAP, you may find it hard to directly access underlying SAP databases for data extraction.
Therefore, you want to obtain data from the SAP system using FineDataLink for subsequent data development.
Function Description
FineDataLink allows you to fetch data from the SAP system through Function Calling (to call developed functions in the SAP system through RFC interfaces) or Table Selection.
If you want to process data fetched from the SAP system and write the final data into a database, you can use the SAP ERP Input operator in Data Transformation.
If you want to write the fetched data into a database directly, you can use Data Synchronization.

Notes
The language of the FineDataLink server must be consistent with the language of the SAP server.
For a FineDataLink server and the SAP client with different language configurations, data fetching errors will occur when you use the RFC interface in an ABAP program because the login language serves as a query parameter. In this case, you need to modify the default language of the SAP client to that of the FineDataLink server.
Function Description
Configuration Method | Setting Item | Description |
Function Calling (Call the custom function to obtain data.) | Function | You can edit it manually or click the Setting button to select an existing function. Referencing parameters is not supported. |
Input |
| |
Drop-Down List of Output | The drop-down list contains all selectable output resultsets. ![]() | |
Output | SAP Parameter Name: the name of the data column in the output resultset of SAP-ABAP (non-editable) SAP Data Type: the corresponding data type in SAP of the column in the output resultset of SAP-ABAP (non-editable) Data Type: the corresponding data type in FineDataLink (non-editable) | |
Table Selection (Call the RFC_READ_TABLE function to obtain SAP table data.) | Source Table | Enter the name of the SAP table from which you want to fetch data. Referencing parameters is not supported. |
Data Filtering | Enter the filtering condition. You can write filtering statements referring to the filtering syntax of OPEN SQL. Referencing parameters is supported. |
Type Correspondence Between Data Fetched by SAP Function and Data in FineDataLink
The configuration page of the SAP ERP Input operator is shown in the following figure.
For data fetched by calling the SAP function, the CHAR-type SAP data is automatically mapped as String-type data in FineDataLink, and the INT-type SAP data is automatically mapped as Integer-type data in FineDataLink.
The SAP data types supported by the SAP ERP Input operator are shown in the following table. If you need support for other SAP data types, contact technical support.
SAP Data Type | FineDataLink Data Type |
CHAR String | String |
DATE | Date |
BCD | BigDecimal |
TIME | Date |
BYTE XSTRING | Binary |
NUM | String |
FLOAT DECF16 DECF34 | Double |
INT INT2 INT1 | Integer |
JSONSTRING STRUCTURE TABLE | JSONString |
Index
Scenario | Document |
Fetch data by calling the ABAP function via RFC without using parameters. | |
Fetch data by calling the ABAP function via RFC using parameters. | |
Fetch data from the SAP system by selecting the table. |