Syntax
To find a table you are looking for, you can use the sap_read_table function. This function returns a list of all available tables in the SAP ERP system.
The function has the following signature:
SELECT * FROM sap_read_table("<tablename>", [THREADS = NUMBER_OF_THREADS], [MAX_ROWS = NUMBER_OF_MAX_ROWS], [FILTER = '<query filter>'])Example usage
SELECT * FROM sap_read_table("SFLIGHT")