Find External HANA view in Calculation View

[andrzej_as]

I need to find HANA Calculation View where a certain external SAP HANA view is used? Do you know any standard HANA table/tables that stores such information? Anything I can use in a SQL statement?

[fedaros · Accepted solution]

Hi andrzej_as,

What you mean with external SAP HANA view ? Is the ABAP external view ? https://help.sap.com/doc/saphelp_nw74/7.4.16/en-us/4e/c0a4816e391014adc9fffe4e204223/content.htm?no_...

In such case select * from synonyms where object_name like '%<yourview>%' will show what is the external name of your view.

https://help.sap.com/doc/saphelp_nw74/7.4.16/en-us/4e/c0a4816e391014adc9fffe4e204223/content.htm?no_...

Is dependencies between objects ?

Take a look on https://blogs.sap.com/2016/09/16/how-to-found-dependent-database-object-in-sap-hana-modeling-object-...

Regards, Fernando Da Rós

[andrzej_as · Accepted solution]

Thank you Fernando.