Calculation View with Input Parameters in ABAP

[Former Member]

HI All

I have created a calculation view which has input parameter  when I do data preview it works fine as it asks for input parameters, but when I try to use that in a select statement , I am recieving below error

SAP DBTech JDBC: [2048]: column store error: search table error:  [34092] search on calculation model requires parameters;Required variable $$shopid$$ is not set.

how can we use select statement and resolve the error to get proper result based on ,because I am trying to use this calculation view on ABAP client to get result records by accepting th input parameters from client side  and use them  for further processing .Request you to share your ideas.

Thanks

Santosh Varada

[henrique_pinto · Accepted solution]

You need to pass the parameters with a PLACEHOLDER statement in the SELECT. For the proper syntax, open the Data preview window, click on the small exclamation icon in the top right, and check the query it executes.

[Former Member · Accepted solution]

Hi Henrique

  Thanks for solving my both queries .

Thanks

Santosh Varada

[ashish_bansal · Accepted solution]

Hi Santosh Varada,

Could you please let me know how did you entered the Placeholder in ABAP coding as when i try to enter it , it gives me complile time error.

I tried to run it something like this:

SELECT * FROM EV_CV_RANGE_QURY ('PLACEHOLDER' = ('$$offset$$', '1'), 'PLACEHOLDER' = ('$$length_param$$', '2'))
    INTO TABLE lt_wrs1
  WHERE ASORT = 'MGS1' .

But it is not compiling and gives error at ('PLACEHOLDER' ...

Thanks.

Ashish

[Former Member · Accepted solution]

As I know, currently it is not possible to consume calculation view with parameters in ABAP by external views.

You can consume calculation view via Native Sql any way.

[ashish_bansal · Accepted solution]

Thanks Guoliang Zhou for your answer. Later i also found the same, so it's clear that currently it is a limitation in ABAP. So i did my query in a different way.

[sudha_rao2]

This message was moderated.