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 Member]

Hello Ibrahem,

Try using BETWEEN operator in your script. It worked for me.

F.BUDAT BETWEEN FDATE AND TDATE;

[Ibrahem]

getting same error with my HANA Studio.

[Former Member]

what is the version of studio you are using? I am using 2.0.13

and called it in scripted view as below

[Ibrahem]

My HANA Studio version is 2.2.8, and I tried as you mentioned but it's didn't work, and like what Mr. Florian said generated SQL is considering only one parameter.