HANA db view creation

[former_member556668]

Hello,

As part of requirement, I have to create HANA DB views (not calculation view) with select statements on tables. I am able to create them in sql console using syntax as

create view ( ,,,) AS

select bkpf.belnr, bkpf.bukrs, bkpf.gjahr, bseg.buzei,

from bkpf inner join bseg on *******.

we have change request enabled for transports. If i create the views from sql console as above, it doesn't ask for a change request. How do i create the views so that i can attach to the change request and transport across landscape.

Thanks,

Ram

[lbreddemann]

This can be done either by using the classic HANA repository development or the new HANA XSA HDI development.

SQL Views can be modeled as .hdbdd or .hdbview files with both approaches.

All of this is documented in detail in the Developer Guides for SAP HANA, in numerous tutorials and also shown in videos of the SAP HANA Academy. Beyond that, this whole approach is extensively explained in the free HANA development courses on openSAP.

Successful learning!

[former_member479339]

Hi,

Once you create the view it will be visible under the dropdown of views of your schema.

So just test it completely and re-execute the statement in PROD.

For some of the SQL based objects the change number is not created in SAP HANA.

Best Regards,

Sumeet