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

[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.

[former_member187410]

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...

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.00/en-US/d1fc5168d2951014ae99845a73...

Thanks & Regards,

Sardar..

[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.

[pfefferf]

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.

Regards,
Florian

[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).

[pfefferf]

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.