Question Re: Variable and input parameter error in Technology Q&A

Variable and input parameter error

former_member224444 — Sun, 10 Jul 2016 17:07:26 GMT

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

Re: Variable and input parameter error

chandan_praharaj — Mon, 11 Jul 2016 03:56:56 GMT

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??

Re: Variable and input parameter error

Former Member — Sat, 23 Jul 2016 18:36:33 GMT

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.

Re: Variable and input parameter error

former_member182302 — Sat, 23 Jul 2016 19:30:13 GMT

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