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

sort internal table

Former Member — Tue, 17 Oct 2006 12:17:52 GMT

i have a requirement.

I am looking to sort an internal table with wbs element. I want to sort the internal table such a way that all the entries that have wbs element appears at top in ascending order and then those that dont have wbs element.

if i try sort ascending then blank entries come first.

help please..

thanks in advance

Hitesh

Re: sort internal table

Former Member — Tue, 17 Oct 2006 12:19:31 GMT

Hello,

Use SORT ITAB <b>DESCENDING</b> by POSID.

If useful reward.

vasanth

Re: sort internal table

Former Member — Tue, 17 Oct 2006 12:24:09 GMT

U can try to do something like this:

ITAB-WBS = 'ZZZZZZZZZ'.

MODIFY ITAB TRANSPORTING WBS WHERE WBS = SPACE.

SORT ITAB BY WBS.

CLEAR ITAB-WBS.

MODIFY ITAB TRANSPORTING WBS WHERE WBS = 'ZZZZZZZZZ'.

So u insert a value where the WBS is blank, sort the table and then clear WBS where u have inserted the false value.

Max

Re: sort internal table

Former Member — Tue, 17 Oct 2006 12:38:14 GMT

It is not possible to achieve that by the SORT statement on WBS Element.

The only solution is that you include a field in the internal table say KEY and populate the same with '1' if WBS Element is not space and '9' if it is space.

After that sort the internal table using key and wbs element.

SORT itab by key wbselement.

Result of the same would be as you want.

Regards

Anurag