Where-Used list for HANA Tables

[Former Member]

Hi Experts,

We are using HANA Enterprise Edition and ECC as a source. ECC Tables are replicated in HANA.

Is there a way to find out in which Attribute or Analytic views a Table is used.

Something like Where-Used list.

If I decide to drop a table in HANA, I want to know what all Models it will impact.

I am able to find the Where-Used button for Models but not for the base tables.

Regards,

Sandeep

[rindia · Accepted solution]

Hi Sandeep,

We do not have where-Used functionality for tables.

The alternate solution is to write SQL querying from tables referring to repository.

Here is the SQL

SELECT   BASE_SCHEMA_NAME, BASE_OBJECT_NAME,

               DEPENDENT_SCHEMA_NAME,DEPENDENT_OBJECT_NAME,

               DEPENDENT_OBJECT_TYPE

FROM     "SYS"."OBJECT_DEPENDENCIES"

WHERE   BASE_SCHEMA_NAME = 'SRK'                /*   <==  Schema Name */

     AND   BASE_OBJECT_NAME = 'EMPLOYEE'      /*   <==  Table Name     */

;

Query looks simple but it took me more than 2 hours to find the solution

Regards

Raj Kumar

[Former Member · Accepted solution]

Perfect, you saved my time . Thanks for this post. Appreciate it.

Regards,

Av

[justin_molenaur2 · Accepted solution]

This table can be quite useful at times, good call.

Regards,

Justin

[Former Member · Accepted solution]

Hi Raj,

I came across the exact same requirement today and your solution above is very useful. Small question though: where do we find the list of such system tables? This is so that in the future if there is any such requirement it will help to look into those.

Thanks in advance.

Regards,

Manish

[lbreddemann · Accepted solution]

Easy - it's in the documentation

https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/cbb10c75191014b47ba845bfe499fe/content.htm?...

Not to lower the cheer about the DEPENDENCIES-views, but to provide heads up here:

• the view doesn't care for references from repository content
• the view doesn't revolve multiple reference levels

The later means if you for example want to figure out what objects are going to be affected, when you touch this table, you need to check all the way from the table and it's direct depends to the objects dependent on those and so forth.

- Lars

[former_member205400 · Accepted solution]

Hey Raj,

I used that table a lot, but recently found that the dependencies to Analytic Views are not there.

The tables that are in the Analytic view are there but other views ( like a AT view ) that joins to the base table are not.

There must be a different table for these?

Mike

[former_member728709 · Accepted solution]

It helped me Raj. Thank you

[former_member747869]

This is really a helpful blog I am really impressed with your work, keep it up the good work

Tables in HANA database can be accessed from HANA Studio in Catalogue tab under Schemas

[former_member751591]

Regarding your posted answer: Please raise your question again as a new question and follow our Rules of Engagement.

The author of the original question is no longer active in the community and won't receive your query.

Feel free to also take our Q&A tutorial . With these tips you'll be able to prepare questions that draw responses from our members.

Thanks!

[Former Member]

This message was moderated.

[Former Member]

Thanks a lot Raj.

Its really helpful.