5dc0b56f-2e34-4d81-adca-69f47a0f1ea4.jpg

SAP Consultant

Sometimes you require a direct reading of SAP tables, and in order to do it, we have SAP-supplied function, RFC\_READ\_TABLE. Its fast and simple, but has some limitations: No check authorization objects, has small size results (512 bytes per row), only works fine with plain text, etc. (See SAP notes 2503119 and 382318)

  

**PREREQUISITES:**

\- SAP Connection with user granted for S\_DEVELOP and S\_RFC

  

**INPUT PARAMETERS:**

\- io\_SAP: SAP connection (IConnectionService)

\- iv\_table: SAP table (Ex.T001)

\- iv\_fields: comma separated fields (Ex. BUKRS,BUTXT,ORT01,LAND1,WAERS)

\- iv\_options: where clause (Ex. BUTXT LIKE '%Template%')

  

**OUTPUT PARAMETERS:**

\- odt\_fields: DataTable with fields metadata

\- odt\_data: DataTable with pipe delimited extract data.

\- odt\_results: DataTable with results cooked.

  

**EXCEPTIONS:**

\- SAP.Middleware.Connector.RfcAbapException

  

**DOC:** 

[https://docs.google.com/document/d/1NGtHMzDdMQYfY0BFw6G95THnbiKIVLzyPWAjUiUjd7Q/edit?usp=sharing](https://docs.google.com/document/d/1NGtHMzDdMQYfY0BFw6G95THnbiKIVLzyPWAjUiUjd7Q/edit?usp=sharing)

Extract data from SAP table using a BAPI (RFC\_READ\_TABLE)

About me