cancel
Showing results for 
Search instead for 
Did you mean: 

Can HANA Table Type consumed for reporting?

vikramvikshr
Explorer
0 Kudos

Hello Everyone,

Please tell me, can we consume HANA table types for reporting. If I have to consume procedure results in BO reports, can we do it using table type(output parameter)?

Regards,

Vikram

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182114
Active Contributor
0 Kudos

Hi Vikram,

Do you have a procedure and you want query the output from BO, right?

The table type itself it's not queriable but procedures have an option to create a view for the result and this is queriable. See CREATE PROCEDURE - SAP HANA SQL and System Views Reference - SAP Library

Example 2 - Using a result view

You create a procedure using a result view ProcView to return its results.

 CREATE PROCEDURE ProcWithResultView(IN id INT, OUT o1 CUSTOMER) LANGUAGE SQLSCRIPT READS SQL DATA WITH RESULT VIEW ProcView AS BEGIN o1 = SELECT * FROM CUSTOMER WHERE CUST_ID = :id; END; 

You call this procedure from an SQL statement as follows.

 SELECT * FROM ProcView (PLACEHOLDER."$$id$$"=>'5');

Is this what you are looking for?

Regards, Fernando Da Rós