ERPConnect Services and ERPConnect used the internal class ReadTable to read SAP tables. There are a few restrictions to be aware of when using the ReadTable class:

  • The total width of the columns being read cannot exceed 512 Bytes
  • Depending on the SAP version there may be other restrictions. It is not possible to extract data from tables that contain one or more columns of the data type f (FLTP, floating point) or x (RAW, LRAW).
  • Special tables such as TCURR will return truncated values

In the cases above, a read table access will generate an exception. To avoid this problem, you need to install a custom function module (Z-module) in your SAP system.

In order for ERPConnect Services to utilize the installed custom function module (e.g. Z_XTRACT_IS_TABLE) instead of the standard SAP function module, you will use the CustomFunction property of the ExecuteTableQuerySettings class.

For information on how to install the custom function module Z_XTRACT_IS_TABLE see SAP Customizing - Table Restrictions.