Skip to Content
0
Former Member
Aug 22, 2017 at 11:09 AM

Passing Multivalued Input Parameter to Table Function

124 Views

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