Multiple input parameters in HANA SQLScript calculation view

[Ibrahem]

Dear Experts,

I'm trying to select data within date interval but when I put more than one input parameter i get this error

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

My code:

/*********** Begin Procedure Script ************/ 
 BEGIN 
VAR_OUT = select RYEAR AS "FISCAL_YEAR",
  DOCNR AS "DOCUMENT_NUMBER",
  RBUKRS AS "COMPANY_CODE",
  RACCT AS "GL",
  "GLAccountName" AS "GL_NAME",
  "GLAccountDescription" AS "GL_DESC",
  F.PRCTR "PROFIT_CENTER_CODE",
  PC.KTEXT AS "PROFIT_CENTER_DESC",
  RCNTR AS "COST_CENTER_CODE",
  CC.KTEXT AS "COST_CENTER_DESC",
  TO_DATE(BUDAT,'YYYYMMDD') AS "POSTING_DATE",
  "IsBalanceSheetAccount" AS "ISBALANCESHEETACCOUNT",
  HSL AS LC_AMOUNT
  FROM "FAGLFLEXA" AS F inner join "CSKT" AS CC ON F.RCLNT = CC.MANDT AND F.RCNTR = CC.KOSTL
  INNER JOIN "CEPCT" AS PC ON F.RCLNT = PC.MANDT AND F.PRCTR = PC.PRCTR
  INNER JOIN "_SYS_BIC"."sap.hba.ecc/SKA1" AS GL ON F.RCLNT = GL."SAPClient" AND F.RACCT = GL."GLAccount"
  where F."BUDAT" >= TO_DATS(:FDATE)
  AND F."BUDAT" <=  TO_DATS(:TDATE)
  AND RCLNT = '900'
  ;




END 
/********* End Procedure Script ************/

Thank you in advance.

[former_member194892 · Accepted solution]

I had the same issue. Upgraded from 2.2.8 to 2.3.5 and now everything works as expected.

Hope this helps!