Day 7 — SAP HANA Tables

What is a Table in SAP HANA? Explain its types and uses.

A Table is a database object used to store business data permanently. It consists of rows and columns and is the most important object in any database. 1. What is a Table? a. Stores business data permanently. b. Contains rows and columns. c. Used to store master and transaction data. d. Supports Insert, Update, Delete, and Select operations. e. Data can be accessed using SQL queries. 2. Types of Tables a. Row Store Table • Stores data row by row. • Best for transactional data. • Faster for Insert, Update, and Delete operations. b. Column Store Table • Stores data column by column. • Best for reporting and analytics. • Faster for reading large amounts of data. 3. Common Business Tables a. CUSTOMER – Stores customer details. b. MATERIAL – Stores material information. c. EMPLOYEE – Stores employee records. d. SALES_ORDER – Stores sales order details. e. PURCHASE_ORDER – Stores purchase order details. 4. Advantages of Tables a. Stores data permanently. b. Easy to retrieve and manage data. c. Supports millions of records. d. Improves data consistency. e. Supports business transactions.

• A customer places an order through an online shopping application. • Customer information is stored in the CUSTOMER table. • Order details are stored in the SALES_ORDER table. • Product details are stored in the MATERIAL table. • Payment information is stored in the PAYMENT table.

1. What is a Table in SAP HANA? 2. What are the types of Tables? 3. What is the difference between Row Store and Column Store Tables? 4. What is the purpose of a Table? 5. Give three examples of business tables.