Data retrieval from Database (SQL) in SAP ABAP

Data is retrieved from data base with the help of a special language called Structured Query Language (SQL).  SQL is designed to use with rdbms. SQL used widely in any system, also in SAP. You can find few commands of SQL in ABAP also, the very basic or mother commands in ABAP.

 

SQL is divided into 3 components:

Data Manipulation Language (DML):  For retrieving and updating information in the database.

Data Definition Language (DDL):  For defining database objects and specifying the structure of the data in the database.  In SAP, these functions are handled primarily by the ABAP Dictionary and the Database Utility.

Data Control Language (DCL):  For controlling access to DML and DDL functions.

 

In ABAP, the first category (DML) queries were used. They are operations: 

Select (retrieve)

Insert

Update

Delete

 

Find out detailed analysis on them in coming posts.