Create a Calculation view that reads a table function as data source

[former_member507304]

Hi experts.

I'm building a test calculation view that reads from a table function:

create function "tableFunction" ()
Returns table ( "nu1" integer, "na" NVARCHAR(35), "nu2" integer)
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER AS
BEGIN
RETURN
SELECT "E_ID" as "nu1", "E_NAME" AS "na", "E_OVERTIME" as "nu2" FROM "OVERTIME";
END;

The fact is that the function works fine and it returns that test table, but i have a problem when i try to read it in the calc view:

Could you help me to solve this error or if it is not possible to do this. How could I read from a procedure or something that allows me to clean data before load it on hana?

Thanks in advance.

[lbreddemann · Accepted solution]

Use a table function that was defined as a repository object.

[former_member507304 · Accepted solution]

Please could you tell me how do i do this or where can i see documentation about it ?

[lbreddemann · Accepted solution]

Checked the developer guides?

[former_member507304 · Accepted solution]

I think that not, could you indicate what are the guides for this issue of table functions? One friend told me about define a table structure and return it in instead of the table. I will chek it as soon as I will have time.

[lbreddemann · Accepted solution]

https://help.sap.com has got the whole HANA documentation including all developer guides.

Once you got the time, just use your google skills to find the specific topic.

[former_member507304 · Accepted solution]

Finally was that, a lot of thanks