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.

When you add a new system under HANA Studio, below screen comes where different folders are available to manage HANA system. To open SQL editor, you have to select HANA system and click on SQL button at the top.Once you click on SQL button to open SQL console for selected ... Read More

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 ... Read More

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 ... Read More

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 ... Read More

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 ... Read More

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;

To convert a Column store table to row store, you can use the following SQL statement −Alter table Table_Name row;

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 ... Read More

You can refer this SAP blog how to use SAP NetWeaver library with Python.SAP Link