Tables involved in HANA views

[Former Member]

Hi All,

Lets assume we have some views like cal, analytical and attribute views.

Is there a way to know what are the physical tables are involved in those views?

Is there some kind of query to know the same?

I dont want to open every view and see it what tables are involved.

Any ideas and pointers please?

[Former Member · Accepted solution]

You may also use SQL: "HANA_Objects_ObjectDependencies" (SAP Note 1969700) for that purpose.

[Former Member · Accepted solution]

Thanks a ton Martin.

[former_member182302]

You can try like below:

SELECT * FROM "SYS"."OBJECT_DEPENDENCIES"

WHERE DEPENDENT_SCHEMA_NAME = '_SYS_BIC'

AND DEPENDENT_OBJECT_NAME = <Enter View Name'>

Regards,

Krishna Tangudu

[Former Member]

Thanks Krishna,