Overview
This article describes the steps required to extract long text data from SAP systems using Replicate Preview.
User Authorization
Syniti recommends using a non-dialog RFC user with a non-expiring password. The user should at least be provisioned the authorizations listed in this article.
Table Access
Use the S_TABU_NAM authorization object to restrict by table. The minimum list of tables required are as follows. Additionally specific tables to be extracted will need to be added.
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 group are as follows. Additionally specific table groups to be extracted will need to be added.
Authorization Object | Authorization Field | Authorization Value |
S_TABU_DIS | DICBERCLS | &NC&, SS |
ACTVT | 03 (Display) |
Install SKP Add-On Package for SAP ECC
The first step required to set-up the solution, is to install the SKP Add-On package in the SAP Application Server. The add-on package contains the required objects to extract SAP long texts. Refer to SKP Add-On Installation Guide for SAP ECC for more information.
Object Name | Type | Description |
/BOA/RFCTEXT_V2 | Package | Package that contains all objects related to Syniti SAP Query Read Text |
/BOA/IBIPTEXTLN_V2 /BOA/SPRAS_R_S /BOA/TDID_R_S /BOA/TDOBJECT_R_S /BOA/TDOBNAME_R_S | Structure | Structure that defines available fields for Input parameters and Output table columns |
/BOA/SPRAS_R_T /BOA/TDID_R_T /BOA/TDOBJECT_R_T /BOA/TDOBNAME_R_T | Table Type | Table types that allow multiple range values for each parameter. |
/BOA/RFCTEXT_V2 | Function Group | Function group containing the RFC-enabled function module for reading text data |
/BOA/ZRFC_READ_TEXT_V2 | Function Module | RFC-enabled function module that executes the SAP Query to read text data |
Using Long Text Query in Replicate Preview
Add the BOAQ_READ_TEXT table in your datastore and run a metadata scan for it.
Access your workspace in Replicate Preview and create a replication for the BOAQ_READ_TEXT source table.
Once created, click the Edit icon for the newly created replication.
Add the required source filter according to the required data extraction and click Save.
Execute your replication.