Share via

RFC table options

Müller, André 71 Reputation points
2022-12-14T13:05:50.477+00:00

Hi, i´m using azure data factory and copy step to copy data from sap. To shrink data volume i´ve tried to use the rfc table option in combination with a pipeline variable.
This fails with sap error message, that it cannot parsed, when i hardcode the value from the variable it´s working.
Any idea about the root cause?
Is there any chance that I can see what query is sent to sap?

270554-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,092 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee
    2022-12-14T23:20:27.673+00:00

    Hello @Müller, André ,

    Thanks for the question and using MS Q&A platform.

    Looks like the issue is with the dynamic expression is not evaluating the variable value because of incorrect expression formation.

    To better assist could you please share the hard coded (actual) RFC table name and also the complete error message you are seeing. Sorry I'm not familiar with SAP hence wanted to look at the actual name of the table you would like to use in the Configuration.

    In general, if you would like to pass the dynamic names using dynamic expression, your expression would be something like below. You will have to do a concatenation to form the actual string value for your table name,. Please do try below and let us know how it goes: 

    @concat('PERIO EQ ', variables('vPeriod'))

    If the above didn't work, please share the actual name or hardcoded RFC Table options value without the variable.

    Hope this info helps. Let us know how it goes.

    Thank you

    ----------

    Please do consider clicking on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.