Tables

This section shows how to use the ReadTable class.
A recurrent task when working with SAP and .NET applications is to read directly from tables of the SAP system. The ReadTable class enables access to that data.

Restrictions

When extracting tables from older SAP releases you may encounter several restrictions when using the SAP standard function module (RFC_READ_TABLE):

• The overall length 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. Mass data extraction can also cause duplicates. The use of Z_XTRACT_IS_TABLE does not guarantee duplicate-free results.

To bypass the restrictions, install the custom function module Z_XTRACT_IS_TABLE.

Install Z_XTRACT_IS_TABLE

Follow the steps below to create a custom function module Z_XTRACT_IS_TABLE in SAP that bypasses the restrictions of the SAP standard function module (RFC_READ_TABLE):

1. Use SAP transaction SE37 to create a new function module named Z_XTRACT_IS_TABLE.

   Note

   You can use an existing function group or create a new one. This is also valid for the development class (Package).

2. In the tab Attributes check Remote Enabled.
   

3. define the following import imports:
   
4. Define the following table parameter:
   
5. Define the following exceptions:
   
6. Download the file Z_XTRACT_IS_TABLE.txt that contains the ABAP code for the function module.
7. Use [Ctrl + C] and [Ctrl + V] to paste the ABAP code into the source code editor.
8. Save the function module and activate it.

To use the new custom function module with the ReadTable class, use the SetCustomFunctionName() command before reading the table. Example:

table.SetCustomFunctionName("Z_XTRACT_IS_TABLE");