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 »
The Data records present in the internal table can be deleted in following ways. Key or work area (structure) WHERE conditions. Index From Index TO Index Clean, Refresh, free DATA lt_internal_table TYPE TABLE OF ztt_db_table2. DATA ls_structure TYPE ztt_db_table2. SELECT *FROM ztt_db_Table2 INTO TABLE lt_internal_table. ls_structure – contact_id = 102. ls_structure – contact_name
How to Delete records from the internal table 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 »
The sorting and grouping of data in ALV Table can be programmatically achieved. The method add_sort( ) of the class CL_SALV_SORTS can be used to sort or group the data. This sorting object is created from the get_sorts( ) method of the ALV Object. DATA lr_salv_sorts TYPE REF TO cl_salv_sorts. Lr_salv_sorts = lr_salv_table->get_sorts( ). Lr_salv_sorts->add_sort(
How to do Sorting and grouping in ALV Table through CL_SALV_SORTS Read More »
The column of the ALV Display can be aggregated using the add_aggregation( ) method of the class CL_SALV_AGGREGATION. DATA lr_salv_aggregation TYPE REF TO cl_salv_aggregation. Lr_salv_aggregation = lr_salv_table=>get_aggregations( ). Lr_salv_aggregation->set_aggregation_before_items( abap_true ). Lr_salv_aggregation->add_aggregation( columnname = ‘AGE’ aggregation = if_salv_c_aggregation=>average ). The following aggregation types are available. If_salv_c_aggregation=>minimum. If_salv_c_aggregation=>maximum. If_salv_c_aggregation=>average. If_salv_c_aggregation=>total. If_salv_c_aggregation=>none.
How to do Aggregation using the class CL_SALV_AGGREGATION Read More »
In order to fill icons in ALV Table, we must add an additional field of type ICON_D. The type ICON_D is of datatype CHAR with length 4. This is later filled with the icon code. Step1: Define the icon field TYPE-POOLS: icon. TYPES: BEGIN OF ty_contact. INCLUDE STRUCTURE ztt_db_table2. TYPES: icon_field
How to fill icons in SAP ALV Display of type CL_SALV_TABLE Read More »
Step 1: Desired cells of the SAP ALV Display can be colored using the structure lvc_s_scol. The color codes must be set to each line of record. Therefore the structure of the ALV Display must be extended with the additional field with an internal table of type lvc_t_scol. TYPES: BEGIN OF ty_contact. INCLUDE STRUCTURE
How to color the cells of SAP ALV Display of type CL_SALV_COLUMNS_TABLE Read More »
The method set_color of the class CL_SALV_COLUMN_TABLE can be used to color the column of SAP ALV Display. The color codes are much similar to old ALV Display of type CL_GUI_ALV_GRID DATA lr_all_columns TYPE REF TO cl_salv_columns_table. DATA lr_single_column TYPE REF TO cl_salv_column_table. Lr_all_columns = lr_salv_table->get_columns( ). Lr_single_column ?= lr_all_columns->get_column(‘CONTACT_NAME’). DATA ls_color_column TYPE lvc_s_scol. Ls_color_column-col
How to color the complete column of the SAP ALV Display of type CL_SALV_COLUMN_TABLE Read More »