SAP Table Connector - How to querying SAP table using RFC from Azure Synapse

Hello @Rafael Mendonca ,
Thanks for the question and using MS Q&A platform.

As I understand you are using the SAP Table connector in ADF / Synapse and want a query with more than one WHERE clause (:...WHERE A = B AND X - Y"). You have tried the obcious symbols like AND and && without luck.

After checking the connector documentation, I thought someone just forgot to add the logic, but given you tried the obvious without success, I think it must be something else. I haven't found anything helpful in the SAP docs, which seems odd. Also odd is how sparse information about this is. I found two sources suggesting AND / OR is possible, but in both cases, the interface seems much different.

What is even more bizzare, is that AND does not appear in SAP list of Reserved Words! Although it does appear in their operators.

You may be right on it only takign 1 WHERE clause, given how the default module doesn't do table joins. A Custom function module definitely would be able to do this. I'll ask around.

PyRDC with multiple optiosn
read-sap-tables-with-rfc-read-table-in-mule-4
RFC_READ_TABLE.html
How to define where clause for RFC_READ_TABLE

Please do let me if you have any queries.

Thanks
Martin

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Hi,
I am able to use 'AND and 'OR' operator in RFC Function module. As an example, you can simply say-

GJAHR EQ '2024' AND BUKRS IN ('VALUE1', 'VALUE2')

GJAHR EQ '2024' OR BUKRS IN ('VALUE1', 'VALUE2')

Let me know if it helped or you found any alternative solution.

Thanks,
Maddy