Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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,


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Found the solution.

After migrating script-based view to table function, a new object TABLE_FUNCTION_XXX.hdbtablefunction will be generated automatically and its initial status is inactive.

Need to activate this .hadtablefunction manually from repositories window, afterwards can activate the view successfully.

0 Kudos

Hi Tim: What version of Hana Studio and SAP HANA database you are using?

What is the procedure if you want to create new table function?