Skip to main content


Showing posts from March, 2022

Schema in HANA

I wont believe you if you say that you are an administrator or HANA developer in fact even if you are even closely related to database and you have not heard of SCHEMAS. If you don't know about schemas in database refer this  Database Schema  , but Let me quote the part I want to drop your focus to from the mentioned page. " A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations among them are associated. It formulates all the constraints that are to be applied on the data. " Physical Database Schema − This schema pertains to the actual storage of data and its form of storage like files, indices, etc. It defines how the data will be stored in a secondary storage. Logical Database Schema − This schema defines all the logical constraints that need to be applied on the data stored. It defines tables, views, and integrity constraints. Let's dive in back in HANA and Sch

Data Definition Language (ABAP Dictionary ) VS Actual Data

Let's understand more about DML , DDL and Actual Data. DML is Data Manipulation Language which consists of update commands such as SELECT, INSERT, UPDATE , DELETE etc and ABAP Programs handle these commands. DDL is Data Definition Language consists of commands such as CREATE TABLE, CREATE INDEX, DROP TABLE, ALTER TABLE, etc. and ABAP Dictionary handles the DDL part of SQL. It can be viewed as metadata. Diving deep in ABAP Dictionary :- 1. Data Elements : Elementary type of definition the data type , length and possibly decimal places. 2. Structures : Components that can have any type. 3. Table Types describe the structure of an internal table. The Dictionary supports the definition of user-defined types and these types are used in ABAP programs. They also define the structure of database objects such as tables, views and indexes. These objects are created automatically in the underlying database in their Dictionary definitions when the objects are activated. The Dictionary also pro