Skip to Content
Former Member
May 19, 2016 at 12:26 PM

Convert script view to table function: Error reading table function TABLE_FUNCTION_XXX


Dear all,

In HANA SP12, there is a new feature that HANA Scripted views can be replaced by table functions.

I migrated one of my script-based calculation view, and when I was trying to activate this migrated view, I met the error message:

Error reading table function TABLE_FUNCTION_XXX

I seached the SYS_BIC schema and could not find this table: TABLE_FUNCTION_XXX. (I think a corresponding table starting with TABLE_FUNCTION will be created under SYS_BIC schema, cause I see some other tables with similar name).

So my question is:

Is there any step I missed when I migrate the script-based view to table function?

Should I manually create TABLE_FUNCTION_XXX? Or this table will be created automatically during migration?

Thanks and best regards,