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.
No comments:
Post a Comment