Skip to Content

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.


To report this post you need to login first.


You must be Logged on to comment or reply to a post.

Leave a Reply