Skip to Content
0

Passing Multivalued Input Parameter to Table Function

Aug 22, 2017 at 11:09 AM

26

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers