Skip to Content
0
Former Member
Sep 22, 2014 at 10:10 AM

how to consume view data (temporary data) as a permanent data ?

22 Views

Hi,

Views are not holding any data.

How to consume view data as a permantent data into a hana table...

Manual query execution will be in Sql console or by calling a stored procedure

SELECT * FROM "_SYS_BIC"."PACKAGE/VIEW_NAME" INTO TABLE_NAME_XXXX;

because each time new data will append for a tables, & those data will be used for the views.

so the resultant view data should be stored in a table(permantely).

how to build dynamically this..

please can any one suggest how to reslove this issue..

Thanks,

Thara