Overview
This article describes the steps required to extract long text data from SAP systems using Replicate Preview using Internet Communication Framework (ICF) services exposed over HTTPS.
User Authorization
Syniti recommends using a non-dialog 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 ADMM Add-On Package
The first step required to set-up the solution, is to install the provided add-on package in the SAP system. The package contains all the required ABAP objects and ICF service definitions. Refer to SKP ADMM Add-On Installation Guide for SAP Systems for more information.
Add-On Contents Specific to Long Text Extraction
Object Name | Type | Description |
/ADMM/SKP_REP_API | Package | Package that contains all objects related to Syniti SAP Query Read Text |
LONGTEXT | ICF Service | ICF service that exposes the Syniti SAP Query Read Text functionality |
/ADMM/CL_READ_LONGTEXT | Class | Class that implements the logic for reading long text from SAP |
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.