Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Pass multiple values to procedure

Hi Experts,

I am calling a Calculation View inside a procedure.

My View has a mandatory input parameter and mandatory variable.

I am calling procedure as

BEGIN

SELECT SUM("SALARY"), "EMPNAME", "EMPID","COUNTRY",'REGION","DEPARTMENT"

FROM "_SYS_BIC"."Models/CV_EMP"

( PLACEHOLDER."$$P_DEPARTMENT$$" => :P_DEPARTMENT)

WHERE (("COUNTRY" IN (:V_COUNTRY)))

GROUP BY "EMPNAME", "EMPID","COUNTRY",'REGION","DEPARTMENT"


END;

I am able to pass single values to the procedure and it works fine.

My question is how to pass multiple values to the variable and input parameter?

Regards,

Rohit

Former Member
Not what you were looking for? View more on this topic or Ask a question