Table operations in SCP HANA Service

Hello All

I have explored more on SCP Hana Service and came up with this blog post.

My previous demo on SAP HANA Service: https://blogs.sap.com/2019/10/04/sap-ui5-app-on-sap-hana-cloud-trial-service/

Here I mentioned about Table Create, Insert, Select, Update and Delete operations using HANA SQL Scripting.

Make sure SAP HANA Service is activated in Neo Environment of SCP.

Open the service and check for roles and on below highlights.

Development Workbench:

Navigate to Editor and create the project structure based on our requirement.

I have created below Schema and a table for my demo.

Schema:

Table Create:

.xsaccess & .xsapp files

Make sure all the file changes are saved. Now browse to Catalog in Workbench

We should be able to see our created schema and table in Catalog.

Now start querying around this table:

INSERT:

INSERT INTO “ZSCHEMA_NEWQ”.”SQLHANA.hanaproject.epmmodel.tableschemacreations::ZBOOKSFACTORY.booksTable” VALUES(1, ‘SAP Fiori Certification Guide’, ‘SAP Fiori’,2110.23);

Similarly inserted few more records and the output for insert statement is as follows:

In order to view the inserted records, We need to query Select.

SELECT:

SELECT * FROM “ZSCHEMA_NEWQ”.”SQLHANA.hanaproject.epmmodel.tableschemacreations::ZBOOKSFACTORY.booksTable”;

Operations and output on Select query:

COUNT: No of records in our table

COUNT: Based on Specific value

SUM :

SUM based on PERCENTAGE:

MIN & MAX:

GROUP BY:

ORDER BY: ascending & descending

TOP: 

UPDATE:

DELETE:

Will be going with more queries in future blog.

Please comment if any.

Thank you!!

BR//Dhanasupriya Sidagam