Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers