How to use/pass User Defined Table Function Parameters to BEx Variables
Purpose: I have requirement to use UDTF (User Defined Table Function) parameters in BEx report however I ended with lot of issues/errors and could not able to go further however finally I figured out proper steps to use UDTF parameters to BEx report.
Step 1: In UDTF I have used parameter called p_calday to pass date
Step 2. Create calculation view on top of this UDTF and map variable as like below
Step 3: Right click on “Input Parameters” and select “Manage Mappings” as like below
Step 4: Select variable p_calday and select copy and map 1:1
Step 5: After copy & mapping, you can see as like below
Step 6: Create Composite provider on top of Calculation view and create assignment in composite provider as like below
Step 7: Right lick on assigned parameter and select edit
Step 8: Assign proper InfoObject as reference to parameter
Step 9: Activate composite provider
Step 10: In Bex report drag & drop variable of 0CALDAY as like below.
Step 11: Make sure above 0CALDAY variable should have below settings then only it will work:
Note: you can change variable represents to multiple however need adjust where clause in UDTF select query.
Thanks for reading.