User exits instructs system to access a program during the system processing. User exits allows to add additional functionality to the application program without modifying it.
Author Archives: Admin
A report is a data presentation made with the specific intention of conveying information in an organized structure.
Many systems enable to design and generate the reports in easily understandable format.
ABAP application supports report programming to create reports.
Dialog programming related to developing the objects.
These objects can’t able to execute independently, linked/added somewhere in the main program and executed according to sequence in main program.
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).
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.
MODIFY statement used to modify the data in the table. MODIFY statement used as a combination of INSERT and UPDATE statement.
DELETE statement used to delete rows from the table.
DELETE statement allows to delete one or more rows from the database table db-table.
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.