--- title: "Syniti SAP Query Read Text for SAP ECC" slug: "syniti-sap-query-read-text-for-sap-ecc" updated: 2026-06-29T15:12:53Z published: 2026-06-29T15:12:53Z canonical: "skthelp.syniti.com/syniti-sap-query-read-text-for-sap-ecc" stale: true --- > ## 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. # Syniti SAP Query Read Text for SAP ECC ## Overview This article describes the steps required 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 ECC Long Text Extraction is compatible with SAP ECC6 SAP Basis 740 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. | **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 | | S_PROGNAM | P_PROGNAM | AQZZ/BOA/QUERY==BOAQ_READ_TEXT | **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 The first step required to set-up the solution, is to install the provided add-on in the SAP Application Server. The Add-On details are listed next. To have them installed, please contact the customer Basis team. Refer to [SKP Add-On Installation Guide for SAP ECC](/v1/docs/skp-add-on-installation-guide-for-sap-ecc) for more information. **Add-On Contents** | **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 | ## 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 (ECC)** - **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. - **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] > 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: :[:]; where: - **VALUE_LENGTH:** 3 digits describing the length of VALUE - **VALUE:** Actual field value For Syniti SAP Query Read Text, every output record has the following eight 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: - **/BOA/READ_TEXT-OBJECT**: Text Object - **/BOA/READ_TEXT-NAME**: Text Name - **/BOA/READ_TEXT-ID**: Text ID - **/BOA/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](/docs/syniti-sap-query-read-text-for-sap-ecc#using-rsaqremotequerycall) for more details for each parameter. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-1kmrmi9z.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A39%3A07Z&se=2026-11-13T13%3A39%3A07Z&sr=c&sp=r&sig=eMDqxP5rgd3mkPGa8b2dnqOMV3Fi4YTIl6RtqVjGiMI%3D) RSAQ_REMOTE_QUERY_CALL - Parameters ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-hjs46o6h.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A39%3A07Z&se=2026-11-13T13%3A39%3A07Z&sr=c&sp=r&sig=eMDqxP5rgd3mkPGa8b2dnqOMV3Fi4YTIl6RtqVjGiMI%3D) RSAQ_REMOTE_QUERY_CALL - SELECTION_TABLE The generated results can be found in Table LDATA: ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-0n6vvbs8.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A39%3A07Z&se=2026-11-13T13%3A39%3A07Z&sr=c&sp=r&sig=eMDqxP5rgd3mkPGa8b2dnqOMV3Fi4YTIl6RtqVjGiMI%3D) 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**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-2vggeek3.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A39%3A07Z&se=2026-11-13T13%3A39%3A07Z&sr=c&sp=r&sig=eMDqxP5rgd3mkPGa8b2dnqOMV3Fi4YTIl6RtqVjGiMI%3D) 2. In the Filter field, enter **BOAQ_READ_TEXT**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-nhnoxh2j.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A39%3A07Z&se=2026-11-13T13%3A39%3A07Z&sr=c&sp=r&sig=eMDqxP5rgd3mkPGa8b2dnqOMV3Fi4YTIl6RtqVjGiMI%3D) 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](/v1/docs/create-target-table-wizard) for more information. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-wp2eurkx.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A39%3A07Z&se=2026-11-13T13%3A39%3A07Z&sr=c&sp=r&sig=eMDqxP5rgd3mkPGa8b2dnqOMV3Fi4YTIl6RtqVjGiMI%3D) 4. From the Replication list, select **BOAQ_READ_TEXT** and right-click and select **Replication Properties**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/sap-ecc-via-syniti-rfc-image-98j9i8ad.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A39%3A07Z&se=2026-11-13T13%3A39%3A07Z&sr=c&sp=r&sig=eMDqxP5rgd3mkPGa8b2dnqOMV3Fi4YTIl6RtqVjGiMI%3D) 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. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-U5GO8NWE.png?sv=2026-02-06&spr=https&st=2026-11-13T12%3A39%3A07Z&se=2026-11-13T13%3A39%3A07Z&sr=c&sp=r&sig=eMDqxP5rgd3mkPGa8b2dnqOMV3Fi4YTIl6RtqVjGiMI%3D) 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 When extracting long text data using the Syniti SAP Query Read Text, you may need to filter the results to retrieve specific subsets of data by applying conditions such as 'LIKE' and 'BETWEEN' in the selection criteria. **Using the 'LIKE' Condition** The 'LIKE' condition allows you to filter records that match a specified pattern. For example, to retrieve text objects with names that include the word "BEWERB" you can set the filter as follows: ```plaintext SAPERP.BOAQ_READ_TEXT WHERE "/BOA/READ_TEXT-LANGUAGE"='E' AND "/BOA/READ_TEXT-NAME" LIKE 'BEWERB%' ``` In this pattern, the percent symbol (%) acts as a wildcard, representing any sequence of characters. Therefore, BEWERB% will match any text that starts with the substring "BEWERB". **Using the BETWEEN ‘> <' Condition** The 'BETWEEN' condition (or RANGE), represented by the > < symbol, is useful for filtering records within a specific range. For example, to extract texts with text counters between 1 and 20, you can set the filter criteria as: ```plaintext SAPERP.BOAQ_READ_TEXT WHERE "/BOA/READ_TEXT-LANGUAGE"='E' AND "/BOA/READ_TEXT-COUN" >=1 and "/BOA/READ_TEXT-COUN" <20 ``` This condition will include all records where the line counter falls within the specified range, inclusive of the boundary values.