hi how to bind the table values to the variable in sql script procedure in sap hana

[Former Member]

lt_material = select "KNDNR", "ARTNR", "MATKL","VV010" from "ARUN"."CE1IDEA" where "ARTNR" = :artnr;

am i assigning the lt_material to select statement result it can shows an un authorized error in procedure

[lbreddemann · Accepted solution]

Sounds like you haven't assigned _SYS_REPO the SELECT privilege (with grant option) on the ARUN schema or the CE1DEA table.

[Former Member · Accepted solution]

hi lars

thank you i have clarified doubt you  given information