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

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%';

SAP ABAP Expert

Updated on: 13-Mar-2020

496 Views

Kickstart Your Career

Get certified by completing the course

Get Started