Skip to main content

xSuite Interface Windows Prism 5.x – Online Help

SAP Function RFC_READ_TABLE

For this data source, the standard SAP function "RFC_READ_TABLE" is called. This function enables SAP tables to be read.

The same prerequisites apply for this data source as for the output system "SapXSuiteInterfaceNCo, SapXSuiteInterfaceNwRfc." The same interface technologies are also supported.

The connection string may include all standard SAP connection parameters.

Notice

Available key names include AppServerHost, SystemNumber, User, Password, Client, and Language.

This documentation does not include a complete list of the key names available. The list is stored in the Configurator.

The following keys are added to the string:

Key

Description

Provider*

  • Value SapRfcTableNCo: Use of the SAP .NET Connector

  • Value SapRfcTableNwRfc: Use of the SAP NetWeaver

HasEtData

Boolean value determining whether data will be read from "ET_DATA"

Newer versions of the SAP function have an alternative export parameter "ET_DATA," in which the query result is returned as an alternative to "DATA." Setting this Boolean value specifies that this is the case and that the data should preferably be read from "ET_DATA."

If "ET_DATA" is empty, "DATA" will be used.

Default value: TRUE

The structure of the query command is based on that of query commands in SQL-SELECT syntax:

SELECT {fieldname 1} [AS {alias 1}], …, {fieldname n} [AS {alias n}]
FROM {table name}
[WHERE {filter expression}]

The field names and table names to be used are those of the relevant SAP table. If the fields are to be returned under a different display name, an alias can be assigned for those fields. The general ABAP syntax applies to the optional search filter. Make sure you use the correct notation for fixed-length field contents and the right number of spaces before and after the relational operator (e.g., KUNNR = '0000004711').

In this section: