Remote Function Call (RFC) Functions

You can find detailed documentation about SAP Remote Function Call (RFC) functions on SAP's official website. This documentation provides comprehensive information on the various types of RFCs, such as Synchronous RFC (sRFC), Asynchronous RFC (aRFC), Transactional RFC (tRFC), Queued RFC (qRFC), Background RFC (bgRFC), and Local Data Queue (LDQ), along with their specific characteristics and uses. It also covers aspects of data transfer and security relevant to RFC communication.

All ERPL functions loaded into DuckDB can be retrieved by the following SQL statement:

SELECT * FROM duckdb_functions() WHERE function_name LIKE '%sap%';

Available RFC Functions

Table Operations

• sap_show_tables - Lists all or specific tables available in the SAP system.
• sap_describe_fields - Provides detailed information about fields in a specified table.
• sap_read_table - Reads data from a specified SAP table.

Function Discovery and Inspection

• sap_rfc_search_group - Searches for function groups within the SAP system.
• sap_rfc_search_function - Searches for function modules based on specific criteria.
• sap_rfc_describe_function - Provides detailed information about a specific function module.

Function Invocation

• sap_rfc_invoke - Executes a specified function module in the SAP system.

Usage Examples

-- List all available tables
SELECT * FROM sap_show_tables()

-- Find tables starting with "FLIGHT"
SELECT * FROM sap_show_tables(TABNAME='*SPFL*')

-- Get field descriptions for a table
SELECT * FROM SAP_DESCRIBE_FIELDS('SPFLI');

-- Search for functions
SELECT * FROM sap_rfc_search_function(FUNCNAME='BAPI_FLIGHT*') ORDER BY 1

-- Get function details
SELECT * FROM sap_rfc_describe_function('BAPI_FLIGHT_GETLIST')

-- Invoke a function
SELECT * FROM sap_rfc_invoke('BAPI_FLIGHT_GETLIST', path='/FLIGHT_LIST')

-- Read table data
SELECT * FROM sap_read_table("SFLIGHT")

For detailed documentation on each function, see the individual function pages linked above.