The SAP Table input component is used to read data from SAP Table data sources. In scenarios where data from SAP Table data sources is synchronized to other data sources, you must first configure the data source read by the SAP Table input component, and then configure the target data source for data synchronization. This topic introduces how to configure the SAP Table input component.
Prerequisites
The SAP Table data source has been created. For more information, see Create SAP Table Data Source.
The account used for configuring the properties of the SAP Table input component must have read-through permission for the data source. If you do not have permission, you need to request data source permission. For more information, see Request, Renew, and Return Data Source Permissions.
Procedure
On the Dataphin home page, select Development > Data Integration from the top menu bar.
On the integration page, select Project from the top menu bar (Dev-Prod mode requires selecting the environment).
In the left-side navigation pane, click Batch Pipeline. In the Batch Pipeline list, click the offline pipeline that needs to be developed to open its configuration page.
Click Component Library in the upper right corner of the page to open the Component Library panel.
In the left-side navigation pane of the Component Library panel, select Input. In the input component list on the right, find the SAP Table component and drag it to the canvas.
Click the
icon in the SAP Table input component card to open the SAP Table Input Configuration dialog box.In the SAP Table Input Configuration dialog box, configure the parameters.
Select RFC_READ_TABLE.
RFC_READ_TABLE is an RFC function that comes with the SAP system and is used to read the structure and data of SAP database tables.
Parameter
Description
Step Name
This is the name of the SAP Table input component. Dataphin automatically generates the step name, and you can also modify it according to the business scenario. The naming convention is as follows:
Can only contain Chinese characters, letters, underscores (_), and numbers.
Cannot exceed 64 characters.
Datasource
You can select all SAP Table type data sources in Dataphin. Click the
icon to copy the current data source name.For data sources for which you do not have read-through permission, you can request read permission for the corresponding data source. For specific operations to request data source read permission, see Request, Renew, and Return Data Source Permissions.
If you do not yet have a SAP Table type data source, click Create to create a data source. For more information, see Create SAP Table Data Source.
RFC
Select the RFC in the SAP system.
Query_table
Enter the name of the table to be read and click verify. If the table exists, the fields of the table will be displayed in the Output Fields.
No_data
When no_data is not empty, no data is output to the table. When it is empty, data is transmitted.
Rowskip
The row number of the first data output (starting from 0).
Rowcount
The total number of data rows output starting from rowskip (0 represents all data).
Filter Condition
The table query condition can use the SAP query operator for condition filtering.
The SAP query operators are as follows:
EQ: equal to.
NE: not equal to.
LT: less than.
LE: less than or equal to.
GT: greater than.
GE: greater than or equal to.
IN: for example, TABCLASS IN ('TRANSP', 'INTTAB').
LIKE: for example, LIKE 'Emma%'.
Batch Count
The number of data items read in batches can be modified according to database performance and data volume.
Output Fields
The output fields area displays all the fields of the selected table. If you do not need to output certain fields to downstream components, you can delete the corresponding fields:
If you need to delete a small number of fields, you can click the Actions column under the
icon to delete the extra fields.If you need to delete many fields, you can click Field Management. On the Field Management page, select multiple fields, then click the
icon to move the Selected Input Fields to Unselected Input Fields.
RFC selects RFCs other than RFC_READ_TABLE.
Parameter
Description
Step Name
This is the name of the SAP Table input component. Dataphin automatically generates the step name, and you can also modify it according to the business scenario. The naming convention is as follows:
Can only contain Chinese characters, letters, underscores (_), and numbers.
Cannot exceed 64 characters.
Datasource
You can select all SAP Table type data sources in Dataphin. Click the
icon to copy the current data source name.For data sources for which you do not have read-through permission, you can request read permission for the corresponding data source. For specific operations to request data source read permission, see Request, Renew, and Return Data Source Permissions.
If you do not yet have a SAP Table type data source, click Create to create a data source. For more information, see Create SAP Table Data Source.
RFC
Select the RFC in the SAP system.
Input Parameter
Enter the parameters required by this RFC.
Table
Select the table that needs data synchronization in the custom RFC.
Output Fields
The output fields area displays all the fields of the selected table. If you do not need to output certain fields to downstream components, you can delete the corresponding fields:
If you need to delete a small number of fields, you can click the Actions column under the
icon to delete the extra fields.If you need to delete many fields, you can click Field Management. On the Field Management page, select multiple fields, then click the
icon to move the Selected Input Fields to Unselected Input Fields.
Click Confirm to complete the property configuration of the SAP Table Input Component.