Yes, SAP HANA's dictionary views can be used to find the columns returned by a table-valued function. The view 'FUNCTIONPARAMETERS' can be used to retrieve the function definition of the table-valued function, which includes the data types and names of the columns returned by the function. The view 'MFUNCTION_PARAMETERS' can also be used to retrieve the same information, along with additional details such as input parameters and return type.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2022-10-31 11:00:00 +0000
Seen: 13 times
Last updated: Mar 11 '23
Is it possible to provide parameters to a .sql file in SAP HANA?
How can SAP HANA be deployed with Javascript?
What is the method to preserve a video in SAP HANA?
What is the process for importing .csv files into a SAP HANA Trial account?
What is the Eclipse IDE used by SAP HANA?
Is R language compatible with SAP HANA cloud?
How can information be transferred from SAP HANA to Salesforce?
Is it possible to invoke a .sql file from another file within SAP HANA?