Register Login

Different Types of Views in SAP HANA

Updated May 30, 2018

SAP HANA offers two kinds of works which is mainly known to be as plain SQL views and COLUMN views. Basically SQl views are being generated using the CREATE VIEW and COLUMN VIEW is being generated using the COLUMN VIEW. 

SQL view is nothing but is same as views in all other DBMS. You would have to use SELECT statement programmed in a dictionary objects which will further help you in using the table of its own. It does not matter if ROW or COLUMN engines being elaborated with in executing queries in contradiction of the views that are not dependent on the view type. You can easily use row-store and column store tables, same as like you can easily do in the SQL.

On the other hand column view is nothing but the SAP HANA specific view type. It enables you to generate the structures same as that of view which is further known as calculation scenarios. We can also call SAP HANA modeler views as column views within the specific calculation scenario allocated to them. But stagnant HANA appears to distinguish between "Views" and "Column Views".

As soon as you generate the views using the SQL based within the column tables, you will find that those views will act like the column tables or row store tables from a performance point of view, let us have an example of attributes and one of the views.

Hope this article might help you for the above issue.


Comments

  • 04 Jul 2013 11:06 am suntrainings3
    SunTrainings provides SAP Hana Online Trainings on LIve Projets With Real time corporate
    trainers. Most number of our students got placed in leading bussiness environments.

    SunTrainings Provides SAP HANA Classroom & Online Training in Uk,Usa,Canada,
    Australia, Singapore, Africa,Saudi,Singapore, Srilanka, Newzealnd, England , Srilanka,
    india, JAPAN, SWEDEN, London, Europe, U.K, U.S.A, Mexico City, Spain, Colombia, Sap online
    training for SRM,MM,SD,CRM,HR,HR-ABAP,HANA.

    contact: 9642434362

    email: contact@suntrainings.com
  • 13 Nov 2013 4:29 pm Guest
    Best online training Classes on Abinitio Courses by Smart mind online training, Hyderabad, India.Smart mind online training is an best online training provider for IT Technologies by real time faculty.Smart mind online training offers 24*7 technical support by IT Industrial Experts.Please contact us for free Abinitio online demo Phone num: 91 9949599844, USA:1-347-606-2716. Email:contact@smartmindonlinetrining.com
  • 13 Nov 2013 4:31 pm Smartmind Cls
    Best online training Classes on Abinitio Courses by Smart mind online training, Hyderabad, India.Smart mind online training is an best online training provider for IT Technologies by real time faculty.Smart mind online training offers 24*7 technical support by IT Industrial Experts.Please contact us for free Abinitio online demo Phone num: 91 9949599844, USA:1-347-606-2716. Email:contact@smartmindonlinetrining.com

×