Saturday 30 September 2017

ABAP Dictionary

ABAP Dictionary is a tool used to manage your database in ABAP. The transaction 'SE11' is used to open ABAP Dictionary.

SQL is mainly categorized into two parts.
         a. DDL: Data Definition Language.
         b. DML: Data Manipulation Language
        
DML is used to query the database tables, insert, update and delete records from table (SELECT, UPDATE, DELETE, INSERT etc.,).

DDL is used work on schema level like creating table, altering table, deleting entire table, creating indexes, creating views (CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX etc.,).

By using ABAP dictionary, we can manage DDL part of the SQL. ABAP dictionary provides nice graphical user interface to manage our databases.

How to open ABAP Dictionary?
By using the transaction ‘SE11’ or by navigating the folder tree ‘Tools -> ABAP Workbench -> Development -> ABAP Dictionary’.

Once you click on ‘ABAP Dictionary’, it opens below window.



Previous                                                 Next                                                 Home

No comments:

Post a Comment