Skip to Content

Variable and input parameter error

Hi All,

I am getting below error when clicking value help in varible screen of Calculation View.

SAP DBTech JDBC: [2048]: column store error:search table error: [6968] Evaluator: system error in expression string; expected TK_ID,parsing

'in("MATNR",[here])'

I have selected value help from current view column.

Variable is on a calculated column "YEAR" which is derived from "DATE".

I want to know why is this not showing the list of year values in the view. Same case when i use value help as current view in input parameter of MATNR. Please help me in solving this issue.

Thanks,

Rithika

Capture5.PNG (30.7 kB)
Capture6.PNG (40.0 kB)
Capture7.PNG (41.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jul 11, 2016 at 03:56 AM

    I think the error is generated due to Input parameter(IN_MATNR) can you show the screen shot of that IP, so that I can check what could be the issue. Is it derived from Table??

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2016 at 06:36 PM

    Issues is due to Input Parameter, which is not defined with any default values. If you define the default value to "XXXX" then based on that you will get the years.

    To avoid them create separate master data value helps and use them.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 23, 2016 at 07:30 PM

    Probably since the Value help for "YEAR" is defined on the Current View which is in-turn expecting mandatory parameter for MATNR and hence resulting in the error.

    Regards,

    Krishna Tangudu

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.