Skip to Content

Is it possible pass HANA Calculation View Columns to a "Table Function"

Does anybody knows whether is there any chance to pass "HANA Calculation View Columns" as "input Parameters" to a "Table Function" ?

What I need to do is the following; for every record from a Graphical Calculation view I need call a "Table Function" by sending certain paramters based on some Attributes belonging to the record from the Calculation View which is being processed.

Similar to the following link however, in my case I need get the Table Function input parameter from the content of certain Attributes belonging the record being processed:

https://blogs.sap.com/2017/05/26/playing-with-hana-parameters/

Thanks in advanced

Gustavo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 28, 2017 at 03:13 AM

    Yes, with SAP HANA 2 SP01+ it is possible to model table functions as view nodes.

    See the documentation on that.

    With HANA 1 this is not possible (at least I haven't found a way to do that). There you probably will have to resort to a cursor loop in SQL Script.

    Add comment
    10|10000 characters needed characters exceeded