Skip to Content

HANA modelling: Table name which stores all object names in HANA studio.

Jul 12, 2017 at 04:43 AM


avatar image
Former Member

Hi All.

I need a table name which stores all objects name viz. list of all Attributes views, Analytical Views, Calculation views.

Like, in ABAP we have a standard table TADIR which stores all program name.

And also, need to find what all HANA database procedures are available from some table.

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

2 Answers

avatar image
Former Member Jul 12, 2017 at 07:45 AM

Hi Amit,

select * from "_SYS_BI"."BIMC_CUBES" or BIMC_PROPERTIES will provide the list of all the AV, ANV, CV (cons - all the column names are listed)

The above select statement serves your requirement... It provides list of all Calculation view Names...

Below SAP link provides SAP HANA database views and its purpose...

Thanks & Regards,


Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Sardar. Thanks for your valuables.

Your query runs successfully. It gives me partial list of views. Its fine.
But is there any table in HANA studio, which stores all views in system.
If yes, then under which schema it resides?

Thank you.

Florian Pfeffer
Jul 12, 2017 at 05:41 AM

If you would have invested some time to check the online documentation for SAP HANA you would have found following:

  • System View VIEWS, which lists all available views. The different types can be separated by column VIEW_TYPE.
  • System View PROCEDURES, which lists all available procedures.


Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for reply Florian.

I have try to find out with your way but, still the question remains same.

If I create attribute view AT_CUSTOMER, then this name (AT_CUSTOMER) may get stored in some table or view. Then how to find out that table/view name in HANA studio to get above view name (AT_CUSTOMER).


Don't really understand your issue. What information you require? You can find the view listed in the the system view VIEWS as already described.