What is the difference of creating a view in Hana and in ABAP dictionary?

[Former Member]

Dear all,

I am a little bit confused about the relation between the ABAP dictionary and the HANA level .. and in particular I am focusing on calculation view. I am more a Hana modeler than that an abap programmer. What are the advantages of doing a view in HANA?

And how can I see the content of a view? In hana, if I do this query, I do not get any data back.

Thanks,

Cristina

[lbreddemann]

There are a couple of reasons why you might not get data back from the SQL query:

1. wrong filters set
2. wrong CLIENT property set for your user and the view configured as client dependent
3. no/wrong analytic privilege to see the contents of the view
4. no data in the base tables
5. join processing filters out all records
6. ...

These possible causes have nothing or not much to do with whether the view was created in ABAP or HANA.

Speaking of which: a calculation view cannot possibly have been created in ABAP. Last time I checked, ABAP didn't provide any options to create and model calc. views (in a supported fashion).

What you can create are ABAP or HANA CDS views; but these don't seem to be your topic here.

Coming to the other question about what the benefits are: HANA can work with or without an ABAP stack on top - so the benefit of the option to create views in HANA simply is that this makes it possible to use HANA without ABAP. Think of analytic scenarios where HANA is used as a data mart without any application server.

Not sure I really got your questions, but you might want to read up on development-concepts for ABAP and for HANA to see the differences more clearly.