Hi Seshagiri
Use Sort Catalog.
Refer to the following:
STRUCTURE OF SORT CATALOG
The sort catalog contains the following fields for getting the current sort criteria of the list or setting these criteria dynamically or before the list is displayed for the first time.
FIELD NAME DESCRIPTION
SPOS Sort order if the list is sorted by multiple columns
FIELDNAME Field name in the internal output table
UP 'X' = Sorted in ascending order
DOWN 'X' = Sorted in descending order
SUBTOT 'X' = Subtotal at group level change
GROUP Once a column is sorted, it is subdivided into groups. This means there is one group for each value of the column (in the default setting, the ALV Grid Control merges cells that have the same value in the sort column). If the value in the sort colulmn changes, this is called a group level change.
You can use this field to determine the formatting of this value when the list is printed:
'* ' = Page break at group level change
'UL' = Underline at group level change
(The formatting options are fixed domain values of domain SLIS_CTRLS ).
There are two important points to tell about this topic. First one is that, there will be a short dump if any one of the fields given to be sorted is not in the content of the field catalog. Secondly, when you make ALV Grid to sort data, by default it vertically merges fields having the same content. To avoid from this for all of the columns, you can set “no_merging” field of the layout structure to ‘X’. If you want to disable merging for just some columns, set “no_merging” field of the field catalog row corresponding to that column.
TOTAL AND SUBTOTAL
This returns the current subtotals of the ALV Grid Control. Having created totals for at least one column, users can calculate at most nine subtotals. The list is sorted by the values of one or several columns (called the subtotals column). If a value is changed in the subtotals column, the subtotal is displayed (this is also referred to as control level change).
EXAMPLE CODE:
<b>FORM SORT_CATALOG USING GT_SORT TYPE SLIS_T_SORTINFO_ALV.
DATA: GS_SORT TYPE SLIS_SORTINFO_ALV.
CLEAR GS_SORT.
GS_SORT-FIELDNAME = 'FIELD1'.
GS_SORT-SPOS = 1.
GS_SORT-DOWN = 'X'.
GS_SORT-SUBTOT = 'X'.
APPEND GS_SORT TO GT_SORT.
CLEAR GS_SORT.
GS_SORT-FIELDNAME = 'FIELD2'.
GS_SORT-SPOS = 2.
GS_SORT-UP = 'X'.
*GS_SORT-SUBTOT = 'X'.
APPEND GS_SORT TO GT_SORT.
ENDFORM.</b>
Award points if found useful.
Regards
Inder
Bluesky
