Skip to Content

Calc view with multiple input params error

Dear Gurus,

I am having an issue with a calc view which has required input params while calling it from a stored proc. When I hard code the same value, then the stored proc runs fine, however, when I call it with a variable that I am passing in.. then I get an error. any pointers are appreciated.

while debugging the stored proc, I am able to see the value that I need, however, the error contains a funny looking message... the word [here] appears as the value which is assigned to the variable which I am using. I am confused as to where this value is getting assigned from

calcViewError.JPG (123.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 29, 2015 at 02:55 PM

    my query is now working.. the syntax is : select * from myCalView ( 'PLACEHOLDER' = ('$$i_matnr$$', '000000000000001182'), 'PLACEHOLDER' = ('$$i_location$$', 'D012'',''D005')) also I had an issue in the model which was addressed by our modeler.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 04:36 AM

    Hi Sergio,

    I'm not sure whether this could be of any help, but my guess is there is some junk value already in the variable V_MTRLS_STRING. So can you try initializing it to NULL value when u declare it and rerun the procedure.

    Regards,

    Anil

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 10:16 PM

    this same issue is happening when i call it from SQL Console.

    My query:

    select * from myCalView ( 'PLACEHOLDER' = ('$$i_matnr$$', '000000000000001182'),

    'PLACEHOLDER' = ('$$i_location$$', '''D012'',''D005'''))

    The error is:

    Could not execute 'SELECT *, ...' in 11 ms 81 µs .

    SAP DBTech JDBC: [2048]: column store error: search table error:  [6968] Evaluator: syntax error in expression string;expected TK_RPAREN,parsing "in (\"MATNR\",'000000000000001182') AND in (\"WERKS\",''[here]D012','D005'')"

    Why does the [here]  show on the error.. I am not sure where that is coming from.

    the funny thing is that if i pass a single value, then i get a result back..

    in my calc view i have a filter expression that looks like this:

    in ("VWERK",'$$i_location$$')

    and

    in ("MATNR",'$$i_matnr$$')

    Add comment
    10|10000 characters needed characters exceeded