how to explicitly create a column view

[rajarshi_muhuri]

How do I explicitly create a column view ( something like CE1xxxx and CE4xxxx ) .

Please note : I am NOT asking about how to create a view (CREATE VIEW <view_name> [(<column_name>,...) ] AS <subquery>)

[rainer_winkler]

Hi Rajarshi,

you create Column Views with the statement CREATE COLUMN VIEW. You can see the syntax when you display Column Views generated by SAP in the SAP HANA Studio. But it seems, like SAP did not provide the documentation for this, so I personally would hesitate to use undocumentated Statements.

Regards

Rainer

[former_member184768]

Hi Rajarshi,

I did not quite understand your requirement. To my knowledge, the column views for the tables are automatically created by HANA.

What exactly do you need to do. Can you please elaborate the requirement.

Ravi

[rajarshi_muhuri]

having some errors importing column views from ecc , so wanted to hand create them

[Former Member]

Hi

You can create the view on base table with the help of below sql statement

Check the 96 page in SQL reference guide

The restriction here is you need to select columns from one table

Regards,

Venkatesh

[former_member184768]

Just for the better understanding, can you please post the error message.

Ravi

[justin_molenaur2]

Like Ravi, I am a little unclear as to your requirement, can you please elaborate and we can assist further?

You don't import COLUMN VIEWS from ECC, you import TABLES (assuming you are using SLT). After creating some content, ie analytic views, HANA automatically creates the COLUMN VIEW for you.

I am thinking that you are trying to import HANA models via KEHA and are hitting some errors? If that is the case, then you simply need to ensure the underlying tables (CE1... etc) are replicated, then build your modeling content on top of that.

Regards,

Justin