Using the ‘UPDATE’ keyword, we can modify one or more Data records in an internal table. The data records can be modified in the following different ways. Through Structure. Through Internal table. Through ‚WHERE‘ Clause. Through Structure: Single line of record can be modified using structure. Therefore define a structure with reference to the Database …
How to update Data records in a Database table in SAP ABAP Read More »
With the help of ‘INSERT’ keyword, we can insert one or more records in to an internal table. Data records can be inserted in the following two different ways: Through structure. Through Internal table. Through structure. DATA ls_contact TYPE ztt_db_table2. ls_contact – contact_id = 104. ls_contact – contact_name = ‘Bala’. ls_contact – contact_address = ‘Street …
How to insert Data records in to Database table in SAP ABAP Read More »
Using the DELETE statement, you can delete one or more records from a Database table. It can be deleted in the following three different ways. Through ‘WHERE’ clause. Through structure (work area). Through Internal table. Through ‘WHERE’ clause. The data records from the Database table are deleted based on the condition mentioned in the ‘WHERE’ …
How to delete records from a Database table in SAP ABAP Read More »
The values of a column can be grouped by using the GROUP BY statement. The GROUP BY clause must always come at the end of the ‘SELECT’ statement. It should always be after the ‘FROM’ clause and ‘WHERE’ clause. Let us consider an example, where we group all the contact based on contact address. DATA …
The selected records can be sorted using the ‘ORDER BY’ clause. The data can be sorted based on the column mentioned after the ORDER BY clause. It can be sorted in ascending / increasing order or descending / decreasing order. It can be sorted based on more than one column. The priority of the sorting …
How to use ORDER BY in SELECT statement in SAP ABAP Read More »
The ‘WHERE’ clause in SELECT query can be used to constrain the selected records from the Database table. The following operators can be used in the ‘WHERE’ clause of SELECT query. Operator Explanation EQ / = The data of operand1 must be equal to operand2. NE / < > The data of operand1 must not …
How to use WHERE condition in SELECT statement in SAP ABAP Read More »
The data from the Database table can be read using SELECT statements. These data records are stored in Dataobjects such as variables, structure and Internal table. The SELECT statement can be used in the following ways. Reading a single line of record. Reading more lines of record. Reading more lines of record inside a loop. …
HOW TO USE OPEN-SQL SELECT STATEMENTS IN SAP ABAP Read More »
Output results must be minimum. Please try to use where, having constraints in the query to reduce the data records read from the Database table. Use SELECT colum1, column2 instead of SELECT *From. The performance will be better as only the important columns are selected in the query. Use Joins instead of writing multiple select …
Five Important rules to improve the performance of Database access Read More »
Determine the structure behind the ALV List by right clicking on the ALV List Determine the Table type for the structure using the Where used option in SAP ABAP Determin the corresponding Program for the Table type using the Where used option in SAP ABAP (Ctrl+Shift+F3) Click a particular program in the results list Click …
How to find the code location to change the column heading of an ALV List Read More »
Using the MODIFY statement, we can modify more than one data record in an internal table. It is modified with the contents of the structure along with the additional conditions such as WHERE, INDEX, USING KEY. Using the ‘TRANSPORTING’ keyword, we can specify which component of the structure in the internal table must be transferred. …
Modifying the internal table contents using MODIFY statement Read More »