Checking all the list of fields for a table in SAP HANA

SAP HANASAPSAP Basis

You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query −

SELECT "DEPENDENT_OBJECT_NAME" from "SYS"."OBJECT_DEPENDENCIES" WHERE "BASE_SCHEMA_NAME"
 = 'AF_HANA' AND "BASE_OBJECT_NAME" = 'STORE' AND "DEPENDENT_OBJECT_NAME" like '%hier%';
raja
Published on 25-Apr-2018 19:37:16
Advertisements