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.
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.
Hi
You can indeed use the CData SSIS 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 (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:
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 [email protected].
Hi
I did what you recommend and it worked perfectly.
Thank you very much
Regards.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.