20 - ALV - Sorting

[@TienHoang-122]

Hello sir, i have an issue that: " The current application has intentionally triggered a termination with
a short dump." .How can i fix that, sir

[@sapabapbyrahulmehta]

Based upon my perception, you passed the column name in small letters while preparing the fieldcatalog and while writing the sorting logic. Please pass in capital letters at both the places. If it does not resolve the issue, you can send your code on [e-mail]

[@dreamer9857]

helo sir, if we want to filter two fields, how could we do.

[@sapabapbyrahulmehta]

You can pass another column and append it to same internal table.

[@dreamer9857]

@@sapabapbyrahulmehta hi sir, i tried like this, first sort cond.. working fine, but not second one.
ls_sort-fieldname = 'VBELN'.
ls_sort-up = 'X'.
Append ls_sort to lt_sort.
Clear ls_sort.
ls_sort-fieldname = 'MATNR'.
ls_sort-up = 'X'.
Append ls_sort to lt_sort.

[@sapabapbyrahulmehta]

@@dreamer9857 It will work fine. When you will apply sorting on multiple columns, It will not sort on all the columns in ascending or descending. It will be sorting and sub sorting. I have 2 columns - VBELN MATNR having values - 1 Z 1 A 2 Z 2 E , If we apply Sorting on both the columns in ascending order. Then the result is - 1 A 1 Z 2 E 2 Z It is doing the sub sorting on MATNR based upon VBELN. It is not applying sorting on both the columns.

[@dreamer9857]

@@sapabapbyrahulmehta thank for ur confirmation sir.

[@sreeabap]

hi rahul, after grid display(output) , when i click on sum(button) it is going for dump. (message type X) , i have passed the do-sum to the filed catalogue also. {I am trying sum for the DMBTR field from BSEG table}. how to resolve this error

[@sapabapbyrahulmehta]

Hello Sree - Based upon my perception, you have not cleared the work area. So what is happening, DO_SUM = 'X' is replicating to other columns as well.
Please clear the work area, after every append statement of fieldcatalog.

[@sreeabap]

@@sapabapbyrahulmehta I have cleared the workarea.

[@sreeabap]

@@sapabapbyrahulmehta sample manually created field catalogue
v_pos = v_pos + 1.
l_fcat-col_pos = v_pos.
l_fcat-fieldname = 'DMBTR'.
l_fcat-tabname = 'LT_FINAL'.
l_fcat-seltext_l = 'Amount'.
l_fcat-do_sum = 'X'.
* l_fcat-datatype = 'CURR'. "commented
l_fcat-outputlen = 30.
APPEND l_fcat TO t_fcat.
CLEAR l_fcat.
fyi..

[@sapabapbyrahulmehta]

@@sreeabap Great.

[@chandustrikes2017]

can we use custom function to display the data?

[@sapabapbyrahulmehta]

Hello Chandu - Once you proceed in the same playlist, you will find the topics of creating custom functions using PF-STATUS.

[@chandustrikes2017]

@@sapabapbyrahulmehta ok sirr
and i got runtime error which is assert condition was violated.
how to resolve that error sir.

[@sapabapbyrahulmehta]

@@chandustrikes2017 It means, you are passing the column name in small or wrong column name and while preparing the field catalog it is in capital or vice-versa. At both the places, pass the field name in capital.

[@chandustrikes2017]

@@sapabapbyrahulmehta thank you very much sirr.
You said absolutely right sirr.

[@sapabapbyrahulmehta]

@@chandustrikes2017 👍