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

Question

Hello Experts,

We are using SAP Table Connector on Azure Synapse to extract SAP tables. However, we would like to filter the data in the copy activity.
I tried using the RFC table options using the COLUMN EQ 'SOME VALUE' pattern,

This worked, but we would like to apply more filters like "AND" and "OR", like this "COLUMN EQ 'SOME VALUE' AND COLUMN1 EQ 'SOME VALUE' ", I don't know if this is possible, or if there are better ways to do this type of filter.

How can we overcome this issue?

Thanks for listening.

Answer 1

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

Answer 2

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