Overview of SAP ERP Data Extraction

  • Last update: January 05, 2025
  • Overview

    Version

    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.

    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.

    1.png

    iconNote:
    Using this function requires an SAP data connection.

    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

    • 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.

    iconNote:
    Using this function requires an SAP data connection.

    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.

    2.png

    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.

    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

     


    附件列表


    主题: Data Development - Scheduled Task
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    8s后關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy