What is Structure? Structure is a group of components defined under a name. A component is a field that can be an elementary type or another structure or table. The group ofcomponents defined under structure can be of any data type that are stored one after the other in the memory in the same order […]
Author Archives: Admin
What is Table? Table is a logical structure for storing data. Table is the set of rows and columns that are logically related. Table can be defined independent of the database in ABAP dictionary. The table fields are defined with the database independent elementary data types and lengths. The physical table definition created in the […]
What is View? View is a logical representation of summarized data from one or more tables. The view structure can be defined by specifying table names and required field names from the joined tables. View is not stored physically. View used to combine the data from one or more tables. The table fields that are […]
Internal tables used for processing the data dynamically during the program execution. So, the data reading from the internal table can be done during the program execution.
The internal table reading can be done in two ways –
In some scenarios, backuping the internal table data is necessary to maintain data integrity.
To backup the table data, create new table with the same structure of existing source table.
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.