SAP Table Connector – Connectivity and RFC Reference
This article describes the SAP Table connector connectivity options, required connection properties, SAP authorization requirements, and RFC-based data retrieval used to establish communication between the OvalEdge SAP Table connector and SAP systems.
It also provides technical reference information for SAP Application Server and SAP Message Server connections, supported RFC implementations, and commonly used RFC query operators.
Supported Connection Methods
The SAP Table connector supports the following connection methods:
Connection through SAP Application Server
Connection through SAP Message Server
Connection through SAP Application Server
Use this connection method when connecting directly to a specific SAP Application Server instance.
Connection Type
Must be set to SAP Table.
Yes
Application Server
Host name or IP address of the SAP Application Server.
Yes
System Number
Two-digit SAP system instance number.
Yes
System ID
Unique identifier of the SAP system.
Yes
Client ID
Three-digit SAP client identifier.
Yes
Username
SAP user account used to establish the connection.
Yes
Password
Password associated with the SAP user account. Stored in encrypted format within OvalEdge.
Yes
Language
SAP logon language. Default value is EN.
No
Connection through SAP Message Server
Use this connection method when connecting through an SAP Message Server for load-balanced access across multiple application servers.
Connection Type
Must be set to SAP Table.
Yes
Message Server Name
Host name or IP address of the SAP Message Server.
Yes
Message Service Name or Port Number
Service name or port number of the SAP Message Server.
Yes
Logon Group
SAP Logon Group configured for load balancing.
Yes
System ID
Unique identifier of the SAP system.
Yes
Client ID
Three-digit SAP client identifier.
Yes
Username
SAP user account used to establish the connection.
Yes
Password
Password associated with the SAP user account. Stored in encrypted format within OvalEdge.
Yes
Language
SAP logon language. Default value is EN.
No
SAP Authorization Requirements
The SAP user configured for the SAP Table connector must have the following authorizations:
Authorization to use Remote Function Call (RFC) destinations.
Execute permission for the S_SDAUTH authorization object.
These permissions are required to validate the connection and execute RFC operations used by the connector.
RFC-Based Data Retrieval
The SAP Table connector retrieves metadata and profiling information using standard SAP RFCs and custom RFC implementations.
Standard RFC
The connector supports the SAP standard RFC_READ_TABLE function module for retrieving metadata and table data.
Limitations
The standard RFC_READ_TABLE function module is subject to the DATA_BUFFER_EXCEEDED exception when the total character length of the returned data exceeds 512 characters.
Custom RFC Support
To overcome the limitations of RFC_READ_TABLE, the SAP Table connector supports the custom RFC implementation ZOE_RFC_READ_TABLE.
The custom RFC enables retrieval of larger datasets without encountering the standard data buffer limitation.
Custom RFC Parameters
Query Table
Name of the SAP table or view to retrieve data from.
Delimiter
Character used to separate field values in the returned data.
No Data Indicator
When enabled, retrieves only field metadata without returning table data.
Row Skips
Starting row for data retrieval.
Row Count
Number of rows to retrieve.
Options
Filter conditions applied during data retrieval.
Fields
Metadata describing the selected fields or columns.
Data
Returned dataset.
OvalEdge does not store source system data. Only metadata and profiling statistics are retrieved from the SAP system.
RFC Queries
The following operators can be used to define filter conditions in RFC queries.
EQ
Equal to
NE
Not equal to
LT
Less than
LE
Less than or equal to
GT
Greater than
GE
Greater than or equal to
IN
Matches a list of values (for example, TABCLASS IN ('TRANSP', 'INTTAB'))
LIKE
Pattern matching (for example, LIKE 'Emma%')
Copyright © 2026, OvalEdge LLC, Peachtree Corners GA USA
Last updated
Was this helpful?