Skip to Content
-1

where used list for tables in HANA

Nov 24, 2017 at 05:21 PM

108

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member
Nov 27, 2017 at 09:56 AM
1

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Excellent, this view "OBJECT_DEPENDENCIES" from SYS schema, solved my problem. :-) Thanks

0
Former Member

I am glad to hear that :-)

best regards

Thorsten

0