Skip to content

Function Module for Tables

SAP customization for the Table extraction type is optional. The installation of the custom function module /THEO/READ_TABLE is recommended to improve performance and to bypass restrictions of the SAP standard function module RFC_READ_TABLE.

RFC_READ_TABLE Restrictions

Especially with older SAP releases you may encounter a few restrictions when using the SAP standard function module (RFC_READ_TABLE) for table extraction:

  • The overall width of all columns to be extracted must not exceed 512 bytes.
  • It is not possible to extract data from tables that contain one or more columns of the data type f (FLTP, floating point), DEC (decimal, e.g. for percentage) or x (RAW, LRAW).
  • Poor extraction performance with larger tables. Can cause also duplicates.
  • Depending on the SAP version there may be other restrictions.

When facing restrictions, install the Theobald Software custom function module /THEO/READ_TABLE on your SAP system.

Warning

Converting issues
Error while converting value '*.0' of row 1530, column 3.
The SAP standard module RFC_READ_TABLE for table extraction can only extract the ABAP data type DEC to a limited extent. This leads to the mentioned example error during extraction. Use the function module /THEO/READ_TABLE.

Installation of /THEO/READ_TABLE

An SAP transport request to install the function module is included in the installation directory of Xtract Universal at C:\Program Files\XtractUniversal\ABAP\. Transport requests must be imported into SAP by your SAP Basis team. For more information, see Knowledge Base: Import an SAP Transport Request.

Transport Request Compatible SAP Systems
THEO_READ_TABLE_740SP08.zip ABAP version 7.40 SP08 and higher (unicode systems)
THEO_READ_TABLE_46C.zip ABAP versions from 4.6C and higher (unicode and non-unicode systems)

When you import these transport requests on older SAP releases, a syntax error may occur. In this case, contact Theobald Support and include the exact error message in the support ticket.

Warning

Generating short dumps.
You cannot test the function modules on an SAP system. Only Theobald Software products can call the function module /THEO/READ_TABLE, because it uses a callback function. Do not call /THEO/READ_TABLE directly from an SAP system.

Supported Features

Supported Features THEO_READ_TABLE_740SP08 THEO_READ_TABLE_46C
WHERE clause ✅ ✅
HAVING clause ✅ ❌
INNER JOIN ✅ ✅
LEFT OUTER JOIN ✅ ✅
Conversion exits ✅ ✅
Aggregate functions ✅ ✅
ABAP SQL strict mode features (this includes SQL expressions, subqueries and string functions like CONCAT in WHERE/HAVING clauses) ✅ ❌
Table extractions as background jobs ✅ ✅
Extract CDS Views with parameters ✅ ❌


Last update: June 28, 2025