Add data to the fields in tables Hana management Studio

[former_member599242]

Hello Experts! I am New to hana management studio ..

I have created a table in Hana management studio , I would like to add multiple records to the fields and save them besides insert query is there any other way !

[former_member456023 · Accepted solution]

Hi,

Option 1

Like other database, you can insert records in SAP HANA using Insert statement. Insert statement can be written in SQL editor in HANA.

To open SQL editor, you can select HANA system and click on SQL sign at top.

Below example - SQL statements can be used to insert the data:

Schema name - TEST

Table name - PROD_DESC

INSERT INTO TEST.PROD_DESC VALUES (11,’E’,’Table’);
INSERT INTO TEST.PROD_DESC VALUES (11,’D’,’Chair’);
INSERT INTO TEST.PROD_DESC VALUES (14,’E’,’32 LED’);
INSERT INTO TEST.PROD_DESC VALUES (14,’D’,’32 inch LCD’);
INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25,’E’,’CompTable’);
INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25,’E’,’Mixer’);<br>

Option 2

Uploading data into tables from Flat files

https://blogs.sap.com/2013/12/11/sap-hana-uploading-data-into-table-from-flat-files/

Thanks
Ashraf

[former_member599242 · Accepted solution]

hello mohammad thank u for your replay!

Is it not possible like how we add in se11 one by one record manually without any commands!

[former_member456023 · Accepted solution]

Another thread with similar question.

https://archive.sap.com/discussions/thread/3505214