Multi-value input parameter in SQLScript Procedure

[anindya_bose]

Hi Folks

I am trying to use a Graphical calculation view with input parameter inside a SQLScript Procedure . ( Basically I am trying to write an AMDP ) . This works for single value Input parameter but not getting the syntax for multi value parameter . Can someone please help ?

My objective is to take Multiple value in $$IP_MONTH$$ , like

IN ($$IP_MONTH$$, V1,V2,V3 ) where V1, V2, V3 would be different months .

     RS_OP = SELECT "USERNAME","MATERIAL", sum("NETVAL_INV") AS "NETVAL_INV"


         FROM "_SYS_BIC"."ZXXX/ZCV_AO_TOP_MATERIAL" (
        PLACEHOLDER."$$IP_USER_NAME$$"=>:V_USER ,
        PLACEHOLDER."$$IP_SOLD_TO$$" => :SOLD_TO,
        PLACEHOLDER."$$IP_MONTH$$" =>'201601',
        PLACEHOLDER."$$IP_TOP_X$$"=>:TOP_X  )

Thanks in advance !

Cheers

Anindya

[anindya_bose]

Thanks Florian. Let me try that syntax and let you know the result .

Syntax worked . Many thanks Florian.

[sap_cohort]

Did you get this to work? I tried it calling an SQLScript Calc View and it would not work.. thanks