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
Articles by John SAP
Page 5 of 9
Security folder in SAP HANA Studio
Last folder in SAP HANA Studio system navigation is Security and it has 3 subfolders inside it that defines the system security policy and user management activities −SecurityUserRolesIn Security tab, you can also define Password Policy of HANA system.In Users tab, you can find list of all the existing users in SAP HANA system. You can also create a new User or a restricted user in SAP HANA.In Roles tab, you can see all the existing roles in SAP HANA system.
Read MoreSearching a user in SAP HANA system using HANA Studio
Users tab defines the list of existing users in HANA system and you can also create a new user, new restricted user or find a user in HANA system.In above pic, you can use Find User to filter a particular user from existing list.
Read MoreUse of Role tab in SAP HANA system using HANA Studio
Roles tab is used to define the existing roles in HANA system and you can also create a new role in HANA system to add to user’s profile as per requirement.To add privilege to a new role, you have to click on “+” sign.
Read MoreChanging default schema in SQL console in SAP HANA
To change the default schema, you have to select schema name from Catalog folder and click on SQL tab at the top.You can also right click on Schema in which you want to create Relational objects and select Open SQL Console. In below pic, you can see the Schema AA_HANA11 and right click → Open SQL Console.At the top of SQL console, you can see Schema name where the objects will be created using this console.
Read MoreGranting _SYS_REPO with SELECT to user schema in SAP HANA
In SAP HANA system _SYS_REPO user is required to create run time objects that are saved in HANA database under _SYS_BIC schema. When you activate modeling views in HANA, SYS REPO provides the read access to users on these modeling views. That is why it is required to grant _SYS_REPO with SELECT with GRANT privilege to user schemas.GRANT SELECT ON SCHEMA "SCHEMA_NAME" TO _SYS_REPO WITH GRANT OPTIONThis is required when you use objects of a table/view of a schema to build HANA Modeling Views. You need to grant _SYS_REPO the SELECT WITH GRANT privilege on this schema.
Read MoreRefreshing a schema after creating a table in SAP HANA database
Let us say you have executed the below create table SQL statement in HANA database −Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );To check the table in HANA database, navigate to AA_HANA11 schema and right click and refresh (F5). Navigate to “Table” folder and you can see new table with name Demo_HANA is created.
Read MoreInserting data in a table in SAP HANA
To insert the data, you need to run the Insert statement in SQL editor. “Demo_HANA” is table name.Insert into Demo_HANA Values (1,'John'); Insert into Demo_HANA Values (2,'Anna'); Insert into Demo_HANA Values (3,'Jason'); Insert into Demo_HANA Values (4,'Nick');In SQL editor, add INSERT statements and execute (F8) as below −
Read MoreChanging storage type of table in SAP HANA database
You can also convert a Column store table to a Row store table or a Row store table to Column store table using ALTER table command.Alter table "AA_HANA11"."DEMO_HANA" column;
Read MoreAdding a Page break/new page in SAP Script
To add a new page, you can use Control command NEW-PAGE in Transaction SE71.SyntaxNEW-PAGE [page_options] [ spool_options]EffectThis statement creates a new page in the current list and writes the subsequent list output into a spool list.In T-Code: SE38 Print Program, you can use Function Module CONTROL_FORM to call NEW-PAGE command as below −CALL FUNCTION 'CONTROL_FORM' EXPORTING COMMAND = 'NEW-PAGE' EXCEPTIONS UNOPENED = 1 UNSTARTED = 2 OTHERS = 3.
Read MoreCalling an ABAP Function Module using Python script to put data in SAP HANA
You can refer this SAP blog how to use SAP NetWeaver library with Python.SAP Link
Read More