How to iterate over internal table in SQL procedure?
I work on port some ABAP code to the HANA SQL stored procedure.
One of the input parameter has table type.
I want to know how I can iterate over this table?
In the ABAP I can write something like this:
LOOP AT lt_table ASSIGNING <fs_row>.
But I don't know how to do such loop in HANA.
lt_rows = SELECT * FROM :TBL_DATA;
FOR ls_rows AS :lt_rows DO
leads to syntax error near lt_rows.