Table UDF in graphical CV not possible?

[Former Member]

A CV-Projection contains a table UDF and is joined with a table (see below).

Unfortunately I get below activation error and hence my question: is what I am attempting not supported or am I doing something wrong?

I have used the same UDF successfully in a scripted CV, but figuered it would be nice to use in a graphical CV too.

[henrique_pinto · Accepted solution]

I'd double check with , but documentation says it needs to be an explicit SQL SELECT statement:

User Defined Function - SAP HANA SQLScript Reference - SAP Library

A table UDF can only be called in the FROM –clause of an SQL statement in the same parameter positions as table names. For example, SELECT  * FROM myTableUDF(1)