Skip to Content
-1

where used list for tables in HANA

Hi all,


For information models we have the "Where used" list, using it we can identify the places where the information models has been used.

Now i have to do a "where used" list on a particular table. I wish to get all the information models that use this table.


How can i achieve this in HANA? We are on HANA 1.0 SP12.


Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 27, 2017 at 09:56 AM

    Hi,

    you can do something like this:

    SELECT

    BASE_SCHEMA_NAME, BASE_OBJECT_NAME, DEPENDENT_SCHEMA_NAME,DEPENDENT_OBJECT_NAME, DEPENDENT_OBJECT_TYPE

    FROM "SYS"."OBJECT_DEPENDENCIES"

    WHERE BASE_SCHEMA_NAME = 'SAPSR3'

    AND BASE_OBJECT_NAME = 'MARA'

    AND DEPENDENT_OBJECT_TYPE = 'VIEW'

    AND DEPENDENT_SCHEMA_NAME = '_SYS_BIC'

    Best Regards

    Thorsten

    Add comment
    10|10000 characters needed characters exceeded