Skip to Content

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

Aug 07, 2017 at 02:21 PM


avatar image

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.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Aug 08, 2017 at 12:41 AM

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.

10 |10000 characters needed characters left characters exceeded