Hi Everyone,

As we all know HANA Studio is the most essential part of working with HANA.

Most of the work in HANA Studio is generally done graphically using Mouse and Clicks.

But we also have many Keyboard Shortcuts available in HANA Studio that would make working easier.

So I would just like to mention few shortcuts that I use frequently.

Now in SAP HANA Studio, we can get list of all Keyboard shortcuts:

Just Go to Help -> Key Assists

Key Assist.jpg

Or Alternatively press CTRL+SHIFT+L to get list of Keyboard Shortcuts as shown below:

/wp-content/uploads/2013/10/2_291956.jpg

As you can see it’s a very long list of Shortcuts, so I will mention few useful Shortcuts that I generally use:

To Open Help, Press F1

As we know when we work in HANA Studio, we open many Tabs/Editors(Views, SQL Console, Data Preview etc all open in New Tab)

To close current Tab, we can Press CTRL+F4

To close all Tabs, we can Press CTRL+SHIFT+F4

As we work a lot with these Tabs/Editors so switching between them is very important

To switch between recently opened Editors/Tabs, Press CTRL+F6

SwitchtAB.jpg

Alternatively, we can also open Backward and Forward History for Editors/Tabs, Press ALT+LEFT or ALT+RIGHT

Or to switch between Editors/Tabs, Press CTRL+SHIFT+E

sweditor.JPG

There is one more option to switch quickly between Editors/Tabs, Press CTRL+E

/wp-content/uploads/2013/10/editor_292018.jpg

To switch between Views(like Job Log, History, Timeline etc), Press CTRL+F7

V1.jpg

To switch between recently opened Perspectives, Press CTRL+F8

P1.jpg

We use System Navigator a lot to check Tables, Views, Decision Tables, Procedures etc and collapsing everything is a tedious task

So to collapse everything in Navigator, Press CTRL + SHIFT + NUM(/)

Since HANA SPS05, we could double click on any Tab/Editor and open it in full screen

So to maximize and minimize active Tab/Editor, Press CTRL+M

To search for Repository Objects, Press Ctrl + Shift + A

Search.JPG

To create a New Project, Press ALT+SHIFT+N

To create a New Object, Press CTRL+N

New.JPG

To open any View, Press ALT+SHIFT+Q Z

It’s a pretty tough combination and for achieving this combination, press Press ALT+SHIFT+Q keys together and then release them and then press Z again

sevirew.JPG

Below is a list of Shortcuts for opening any of the Views:

Show View Alt+Shift+Q Q
Show View() Alt+Shift+Q Z
Show View(Breakpoints) Alt+Shift+Q B
Show View(Cheat Sheets) Alt+Shift+Q H
Show View(Console) Alt+Shift+Q C
Show View(Declaration) Alt+Shift+Q D
Show View(Error Log) Alt+Shift+Q L
Show View(Javadoc) Alt+Shift+Q J
Show View(Outline) Alt+Shift+Q O
Show View(Package Explorer) Alt+Shift+Q P
Show View(Problems) Alt+Shift+Q X
Show View(Search) Alt+Shift+Q S
Show View(Synchronize) Alt+Shift+Q Y
Show View(Type Hierarchy) Alt+Shift+Q T
Show View(Variables) Alt+Shift+Q V


To search for a file in Workspace, Press CTRL+H

SEARCH1.JPG

In this search, we can also Specify file extension:

SEARCH2.JPG

We also use SAP HANA Development Perspective a lot, so let me list few Keyboard Shortcuts that I use

To open Declaration of an Object, Select that Object and Press F3

DECLARE.JPG

To Check a file, Press CTRL+F2

To Activate a file, Press CTRL+F3

To open properties of any file, select that file and Press ALT+ENTER

prop.JPG

Lets say we created a File and then saved it. Then later on we edited that file.

So to go to Last edited location of that file, Press CTRL+Q

We also have Word Completion ability and ability to show template proposals in files in SAP HANA

To complete any word or show template proposals, Press CTRL+SPACE

/wp-content/uploads/2013/10/tempprop_292016.jpg

Generally we explain our written code using comments, so to generate element comment, Press CTRL+SHIFT+J

It will generate three lines to write comment as shown below

F3.JPG


We have some Keyboard Shortcuts for SQL Editor also:

To execute Query, Press F8

To execute only the Query where Cursor is, Press F9 (Note: Just make sure that different queries are separated by a Semicolon) – Thanks José Carlos Méndez for this info

To clear the Editor, Press F2

To format the Query, Press CTRL+SHIFT+O

To undo any changes, Press CTRL+Z

To open Explain Plan, Press CTRL+SHIFT+Z

We can also Press CTRL+SPACE to find schema names, tables and to complete statements in SQL console

The below figure shows all schemas starting with letter S

SQL1.jpg

Similarly to find tables and statements, we can press CTRL+SPACE

Just remember that for table suggestion, we need to write at least two letters

SQL3.jpg

As seen in above image, we are also getting, whole select statement syntax, so lets say if I select “complete select syntax“, I will see the below figure:

SQL4.JPG

I hope you have learned some new HANA Studio keyboard shortcuts today.

To create your own customized Shortcuts, check my document Creating your own shortcuts for HANA Studio

Thanks for your time


Regards,

Vivek

To report this post you need to login first.

20 Comments

You must be Logged on to comment or reply to a post.

  1. Praveen Kumar

    Hi,

        Nice work as it will help the developers to reduce those cumbersome time which we take to

    go to the perticular place by manual navigation.

    Regards

    praveen

    (0) 
  2. Witalij Rudnicki

    I got a question to “To execute Query, Press F8” as F8 actually executes all queries unless you select (highlight) the fragment that has to be executed.

    Have you happened to find the shortcut for executing only the query, where the cursor actually is?

    Thanks.

    (0) 

Leave a Reply