Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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

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

    Thanks & Regards,

    Sardar..

    Add comment
    10|10000 characters needed 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.

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

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded