Read Table Mode

The read table mode invokes the RFC named RFC_READ_TABLE which retrieves columns of a specified SAP table and returns the data as a result set.

You can map the result set to an ESP stream or window using the Fields parameter. Specify the table name for this RFC using the Table parameter in the adapter configuration file. This mode is similar to reading a database table.

There are a number of limitations for this mode:

The combined length of all columns returned by RFC_READ_TABLE cannot be more than 512 bytes.
When defining the WHERE clause through the Options configuration parameter, each line of the clause cannot be more than 71 characters long. Work around this by breaking the clause into multiple lines using multiple Option configuration parameter.
When specifying an expression in the WHERE clause, always include a space between the name of a column and the operator. For example, a space is required between LAND1 and ‘=’ in clause LAND1 = ‘FR’. Without this, RFC_READ_TABLE returns an error.