Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
SAP Basis Articles
Page 33 of 50
Checking tables in a schema in SAP HANA database
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
Read MoreChecking 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%';
Read MoreUsing Where-Used option in SAP HANA Modeling
With use of Where-used functionality you can easily find this information. Right click on object name → Where-Used
Read MoreDeleting inactive objects in SAP HANA
In SAP HANA, you can delete all inactive objects in workspace. In HANA Modeler Perspective → Delete Inactive Objects..You can also revert to last active version if exists.
Read MoreAdding rows in an internal table with header line in SAP ABAP
Note that you shouldn’t use headers with internal tables. As you are using it, and header of in_table2 is empty. Use the loop to print it as below −LOOP AT in_table2. "here in_table2 means table (an internal table) WRITE / in_table2. "here in_table2 means the header of the table (a structure) ENDLOOP.When you have headers with internal tables, you shouldn’t use it in the same way. You should use field symbols for looping and append like this −FIELD-SYMBOLS: LIKE LINE OF in_table2[]. LOOP AT in_table2[] ASSIGNING . WRITE / . ENDLOOP.
Read MoreChecking transaction list waiting for lock-in SAP HANA
M_BLOCKED_TRANSACTIONS System View is used to provide a transaction list waiting for locks.You can run the following SQL query in the editor −SELECT * FROM M_BLOCKED_TRANSACTIONS;Details available under M_BLOCKED_TRANSACTIONS System View in SAP HANA
Read MoreActivating an Attribute view in SAP HANA
This can be checked by looking at view name in a package. If there is a Grey diamond mark on the name it means View is not activated.
Read MoreDefining a primary key in an Attribute view in SAP HANA
This can be done by selecting column name from the list of columns under Output pane.
Read MoreGetting statistics details of SAP HANA system
_SYS_STATISTICS- This schema stores all system configuration and parameter details of HANA system.You can find this under Catalog folder in HANA Studio once you select relevant HANA system in System pane.
Read MoreDifferent schema types in SAP HANA database
In SAP HANA database, there are 3 types of schema −User Defined Schema: These schemas are created by database users or administrators. All the schemas under Catalog tab except from System defined and SLT derived schemas are user defined schemas.System Defined Schema: These are generated as result of using HANA related functions. These are of following types −_SYS_BI_SYS_BIC_SYS_REPO_SYS_STATISTICS_SYS_XS-ENGINESLT Derived Schema: These schema are generated as part of SLT Data replication in HANA.
Read More