/THEO/READ_TABLE
SAP customization for the Table service 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
The SAP transport request for installing the function module is available for download in the Customer Portal. For information on how to use transport requests, see Knowledge Base: Import an SAP Transport Request.
| Transport Request | SAP System |
|---|---|
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
The following table gives an overview of the features supported by the different versions of /THEO/READ_TABLE.
| Supported Features | THEO_READ_TABLE_740SP08 | THEO_READ_TABLE_46C |
|---|---|---|
| WHERE 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 | | |