Skip to Content
0
Aug 22, 2018 at 04:18 AM

HANA db view creation

393 Views

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