Open SQL is a subset of the standard SQL92 language. Open SQL contains only Data Manipulation Language (DML) statements (SELECT, INSERT, and DELETE). Open SQL does not contain any Data Definition Language (DDL) statements (CREATE TABLE or CREATE INDEX).
Category Archives: SAP Tutorial
SELECT statement used to read the data from the database tables.
When coming to programming, it is always advisable to retrive only one record for a smoother processing.
If the SELECT statement retrieving more than one row, the first row from the result set gets retrieved to the work area.
If all the rows retrieved using SELECT statement are required to process in the ABAP program, then it advisable to use CURSOR statement.
The Open SQL INSERT statement used for inserting data into a database table. INSERT statement can insert single or multiple rows in a single execution.
UPDATE statement used to update the data that is already existed in the table. UPDATE statement can update one or more rows at a time.
DELETE statement is used to delete one or more records from an internal table.
The internal table records can be deleted either by specifying a table key or condition or by finding duplicate entries.
MODIFY statement used to modify the data in the table. MODIFY statement used as a combination of INSERT and UPDATE statement.
What is Modularization? In some scenarios, the application programs are too big and it’s not easy to maintain or find out issues or debug the issues in the program. The application program in ABAP can be divided into smaller units using the technique called Modularization. Modularization is a technique used to divide the application program […]
DELETE statement used to delete rows from the table.
DELETE statement allows to delete one or more rows from the database table db-table.
If same statements block is repeated more than once in various places of the program, it causes code redundancy.
One of the repeated statements block can place in the macro and the macro call replaces the statements block where ever it repeatedly existed.
Native SQL allows to code database-specific SQL statements in an ABAP program. The database-specific statement should code in between the EXEC SQL and ENDEXEC statement.