ADF + SAP Tableconnector: Function Modules

Question

Hi together,

We have a setup to copy table data from our SAP system to our AzureDataFactory via the SAP table connector interface.

This works well as long as we access SAP tables. Now there is the need to access function mudules in SAP with parameters to get data.

 The documentation states that we can access function modules via the Table connector interface (customRfcReadTableFunctionModule) but it needs to be similar to the function module /SAPDS/RFC_READ_TABLE2.

 Actually, we get the error “Element QUERY_TABLE of container metadata ZZ_READ_VM unknown, Element QUERY_TABLE of container metadata ZZ_READ_VM unknown,Source=sapnco”.

 We think that this QUERY_TABLE is only a parameter which our function modules not use or need.

 

So my question: Is there a need for QUERY_TABLE and for the SAP ADF TableConnector I can only use SAP function Modules using the query Parameter QUERY_TABLE?

 

This would be critical because than we can not use the interface to Azure in our usecase...

 

Thanks for help and best regards.

Answer 1

Hi MarcusU-8790,

Based on the documentation, the QUERY_TABLE parameter is a required parameter for the SAP table connector interface. It is used to specify the name of the table to be read. If your custom RFC function module does not use this parameter, you may encounter errors when using it with the SAP table connector interface.

However, there may be a workaround for your use case. You can try creating a custom RFC function module that takes the QUERY_TABLE parameter as input, but ignores it and instead uses the parameters that your function module requires. This way, you can still use the SAP table connector interface to call your custom RFC function module.

Here is an example of how you can create a custom RFC function module that takes the QUERY_TABLE parameter as input, but ignores it:

1. Create a new RFC function module in your SAP system using transaction code SE37.
2. In the Import tab, add the parameters that your function module requires.
3. In the Export tab, add the fields that your function module returns.
4. In the Tables tab, add the tables that your function module uses.
5. In the Attributes tab, set the RFC-enabled function module checkbox.
6. Save and activate the function module.

Now, when you call this custom RFC function module using the SAP table connector interface, you can pass in any value for the QUERY_TABLE parameter, and it will be ignored by the function module.

I hope this helps! Let me know if you have any further questions.

Answer 2

Hi Shaik,

thanks for the answer - so we managed to get rid of the error about the query table parameter. But now there ist the next error: „Element of Container metadata Functionmodulename unknown“ after we also added Out_Table in the export tab.

Can you please specify how and what to add on SAP side in the export tab and on ADF table connector side how to specify mandatory import parameters for the function module.

thank you very much for your kind support!