Data Replication Read Table
- 03 May 2024
- 2 Minutes to read
- Contributors
- Print
- DarkLight
Data Replication Read Table
- Updated on 03 May 2024
- 2 Minutes to read
- Contributors
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
Overview
This document describes the steps required to install the SAP transports needed to extract table data from SAP Systems via RFC using Syniti Data Replication. Additionally, it describes the minimum SAP User requirements that need to be provisioned to allow table data to be extracted using Syniti Data Replication.
Prerequisites
SAP Environment Compatibility
SAP ECC6: Two different transports available for SAP ECC6 Systems:
Transport RD2K9A011P is compatible with SAP ECC6 SAP Basis 700 – 731.
Transport DCSK900470 is compatible with SAP ECC6 SAP Basis 740 and higher.
S/4HANA: Transport S4DK900435 is compatible with SAP installations of S/4HANA 1709 [S4CORE 102] or higher.
SAP RFC User
Syniti recommends using a non-dialog RFC user with a non-expiring password. The user should at least be provisioned with the authorizations shown below.
Extracting Data from SAP ECC Systems
Authorization Object | Authorization Field | Authorization Value |
S_RFC | RFC_TYPE | FUNC |
ACTVT | 16 (Execute) | |
RFC_NAME | /BOA/*, RFC_READ_TABLE, RFCPING, DDIF_FIELDINFO_GET, RFC_GET_FUNCTION_INTERFACE, RSAQ_REMOTE_QUERY_CALL_CATALOG, RSAQ_REMOTE_QUERY_FIELDLIST, /OSP/GET_DECIMAL_NOTATION | |
S_RFC | RFC_TYPE | FUGR |
ACTVT | 16 (Execute) | |
RFC_NAME | AQRC | |
S_DEVELOP | DEVCLASS | SQUE |
OBJTYPE | FUGR | |
OBJNAME | AQRC | |
P_GROUP | ||
ACTVT | 16 |
Table Access
Use the S_TABU_NAM authorization object to restrict by table. The minimum list of tables required is given below. Additionally, if specific tables need to be extracted, you must include or add them.
Authorization Object | Authorization Field | Authorization Value |
S_TABU_NAM | TABLE | AQGQCAT, DD01T, DD02L, DD02T, DD03L, DD04L, DD04T, DD05Q, DD07L, DD07T, TCDOB |
ACTVT | 03 (Display) |
Use the S_TABU_NAM authorization object to restrict by table group. The minimum list of table groups is given below. Additionally, if specific table groups need to be extracted, you must include or add them.
Authorization Object | Authorization Field | Authorization Value |
S_TABU_DIS | DICBERCLS | &NC&, SS |
ACTVT | 03 (Display) |
Extracting Data from SAP S/4 HANA Systems
Authorization Object | Authorization Field | Authorization Value |
S_RFC | RFC_TYPE | FUNC |
ACTVT | 16 (Execute) | |
RFC_NAME | /BS4/*, RFC_READ_TABLE, RFCPING, DDIF_FIELDINFO_GET, RFC_GET_FUNCTION_INTERFACE, RSAQ_REMOTE_QUERY_CALL_CATALOG, RSAQ_REMOTE_QUERY_FIELDLIST, /OSP/GET_DECIMAL_NOTATION | |
S_RFC | RFC_TYPE | FUGR |
ACTVT | 16 (Execute) | |
RFC_NAME | AQRC | |
S_DEVELOP | DEVCLASS | SQUE |
OBJTYPE | FUGR | |
OBJNAME | AQRC | |
P_GROUP | ||
ACTVT | 16 |
Table Access
Use the S_TABU_NAM authorization object to restrict by table. The minimum list of tables required is given below. Additionally, if specific tables need to be extracted, you must include or add them.
Authorization Object | Authorization Field | Authorization Value |
S_TABU_NAM | TABLE | AQGQCAT, DD01T, DD02L, DD02T, DD03L, DD04L, DD04T, DD05Q, DD07L, DD07T, TCDOB |
ACTVT | 03 (Display) |
Use the S_TABU_NAM authorization object to restrict by table group. The minimum list of table groups is given below. Additionally, if specific table groups need to be extracted, you must include or add them.
Authorization Object | Authorization Field | Authorization Value |
S_TABU_DIS | DICBERCLS | &NC&, SS |
ACTVT | 03 (Display) |
Setup Steps
Install Syniti SAP Query Read Table Transport ECC6
Based upon the version of SAP ECC6, install the associated transport in the SAP Application Server.
Transport RD2K9A011P is compatible with SAP ECC6 SAP Basis 700 – 731.
Transport DCSK900470 is compatible with SAP ECC6 SAP Basis 740 and higher
To have them installed, contact the customer SAP Basis team.
Transport Contents ECC
Object Name | Type | Description |
/BOA/UTILITY | Package | Package that contains all objects related to Syniti Data Replication |
/BOA/SDR0 | Function Group | Syniti Data Replication Function Group |
/BOA/SDR_READ_TABLE | Function Module | Syniti Data Replication Read Table Function Module |
Install Syniti SAP Query Read Table Transport S/4HANA
Install the provided transport in the SAP Application Server.
The transport files required are shown below. To have them installed, contact the customer SAP Basis team.
Transport Contents S/4HANA
Object Name | Type | Description |
/BS4/MASTER_DATA /BS4/UTILITY | Package | Packages that contain all objects related to Syniti Data Replication |
/BS4/SDR0 | Function Group | Syniti Data Replication Function Group |
/BS4/SDR_READ_TABLE | Function Module | Syniti Data Replication Read Table Function Module |
Was this article helpful?
