FineDataLink Version
Functional Change
4.1.12.2
Supported data fetching through Table Selection.
Renamed the operator SAP ERP Input.
Changed the ... option under SAP ERP Input > Output (displayed when Configuration Method was set to Function Calling) to Output Parameter.
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.
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.
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.
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
Parameter Name: the name of the parameter input by the selected SAP function
SAP Data Type: the data type of the parameter input by the selected SAP function (non-editable)
Data Type: the corresponding data type in FineDataLink of the parameter
Parameter Value: the parameter value (You can enter a fixed value or reference the parameter.)
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.
Data Filtering
Enter the filtering condition.
You can write filtering statements referring to the filtering syntax of OPEN SQL.
Referencing parameters is supported.
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
DATE
Date
BCD
BigDecimal
TIME
BYTE
XSTRING
Binary
NUM
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.
Fetching Data by Calling SAP Functions Without Parameters
Fetch data by calling the ABAP function via RFC using parameters.
Fetching Data by Calling SAP Functions with Parameters
Fetch data from the SAP system by selecting the table.
SAP Query Using Table Selection
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy