Configure SAP Table Input Component

Prerequisites

• The SAP Table data source has been created. For more information, see Create SAP Table Data Source.

• The account that configures the SAP Table input component must have read-through permission for the data source. If you do not have permission, request data source permission. For more information, see Request, Renew, and Return Data Source Permissions.

Procedure

1. On the Dataphin home page, select Development > Data Integration from the top menu bar.

2. On the integration page, select Project from the top menu bar (Dev-Prod mode requires selecting the environment).

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

4. Click Component Library in the upper right corner of the page to open the Component Library panel.

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

6. Click the icon in the SAP Table input component card to open the SAP Table Input Configuration dialog box.

7. In the SAP Table Input Configuration dialog box, configure the parameters.

   • Select RFC_READ_TABLE.

     RFC_READ_TABLE is a built-in SAP RFC function that reads the structure and data of SAP database tables.

     Parameter	Description
     Step Name	The name of the SAP Table input component. Dataphin automatically generates a step name, which you can modify as needed. The naming convention is as follows: Can only contain Chinese characters, letters, underscores (_), and numbers. Cannot exceed 64 characters.
     Datasource	Select an SAP Table data source in Dataphin. Click the icon to copy the data source name. If you do not have read-through permission for a data source, request read permission. For more information, 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	If no_data is not empty, no data is output to the table. If it is empty, data is transmitted.
     Rowskip	The starting row number for data output (0-based).
     Rowcount	The total number of rows to output starting from Rowskip. Set to 0 to output all data.
     Filter Condition	The query condition for filtering table data. You can use SAP query operators. Supported SAP query operators: 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 rows read per batch. Adjust based on database performance and data volume.
     Output Fields	Displays all fields of the selected table. To exclude fields from downstream components, delete them: To delete a few fields, click the icon in the Actions column. To delete multiple fields at once, click Field Management. On the Field Management page, select the fields, and then click the icon to move them from Selected Input Fields to Unselected Input Fields.

   • RFC selects RFCs other than RFC_READ_TABLE.

     Parameter	Description
     Step Name	The name of the SAP Table input component. Dataphin automatically generates a step name, which you can modify as needed. The naming convention is as follows: Can only contain Chinese characters, letters, underscores (_), and numbers. Cannot exceed 64 characters.
     Datasource	Select an SAP Table data source in Dataphin. Click the icon to copy the data source name. If you do not have read-through permission for a data source, request read permission. For more information, 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 for data synchronization in the custom RFC.
     Output Fields	Displays all fields of the selected table. To exclude fields from downstream components, delete them: To delete a few fields, click the icon in the Actions column. To delete multiple fields at once, click Field Management. On the Field Management page, select the fields, and then click the icon to move them from Selected Input Fields to Unselected Input Fields.

8. Click Confirm to complete the property configuration of the SAP Table Input Component.