Checking dependent object of a table in SAP HANA

SAP HANASAPSAP Basis

This can be checked via SQL query on view in HANA system. Try run the below query −

SELECT "DEPENDENT_OBJECT_NAME" from "SYS"."OBJECT_DEPENDENCIES" WHERE "BASE_SCHEMA_NAME"
 = 'AF_HANA' AND "BASE_OBJECT_NAME" = 'STORE' AND "DEPENDENT_OBJECT_NAME" Not like
'%hier%';

raja
Published on 25-Apr-2018 19:38:47
Advertisements