# SAP Function READ\_TEXT

**URL:** <https://community.cdata.com/t/sap-function-read-text/661>\
**Category:** CData Drivers\
**Tags:** question, ssis, sap-erp, read\_text\
**Created:** [March 12, 2024, 12:40pm UTC](https://community.cdata.com/t/sap-function-read-text/661 "2024-03-12T12:40:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cbaptista](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@cbaptista](https://community.cdata.com/u/cbaptista)\
**Post date:** [March 12, 2024, 12:40pm UTC](https://community.cdata.com/t/sap-function-read-text/661/1 "2024-03-12T12:40:56Z")

</div>

Hi everyone!

I would like to know if is it possible to retrieve data from the SAP ECC 6.0 Function READ\_TEXT, using the CData SSIS Components for SAP ERP 2023.

Thanks.

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [March 12, 2024, 6:04pm UTC](https://community.cdata.com/t/sap-function-read-text/661/2 "2024-03-12T18:04:29Z")

</div>

Hi&nbsp; @cbaptista

You can indeed use the CData SSIS&nbsp;Components for SAP to connect to SAP ECC 6.0 and make use of the stored procedure ‘RFC\_READ\_TEXT’ in order to use the function READ\_TEXT as per your request.

Looking at the definition of RFC\_READ\_TEXT, TEXT\_LINES is actually a table-valued input. There are a few different ways to pass in a table-valued input to the stored procedure&nbsp;([CData SSIS Components for SAP ERP - Provider Schema](https://cdn.cdata.com/help/RYJ/rssis/pg_datamodel.htm)), but by far the easiest is to pass in a JSON input to the TEXT\_LINES field. The correct syntax for running this operation is as below:

```auto
EXECUTE RFC_READ_TEXT TEXT_LINES='{ \"TDOBJECT\": \"MATERIAL\", \"TDID\": \"GRUN\", \"TDSPRAS\": \"I\", \"MANDT\": \"100\", \"TDNAME\": \"000000000400007212\" }'

```

Note that the above statement is an example. You might need to review the values you need to provide as an input parameter for TEXT\_LINES.

In case you have any questions about this or anything is unclear for you, feel free to reach out to our support team at [support@cdata.com](mailto:support@cdata.com).

---

<div class="post-metadata">

**Author:** ![cbaptista](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@cbaptista](https://community.cdata.com/u/cbaptista)\
**Post date:** [March 26, 2024, 7:34pm UTC](https://community.cdata.com/t/sap-function-read-text/661/3 "2024-03-26T19:34:55Z")

</div>

Hi @Ethem_Q

I did what you recommend and it worked perfectly.

Thank you very much

Regards.