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

Question

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

Ro L 0

Where do you actually write your query and is there a specific format? Also, Is possible to join more than two tables FROM sap SYSTEM?

User's image

Ro L 0 Reputation points

2023-06-09T11:22:21.0733333+00:00

Okay, thank you. It's a bit complex on my end because I tried to do a simple filter action in my query, I got an error. Could you provide me an example of this "custom function module"?

In the RFC table options" do I just specify the tables only and not the fields? Meaning, can I write something like this:
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-06-09T23:30:04.9466667+00:00

Hello Ro L,

Sorry, I don't have an SAP dataset to test anything from my end, but for your questions.

For the "RFC table options", you will need to specify the table join statement to feed into your function module as OPTIONS, such as "<TABLE1> INNER JOIN <TABLE2> ON COLUMN0

Here is a Microsoft document on how to Create custom function module

The custom function module must have an interface implemented (import, export, tables) that's similar to /SAPDS/RFC_READ_TABLE2, which is the default interface used by the service.

Users need to check the SAP system to make sure any of the mentioned RFCs exist and install them if missing.

For some reason, if you are not able to install the mentioned RFCs then you need to develop a custom RFC mentioned in the document.

If you need any help with the custom function modules, please get in touch with the SAP support team for further help, as this is an SAP-related ask.

I hope this helps.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-06-12T23:42:45.21+00:00

Hello Ro L,

I am checking to see if you have any further question here.
Ro L 0 Reputation points

2023-06-13T16:18:04.2333333+00:00

Okay, thank you.

1 answer

Your answer

Ro L 0 Reputation points

2023-06-09T11:22:21.0733333+00:00

Okay, thank you. It's a bit complex on my end because I tried to do a simple filter action in my query, I got an error. Could you provide me an example of this "custom function module"?

In the RFC table options" do I just specify the tables only and not the fields? Meaning, can I write something like this:
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-06-09T23:30:04.9466667+00:00

Hello Ro L,

Sorry, I don't have an SAP dataset to test anything from my end, but for your questions.

For the "RFC table options", you will need to specify the table join statement to feed into your function module as OPTIONS, such as "<TABLE1> INNER JOIN <TABLE2> ON COLUMN0

Here is a Microsoft document on how to Create custom function module

The custom function module must have an interface implemented (import, export, tables) that's similar to /SAPDS/RFC_READ_TABLE2, which is the default interface used by the service.

Users need to check the SAP system to make sure any of the mentioned RFCs exist and install them if missing.

For some reason, if you are not able to install the mentioned RFCs then you need to develop a custom RFC mentioned in the document.

If you need any help with the custom function modules, please get in touch with the SAP support team for further help, as this is an SAP-related ask.

I hope this helps.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-06-12T23:42:45.21+00:00

Hello Ro L,

I am checking to see if you have any further question here.
Ro L 0 Reputation points

2023-06-13T16:18:04.2333333+00:00

Okay, thank you.

Answer 1

Hello Ro L,

Welcome to the MS Q&A platform.

SAP table as a source in the copy activity:

You can write your query on the rfcTableOptions field to filter the rows on the SAP table.

Regarding your other question,

Currently, SAP Table connector only supports one single table with the default function module. To get the joined data of multiple tables, you can leverage the customRfcReadTableFunctionModule property in the SAP Table connector following steps below:

Write a custom function module, which can take a query as OPTIONS and apply your own logic to retrieve the data.
For the "Custom function module", enter the name of your custom function module.
For the "RFC table options", specify the table join statement to feed into your function module as OPTIONS, such as "<TABLE1> INNER JOIN <TABLE2> ON COLUMN0".

Please see this documentation.

I hope this helps. Please let me know if you have any further questions.

Share via

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

1 answer

Your answer