Skip to Content
0

Calling Multi-value Input Parameter of SAP HANA Graphical View in a Scripted View

Dec 04, 2016 at 09:39 AM

142

avatar image
Former Member

Hi Experts,

I am facing a technical challenge, need your suggestion and help.

I need to make below call in a scripted view which actually calls a graphical view with IP_COMP_CODE (Multi-value input parameter).

If you look at syntax of other input parameters then it is simply with =>:IP_MANDT

In case of IP_COMP_CODE however I want to pass multi-value with IN clause (see below sub-select within PLACEHOLDER syntax) or with some other permitted approach.

Can you help me correct below syntax?

VAR_OUT =

SELECT * FROM"_SYS_BIC"."CV_GRAPHICAL_VIEW1"(PLACEHOLDER."$$IP_MANDT$$"=>:IP_MANDT, PLACEHOLDER."$$IP_COMP_CODE$$" IN (SELECT BUKRS FROM :T_COMP_CODE));

My challenge is with below section of PLACEHOLDER call which has multiple values in T_COMP_CODE -

This syntax needs to be corrected -->

PLACEHOLDER."$$IP_COMP_CODE$$" IN (SELECT BUKRS FROM :T_COMP_CODE)

Regards,

Shiwesh

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

0 Answers