topic Re: sort internal table for two fields in Application Development and Automation Discussions

sort internal table for two fields

mark_fryu — Fri, 05 Feb 2021 09:36:26 GMT

I need to sort the it_mseg internal table in ascending order for the bwart and mkpf_budat fields.

I am trying to use this statement:

ORDER it_mseg FOR budat_mkpf bwart.

but it doesn't work because it only sorts for one field I also tried like this:

order it_mseg by bwart.

order stable it_mseg of budat_mkpf.

how do i do it? thanks

Re: sort internal table for two fields

MateuszAdamus — Fri, 05 Feb 2021 09:38:21 GMT

Hello mark.fryu

If you want to sort an internal table then what you're looking for is SORT keyword.

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abapsort_itab.htm

Kind regards,
Mateusz

Re: sort internal table for two fields

mark_fryu — Fri, 05 Feb 2021 09:45:57 GMT

I tried "sort" but it didn't work, can you give me an instruction with the sort to try?

Re: sort internal table for two fields

Patrick_vN — Fri, 05 Feb 2021 09:50:23 GMT

Normally the code should look like this:

SORT it_mseg BY field_a ASCENDING field_b DESCENDING.

Are you sure that you can modify the contents of your table [it_mseg]? If it is an import parameter, it might be protected against changes.

Re: sort internal table for two fields

joltdx — Fri, 05 Feb 2021 09:53:02 GMT

Please show us your exact code.

Do you mean to use to SORT statement after there already is data in it_mseg? Or are you trying to use the ORDER BY to get the data sorted already from a SELECT query?

Re: sort internal table for two fields

mark_fryu — Fri, 05 Feb 2021 10:01:31 GMT

yes I can modify the internal table, it's my report, I also tried this instruction but it sorts only for the first field, in this example of yours it sorts only for the field field_a

Re: sort internal table for two fields

joltdx — Fri, 05 Feb 2021 10:32:27 GMT

Patricks example should work. Please update your question with your exact code and we will be able to help. Also please show us your data before and after the sort, where we can see the data not sorted properly.

Re: sort internal table for two fields

Sandra_Rossi — Fri, 05 Feb 2021 10:34:57 GMT

mark.fryu Did you open and read the link? It's full of instructions and examples.

Re: sort internal table for two fields

Sandra_Rossi — Fri, 05 Feb 2021 10:36:23 GMT

mark.fryu You're wrong, so please give details of values in your internal table + ABAP code so that we can explain what your error is.

Re: sort internal table for two fields

matt — Fri, 05 Feb 2021 13:53:20 GMT

I'm guessing this question is the output of automated translation!