--- title: "Setup Steps to Refresh data from SAP S/4HANA Systems" slug: "setup-steps-to-refresh-data-from-sap-s4hana-systems" updated: 2026-05-21T16:47:41Z published: 2026-05-21T16:47:41Z canonical: "skthelp.syniti.com/setup-steps-to-refresh-data-from-sap-s4hana-systems" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Setup Steps to Refresh data from SAP S/4HANA Systems ## Overview This article describes the steps required to refresh data from an SAP S/4HANA system. Ensure that you have completed the [Prerequisites](/v1/docs/sap-s4hana-via-syniti-rfc#prerequisites) steps before proceeding to configure Refresh replication for an SAP S/4HANA system. ### User Authorization The following Authorization Objects must be assigned to the user utilizing the standard Read Function extraction. If your scope is to utilize the Streaming functionality check the next section. | **Authorization Object** | **Authorization Field** | **Authorization Value** | | --- | --- | --- | | S_RFC | RFC_NAME | /BS4/SDRM_READ_TABLE /BS4/SRTT_GET_TABLE_SIZE_RFC RFC_METADATA_GET RFC_FUNCTION_SEARCH RFC_GET_FUNCTION_INTERFACE GET_SYSTEM_TIME_REMOTE DDIF_FIELDINFO_GET PERF_TRA_DIA RFCPING RFC1 | | RFC_TYPE | FUNC or FUGR | | ACTVT | 16 | | S_TABU_NAM | TABLE | | | ACTVT | 03 (Display) | | S_TABU_DIS | DICBERCLS | | | ACTVT | 03 (Display) | | S_TABU_CLI | CLIIDMAINT | Allowed | ### SAP Streaming Setup To enable the data streaming capability in SAP S/4HANA the following steps must be taken: #### Configure the Destination and Program 1. Enter transaction **SM59** in the SAP system and click the **Create** button. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-s4-hana-via-syniti-rfc-image-oeweawqg.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A20Z&se=2026-11-17T20%3A30%3A20Z&sr=b&sp=r&sig=zpeFwhdt2pJ6IRMAlyivZuzL0Ck00O8lG2QSTiM5tOI%3D) 2. Create a TCP/IP Connection, specifying RFC Destination (for example, NCO_SERVER) and an optional description to aid understanding. 3. Choose the Registered Server Program type under the Technical Settings and specify the Program ID (for example, SKPStreamServer). 4. Save the record. > [!NOTE] > Note > > Ensure that you make a note of the RFC Destination and Registered Server Program values that you have used as these will be required for the configuration of the SAP Connection in Replicate. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-s4-hana-via-syniti-rfc-image-v5513z8y.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A20Z&se=2026-11-17T20%3A30%3A20Z&sr=b&sp=r&sig=cQbN3dgVVMbvcHT1iUN7pb7190KF13mruT%2BiXaDGK3c%3D) The RFC connection to the specific application has been created or registered in Syniti Replicate and table extractions triggered RFC streaming server gets activated. > [!NOTE] > Note > > If you are downloading multibyte / unicode character sets, ensure that unicode is activated on the Unicode tab in the Destination setup. If multiple SAP systems connection are required to be configure, then the RFC program ID can be updated to suit the specific SAP System ID SKPStreamServer. The same Program ID must be used while registering the RFC connection to this SAP system from Syniti Replicate. #### Configure the Gateway After defining the Destination and Program for the Replicate Streaming Server, you need to set up the SAP Gateway to allow for the connection to the Replicate Server. Depending on the SAP Netweaver version, that is, starting from v7.4, Gateway security is enhanced with the gw/acl_mode parameter influencing the external systems starting or registering external programs, such as gw/sec_info and gw/reg_info. To register SKPStreamServer external program, complete the following steps: 1. Enter transaction **SMGW** and select **Goto > Expert Functions > External Security > Maintenance of ACL Files**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-s4-hana-via-syniti-rfc-image-j6pa58m8.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A20Z&se=2026-11-17T20%3A30%3A20Z&sr=b&sp=r&sig=dh5XV1vB%2BOvkSKA%2B8I%2BMnVdMKnyOOFQiGSkJsqSuCvk%3D) 2. Select the **Reginfo File** tab on the Maintenance page and click the **Insert Line** button, and then select **Standard**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-s4-hana-via-syniti-rfc-image-v90hwmqu.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A20Z&se=2026-11-17T20%3A30%3A20Z&sr=b&sp=r&sig=hoSwNzfy7arJDucEb0cMckC1HGsnwMWljvq9bvVbBRY%3D) 3. In the Create Line in Reginfo File dialog box, complete the following steps: 1. In the P/D field, enter **P**. 2. In the TP field, enter the Program ID value you entered in transaction SM59 above. For example, SKPStreamServer. 3. In the HOST field, enter the IP address for the Replicate Server that you have or will be installing the Syniti Replicate software. 4. Set the ACCESS and Cancel fields to *****. 5. Optionally, set the Comment field to aid understanding. 6. Save the record. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-s4-hana-via-syniti-rfc-image-7pnswlf2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A20Z&se=2026-11-17T20%3A30%3A20Z&sr=b&sp=r&sig=Pl4Cp9o%2BACJMS9PseOKUisSxfEobhH%2Bo7ea4QiwQjGM%3D) After completing the change, you can reload the files without having to restart the gateway. To do this, in the gateway monitor (transaction SMGW), select **Goto > Expert Functions > External Security > Reread**. Refer to [Troubleshoot SAP RFC Connection](/v1/docs/connect-using-sap-netweaver#troubleshoot-sap-rfc-connection) when your test connection in Syniti Replicate fails. This completes the setup on the SAP side to support the streaming capabilities embedded in Syniti Replicate v10.7.0.4 or later. #### User Authorization The following Authorization Objects must be assigned to the user utilizing the Streaming capabilities: | **Authorization Object** | **Authorization Field** | **Authorization Value** | | --- | --- | --- | | S_RFC | RFC_NAME | /BS4/SDRM_READ_TABLE /BS4/STREAM_READ_TABLE /BS4/SRTT_GET_TABLE_SIZE_RFC /BS4/SDRM_TABL_CALLBACK RFC_METADATA_GET RFC_FUNCTION_SEARCH RFC_GET_FUNCTION_INTERFACE GET_SYSTEM_TIME_REMOTE DDIF_FIELDINFO_GET PERF_TRA_DIA RFCPING RFC1 | | RFC_TYPE | FUNC or FUGR | | ACTVT | 16 | | /BS4/SDRMF | RFC_NAME | /BS4/SDRM_READ_TABLE | | ACTVT | 16 (Execute) | | S_TABU_NAM | TABLE | | | ACTVT | 03 (Display) | | S_TABU_DIS | DICBERCLS | | | ACTVT | 03 (Display) | | S_TABU_CLI | CLIIDMAINT | Allowed | ## Syniti Replicate Setup ### Add Source Connection Wizard The following field(s) require specific information for SAP NetWeaver Extract. #### Select Provider 1. On the Select Provider page, enter **SAP ECC RFC** in the Name field. 2. From the Database list, select **SAP NetWeaver Extract**. 3. On the Provider list, the **Syniti SAP RFC .NET Data Provider** option is selected by default. 4. Click **Next**. #### Set Connection String Screen Enter your connection information for your SAP system. The table below defines the available Syniti SAP RFC .NET driver connection properties along with recommended values to be used for properties. | **Required Parameters** | **Description** | | --- | --- | | AppServerHost | IP Address or host name of application server | | System ID | Unique identifier assigned to each individual SAP system | | Client | SAP client number | | System Number | Unique identifier for an SAP instance | | User | User ID authenticating to the SAP System | | Password | Password | | **Optional Parameters** | **Description** | | --- | --- | | System Language | Select your system language | | Read Table | Function allowing direct access to database tables. For ECC: **/BOA/SDRM_READ_TABLE** For S/4: **/BS4/SDRM_READ_TABLE** | | Stream Read Table | Function for efficient data retrieval. By default: /BS4/STREAM_READ_TABLE | | Logon Group | Logon Group when connection is loading balanced/SAP Message Server | | SNC Mode | Secure Network Communications mode enhances security for SAP connections. Set in True to use SNC | | SNC Partner Name | Identification of the secure network partner | | SNC Library Path | Directory containing secure network communications libraries | | SNC QOP | Quality of Protection specifies the level of security using SNC | | SNC SSO | Secure store and forward enhances security for message transmission | | SAP Router | Secure communication tool for connecting SAP systems | | Message Server Host | Server responsible for managing communication between SAP instances | | Message Server Service | Service of the SAP system (message server). This can be the numeric description of the service port of the message server or the alphanumeric equivalent (for example, sapmsXXX, where XXX is the system ID of the SAP system). | | Gateway Host | Entry point for communication between SAP systems and external applications | | Gateway Service | The service that facilitates communication between SAP systems and external applications | | Destination Server | Name of the destination defined in SM59 in SAP, for example: *NCO_SERVER* | | Program ID | Unique identifier for a program running in the SAP system, for example: *SKPStreamServer* | | Connection Count | SAP connection count refers to the total number of active connections to an SAP system | | Max Pool Size | Maximum number of connections allowed in the pool | | Fetch Block Size | Read Block Size. Specifies the amount of data retrieved in each fetch operation | | Fetch Queue Size | Specifies the number of data blocks kept in memory during fetch | | Extended Properties | Additional properties not listed in the grid. | > [!NOTE] > Note > > Complete the rest of the fields in the Add Target Connection wizard. Refer to [Add Target Connection Wizard](https://skthelp.syniti.com/v1/docs/add-target-connection-wizard) for more information. #### Select Source Tables 1. Right-click the Source Connection that represents the SAP System where data is being extracted and select **Select Tables**. ![A screenshot of a computer Description automatically generated](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-m4hqxoyb.jpg?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A20Z&se=2026-11-17T20%3A30%3A20Z&sr=b&sp=r&sig=lAW%2Bm2ihXNkv8rP9miEjLbGIKDuUNye6TmjFZ54AhtM%3D) 2. In the Select Tables dialog box, expand the source navigation tree, and then click the schema, for example, SAPERP. > [!NOTE] > Note > > Avoid expanding the navigation tree below the SAPERP schema. If you expand it, the system attempts to load all the tables defined by the ‘TableMode’ connection property and could take a few minutes to complete. ![A screenshot of a computer Description automatically generated](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-ep7cjq21.jpg?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A20Z&se=2026-11-17T20%3A30%3A20Z&sr=b&sp=r&sig=sflGzjecIwVkS71zK9x7fvhI80OIneRq5ROUYMpIr%2FM%3D) 3. Select the specific table that needs to be extracted by entering the name in the Filter field, and then clicking the **Apply Filter** icon. > [!NOTE] > Note > > Append the percent (**%**) symbol to the first characters of a table to retrieve a list of tables that begin with specific characters. ![A screenshot of a computer Description automatically generated](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-jpiro0q7.jpg?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A20Z&se=2026-11-17T20%3A30%3A20Z&sr=b&sp=r&sig=nc5AuYsyT%2F0ItIdgA5C89SPoJnXKwYusPswnnaBJa1s%3D) 4. Select the table(s) that need to be imported into the Source Connection table metadata store, and then click **OK**.