cancel
Showing results for 
Search instead for 
Did you mean: 

Passing Multivalued Input Parameter to Table Function

Former Member
0 Kudos
143

Hi,

I am passing multivalued Input parameter into an table function through Graphical calc view.


FUNCTION "FN_BOM" (IP_HEADER_2_MAT nvarchar(500))

RETURNS TABLE ( "<> ")

------------------ syntax used in table function to use multivalue IP--------------

base = select distinct zsource, matnr as header_mat, werks, stlnr, stlal

from ECC.mast ;

base_q = APPLY_FILTER(:base, :IP_HEADER_2_MAT);

------------------------------------------------------------------------

while running and passing the IP value in graphical calc view - getting following error -

"sql syntax error exception: sql syntax error: SQLScript APPLY_FILTER: condition in filter variable is incorrect:".

Single value IP is working fine, is there something wrong in APPLY_FILTER use ?

Any Idea ?

Thanks,

Subbu

Accepted Solutions (0)

Answers (0)