Skip to Content
Author's profile photo Vivek Singh Bhoj

Keyboard Shortcuts in HANA Studio

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

Assigned Tags

      23 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Raman Korrapati
      Raman Korrapati

      Very useful tips and helpful too. thanks for sharing vivek

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Raman,

      You are always the first person to like and comment on my blogs.

      Thanks for always supporting me

      Regards,

      Vivek

      Author's profile photo Srinivas Kakarla
      Srinivas Kakarla

      Good one. Thanks for sharing.

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Srinivas!

      Regards,

      Vivek

      Author's profile photo Former Member
      Former Member

      Hi Vivek ,

      Thanks for sharing

      good one

      Regards

      Prashanth

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Prashanth

      Regards,

      Vivek

      Author's profile photo Former Member
      Former Member

      Nice Vivek...Good Work

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Naveen!

      Regards,

      Vivek

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Hi Vivek,

      Good job...Nicely presented...Thanks for sharing 🙂

      Regards

      Krishna Chaitanya.

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Krishna 🙂

      Regards,

      Vivek

      Author's profile photo Kartik Natarajan
      Kartik Natarajan

      Dear Vivek,

      Thanks for sharing the useful info.

      regards

      kartik

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Kartik,

      Regards,

      Vivek

      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Vivek,

      good job.

      All the best,

      Andy.

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Andy

      Regards,

      Vivek

      Author's profile photo Former Member
      Former Member

      Nice post Vivek this will definitely be helpful..

      Author's profile photo Rama Shankar
      Rama Shankar

      Thanks Vivek! 🙂

      Rama

      Author's profile photo Former Member
      Former Member

      Thanks Vivek for sharing such an important details.

      Regards

      Zarif

      Author's profile photo Praveen Kumar
      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

      Author's profile photo Witalij Rudnicki
      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.

      Author's profile photo Former Member
      Former Member

      If you want to execute just that particular query, you can use F9.

      Author's profile photo Shunthini Kumar
      Shunthini Kumar

      I really appreciate the work you have done, you explained everything in such an amazing and simple way. Gained some insights about sap hana. Thank you so much.

      Author's profile photo Aaron Wang
      Aaron Wang

      请问如何设置SQL的关键字的自动转大写?自动提示输入的字段名?

      Author's profile photo Aaron Wang
      Aaron Wang

      How to set the automatic capitalization of SQL keywords? Automatically prompt for the field name entered?

      thanks.