special-sales-orders-table

Create a new table for Special Sales Orders

1. Navigate in the Space Management to the Database Access section.

2. Select your created database user and click on Open Database Explorer
   
   

3. Enter the user credentials and check the parameter _Save Password (saved in SAP HANA secure store)
   
   

4. Right click on the database catalog and click on Open SQL Console from the context menu.
   
   

5. Enter the following SQL DDL statement to create a database table for the special sales.

   create column table T_SPECIAL_SALES_ORDERS(
   	SALESORDERID bigint, 
   	SALESORDERITEM bigint,
   	CREATEDAT date, 
   	PARTNERID bigint,
   	PRODUCTID varchar(5000),
   	QUANTITY bigint,
   	NETAMOUNT decimal(38,19),
   	GROSSAMOUNT decimal(38,19),
   	TAXAMOUNT decimal(38,19),
   	CURRENCY varchar(5000),
   	PRIMARY KEY (SALESORDERID, SALESORDERITEM)
   )
   

6. Run the SQL statement.
   
   

7. Open a new SQL console from the context menue
   
   

8. Enter the following SQL DML statement to insert data into the sales table

   insert into T_SPECIAL_SALES_ORDERS values(	
   	700000001, '10','2021-01-01', '100000014', 'HB-1173', '5', '3333', '3777', '444', 'USD'
   )
   

9. Run the SQL statement
   
   

10. Open a new SQL console from the context menue
    
    

11. Enter the following SQL SELECT statement

    select * from T_SPECIAL_SALES_ORDERS
    

12. Run the SQL statement to view the content of the table