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