Skip to Content

Use the database explorer to check the data in your tables

You will use the Database Explorer on SAP Web IDE for SAP HANA
You will learn

Describe what the user will learn from your tutorial and what the outcome will be.

LsubatinLsubatinJanuary 5, 2021
Created by
Lsubatin
October 10, 2017
Contributors
Lsubatin

Prerequisites

  • This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud.
  • Proficiency: Beginner
  • Step 1

    Go into the database explorer using the button in the middle of the left side bar:

    DB explorer

    You will be asked if you want to add a Database. Click on Yes

    Add DB

    Choose your container. You will know because it will have your username (XSA_DEV) and the name of our project (in this case, TECHED).

    Add DB
  • Step 2

    Once your database container appears, click on the Tables. You will see your entity converted into a run time object.

    Explore DB

    Right-click on the table and choose Open Data:

    Explore DB

    You will see the data from the CSV file is now loaded:

    Data is now loaded
  • Step 3

    Click on the SQL button on the top of the data preview

    Check the SQL statement

    Copy the full SELECT statement into the validation below

    Copy the SQL statement

    And click on Validate

  • Step 4

    Open a SQL console and leave it open. You will use it in the next step:

    Leave a SQL console open

    Use the code symbol to go back to the development view:

    Go back to the development perspective
Back to top