Entity container: It contains all the entity sets. Entity set: It represents a table. It is based on the entity type. Entity type: All the fields(properties) and the primary keys are mentioned. Property: It represents the fields along with data type. Entity: It describes a line of record in the data table. Association: It connects […]
How to construct an OData service 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 »
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 ‘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 »
Using the MODIFY statement, we can modify the existing records in a Database table. If the records does not exist in a Database table, then it can insert records in to Database table. This can be achieved in the following two ways. Through Structure. Through Internal table. Structure It is used to modify a single
How to use MODIFY to modify or insert records in Database table in SAP ABAP Read More »
In addition to the primary database, other databases can be accessed using secondary database connections. Using Open-SQL: The keyword ‚CONNECTION’ and the database connection name is specified in the query. The connections are maintained in the Transaction ‘DBA COCKPIT’. Syntax: SELECT ….. FROM db_table CONNECTION connection_name INTO …. Example: The Secondary Database name is secondary_db
How to create Secondary Database connections in SAP ABAP Read More »
It is used to provide a list of values as a Drop down List. There are three important steps involved in setting the cell as a drop down list. Filling the internal table lvc_t_dral. Setting the fields drdn_hndl, drdn_alias of field catalog. Call the method set_drop_down_table of the ALV object. Filling the internal table lvc_t_dral.
How to set the cell of the ALV List as a Dropdown list in SAP ABAP? Read More »
The new ALV Display provides different events based on the class CL_SALV_EVENTS_TABLE. It is much lesser compared to the old ALV Display. The Events can be found in the ‘Events’ tab of the class. Let us discuss about the following important Events of the class CL_SALV_EVENTS_TABLE. Events Description DOUBLE_CLICK This event will be triggered, when
How to use events of class CL_SALV_EVENTS_TABLE in SAP ABAP ALV Display Read More »
Name of the class: ZTC_CHECK_CLS. Name of the method: METHOD_ONE. DATA lr_check_cls TYPE REF TO object. CREATE OBJECT lr_check_cls TYPE (‘ZTC_CHECK_CLS’). CALL METHOD (‘ZTC_CHECK_CLS’)->(‘METHOD_ONE’). If the class ‘ZTC_CHECK_CLS’ is not available in your repository. it will throw a runtime error as the object is created only during the runtime.
How to create an object dynamically in SAP ABAP Read More »
The Group by is used to group a set of records from the internal table. It is similar to the old programming Technik AT ……. ENDAT. If you are new to SAP ABAP, please skip this part as it is an Advanced Technik. Please remember the following points for the Group by definition. There is
How to use LOOP AT GROUP BY statement in SAP ABAP Read More »