Error While Executing Query In Hana Db: column store error: search table error

While executing an SQL statement call ‘SELECT * FROM “_SYS_BIC”.”PK.MD.MATL/CA_PHSD_MATL_CHAR”’  , (here, "REFRESH_Z_KNVH_HIER_FLAT_PROC" is a procedure)t's throwing following error message:

Could not ececute ‘SELECT * FROM “_SYS_BIC”.”PK.MD.MATL/CA_PHSD_MATL_CHAR”’ IN 59 ms.SAP DBTech JDBC: : [2048]: column store error: search table error:: [34023] Instantiation of calculation model failed:exception 306106: Undefined variable: $$IP_PROGRAM_NAMES$$. Variable is marked as required but not set in the query

Answer:

One way: Execute the View with parameter.

Ex - SELECT * FROM “_SYS_BIC”.”PK.MD.MATL/CA_PHSD_MATL_CHAR”('PLACEHOLDER =('$$IP_PROGRAM_NAMES$$','YMD_PDO_059') ')

Other way, when you do a data preview of the view.. it will ask for the Input parameter  value and you can see the data.