Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,201 questions
SAP Table Connector - How to pass parameters to an SAP Custom Function Module
VNK Sarma Peyyety
25
Reputation points
SAP Custom Function Modules broadly take two categories of input parameter data,
- Variable data
- Embedded table data
Using Copy Data Activity, could anyone please shed light on how these two types of parameter data could be passed as an input to an SAP Custom Function Module.
Thanks a lot in advance for taking time to look into this question.. Cheers!!
{count} votes
-
KranthiPakala-MSFT 39,177 Reputation points Microsoft Employee
2023-05-18T23:38:36.76+00:00 @VNK Sarma Peyyety Thanks for using Microsoft Q&A forum and posting your query.
I'm not familiar with SAP environment and its configuration. But is your ask is how to parameterize below parameters?
If yes, then you can use dynamic expression to pass the parameter value during copy activity runtime.
As mentioned in above image,
Query_Tableis mapped at SAP Table dataset level.
In case if misunderstood your ask, please help clarify so that we can assist accordingly.
Hope this helps.
Please don’t forget to
Accept AnswerandYesfor "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members. -
VNK Sarma Peyyety 25 Reputation points
2023-05-19T12:47:36.72+00:00 Firstly, thanks a lot for the detailed example and the clear screenshots that helped understand the parameterization concept.
My question is more focused towards passing parameters to an SAP Function Module (aka, SAP BAPI).
What I hope I know,
- The name of the SAP function module has to be provided in
Custom function moduleconfiguration of theCopy Activity.
What I do not know,
- As
SAP Tableconnection linked service mandates to mention aTable, what should be provided as a Table in theDataset. Because the main intention is to call the SAP BAPI Custom function with parameters, but not to read the data from a single SAP table. - Where to pass parameters to the SAP Custom BAPI Custom function:
- Should I leverage the configuration field
RFC table optionsto pass the parameters.
- Should I leverage the configuration field
- Last but not least, is
SAP Table Connector+Copy Data Activityis even the right cocktail to achieve an SAP Custom BAPI Function call.
Following is an example function module that takes scalar inputs (IV_OPERAND_1, IV_OPERATION, IV_OPERAND_2) to perform simple math operation.
- I hope to pass these parameters with the help of
RFC table optionslikeIV_OPERAND_1 = 5 AND IV_OPERATION = '+' AND IV_OPERAND_2 = 5 -
Custom function moduleasZAS_LIB_HPL_CALCULATE_DEMO
- The name of the SAP function module has to be provided in
Sign in to comment