Query Read Text for SAP S/4HANA via Syniti Replicate

Overview

This article describes the steps required to install the SAP transport needed to extract long text data from SAP Systems via RFC using Syniti Replicate. Additionally, it describes the minimum SAP User requirements that need to be provisioned to allow table data to be extracted using Syniti Replicate.

SAP Environment Compatibility SAP S/4HANA

Transport file S4DK900544 is compatible with SAP S/4HANA 1909 or higher.

User Authorization

Syniti recommends using a non-dialog RFC user with a non-expiring password. The user should at least be provisioned the authorizations shown below.

Table Access

Use the S_TABU_NAM authorisation 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.

Use the S_TABU_NAM authorisation 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.

Install SAP S/4HANA Transports

The first step required to set-up the solution, is to install the provided transport in the SAP Application Server. The transport files are listed next. To have them installed, please contact the customer Basis team.

Install Syniti SAP Query Read Text Transport

Install the provided transports into the SAP Application Server.

To extract SAP long texts, a single transport (Transport File DCSK900616) must be installed. To have it installed, please contact the customer Basis team.

Transport Contents

Executing Syniti SAP Query Read Text

Using RSAQ_REMOTE_QUERY_CALL

Once the Syniti SAP Query Read Text is installed, it is ready to be executed and to extract text for the objects in scope.

When executing the query using RSAQ_REMOTE_QUERY_CALL Remote Enabled Function Module, the following input parameters must be provided:

• WORKSPACE: Value must be set to G as the Query was created under Global Area

• QUERY: Name of the Query to be executed. Value must be BOAQ_READ_TEXT

• USERGROUP: Name of the User Group that contains the Query. Value must be /BOA/QUERY (S/4HANA)

• SKIP_SELSCREEN: Do not use Selection Screen. Selection Screen Parameters are populated from Input Table SELECTION_TABLE (see below). Value must be X.

• DATA_TO_MEMORY: Export extraction results to memory and fill Output Table LDATA (see LDATA Output Table for more information)

• SELECTION_TABLE:

  • SELNAME: Possible values are:

    • S_TDOBJ: Text Object

    • S_TDNAME: Text Name

    • S_TDID: Text ID

    • S_SPRAS: Language

  • KIND: Possible values are

    • P: Parameter

    • S: Select Option

  • SIGN: Possible values are:

    • I: Include

    • E: Exclude

  • OPTION: Possible values are:

    • EQ: Equal

    • NE: Not Equal

    • GT: Greater Than

    • GE: Greater or Equal Than

    • LT: Less Than

    • LE: Less or Equal Than

    • BT: Between

  • LOW: Lower Value

  • HIGH: Higher Value

LDATA Output Table

The output is exported to the LDATA output table. This table has a generic row type, and its contents must be parsed by the consumer application.

Note

In cases where the length of the result record is less than the length of the LDATA row, one row of Output Table LDATA may contain more than one result record from the Query. It is also possible for one result record from the Query to span more than one row of Output Table LDATA, in cases where the length of the result record is greater than the length of LDATA row.

LDATA encodes the results in the following format: <VALUE_LENGTH>:<VALUE>[<VALUE_LENGTH>:<VALUE>];

where:

• VALUE_LENGTH: 3 digits describing the length of VALUE

• VALUE: Actual field value

For Syniti SAP Query Read Text, every output record has 8 fields:

1. Text Object

2. Text Name

3. Text ID

4. Text Language

5. Text Format

6. Text Line

7. Line Counter

8. SAP Client

Using Syniti Data Provider for SAP ERP

Once the Syniti SAP Query Read Text and the Syniti Data Provider for SAP are installed, they are ready to be executed and to extract text for the objects in scope.

The Syniti Data Provider for SAP is responsible for converting SQL Query Language (i.e., SQL Select Statements) into a Remote Function Call using RSAQ_REMOTE_QUERY_CALL Remote Enabled Function Module. The Syniti Data Provider for SAP translates the SQL Query options into Importing and Table Parameters and parses the output of the Remote Function Call back into SQL compliant format. The Query Name must be informed in the From Clause and the following fields can be used in the Where Clause:

• _BS4_READ_TEXT-OBJECT: Text Object

• _BS4_READ_TEXT-NAME: Text Name

• _BS4_READ_TEXT-ID: Text ID

• _BS4_READ_TEXT-LANGUAGE: Language

The output can contain the fields below:

• Text Object

• Text Name

• Text ID

• Text Language

• Text Format

• Text Line

• Line Counter

• SAP Client

Execution Examples

Execution using RSAQ_REMOTE_QUERY_CALL

To consume Syniti SAP Query Read Text using RSAQ_REMOTE_QUERY_CALL, the following fields must be populated:

• Workspace

• Query

• Usergroup

• Skip_selscreen

• Data_to_memory

• Selection_table

See Using RSAQ_REMOTE_QUERY_CALL for more details for each parameter.

RSAQ_REMOTE_QUERY_CALL - Parameters

RSAQ_REMOTE_QUERY_CALL - SELECTION_TABLE

The generated results can be found in Table LDATA:

RSAQ_REMOTE_QUERY_CALL - LDATA

Execution from the Management Center

1. Open the Management Center, right-click your SAP ECC connection, and then select Select Tables.

   

2. In the Filter field, enter BOAQ_READ_TEXT.

   

3. Follow the steps to create a target table using the Syniti Replicate Target Table Wizard and also create the according replication for this table. Make sure to deselect the Enable Replication option before completing the wizard. Refer to Create Target Table Wizard for more information.

   

4. From the Replication list, select BOAQ_READ_TEXT and right-click and select Replication Properties.

   

5. Click the Refresh option under Preferences and expand the Refresh Filter Source section, and then click the ellipses (…) button to open the Expression Generator.

   

   In this new dialog box, user can add the filter required. In this example, the MATERIAL filter is applied.

6. Click OK to save your changes.

Advanced Filtering

SAPERP.BOAQ_READ_TEXT WHERE "_BOA_READ_TEXT-LANGUAGE"='E' AND "_BOA_READ_TEXT-NAME" LIKE 'BEWERB%'

SAPERP.BOAQ_READ_TEXT WHERE "_BOA_READ_TEXT-LANGUAGE"='E' AND "_BOA_READ_TEXT-COUN" >=1 and "_BOA_READ_TEXT-COUN" <20