Function Module for Tables
SAP customization for the SAP Table and View integration 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 yunIO at C:\Program Files\Theobald Software\yunIO\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.
Upgrading to /THEO/READ_TABLE V4
Deletion transport requests are provided to support clean upgrades from Z_THEO_READ_TABLE or /THEO/READ_TABLE V3 to /THEO/READ_TABLE V4.
The transport requests remove all repository objects contained in the package, while leaving the package itself intact. This cleanup is recommended when upgrading to /THEO/READ_TABLE V4, as leftover objects from earlier versions may conflict with newer objects and cause errors during the import process.
The deletion transport requests are located in the installation folder of yunIO at C:\Program Files\Theobald Software\yunIO\ABAP\Table\Deletion-TR.
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 | | |
Related Topics
- Knowledge Base: Import an SAP Transport Request
- Knowledge Base: Deprecated /THEO/READ_TABLE Versions
- SAP Table and View Integration Type