Found 694 Articles for SAP HANA

With use of Where-used functionality you can easily find this information. Right click on object name → Where-Used

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

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

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 and this will show you list of all tables in a schema.Select distinct BASE_OBJECT_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like 'AF_HANA';AH_HANA- Schema name

This can be checked using below SQL query and it will display all system schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like ‘_SYS%’;

This can be checked using below SQL query and it will display all the available schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES"

In SAP HANA system, you have one view available in SAP System schema named called as “OBJECT_DEPENDENCIES” and it can be used to get the information of SAP Tables.To see details in this view, run this query: select * from "SYS"."OBJECT_DEPENDENCIES";This will display all the details of SAP HANA system.

In SAP HANA system, you have one view available in SAP System schema named called as “OBJECT_DEPENDENCIES”

 In SAP HANA, you can define package specific default schema as an authoring schema in your schema mapping definition and maintain it in the table M_PACKAGE_DEFAULT_SCHEMA.To perform this, navigate to SAP HANA Modeler perspective →; Maintain Package Specific Default SchemaSelect HANA system and it will show you schema names mapping as per package.  You can maintain a default schema for each package. You can also add packages by clicking on Add button.

Schema mapping in SAP HANA is used to move objects from one system to other system i.e. from Development system to Test or Test system to production system.To open schema mapping, navigate to SAP HANA Modeler → Schema Mapping → Select system you want to perform operationIn next window, you have to perform schema mapping between Authoring schema and physical schema.