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

how to sort internal table

Former Member — Wed, 14 Jun 2006 23:48:06 GMT

How to sort internal by binary search...please don't suggest SORT TABLE or HASHED table to use...

Re: how to sort internal table

RichHeilman — Thu, 15 Jun 2006 00:02:05 GMT

You can use a SORTED Table.

data: itab type sorted table of mara 
            with unique key MATNR.

Regards,

Rich Heilman

Re: how to sort internal table

Former Member — Thu, 15 Jun 2006 00:04:02 GMT

can u suggest any other method????

Re: how to sort internal table

RichHeilman — Thu, 15 Jun 2006 00:06:34 GMT

Well, the other way would be to use the SORT statement.

Regards,

Rich Heilman

Re: how to sort internal table

Former Member — Thu, 15 Jun 2006 00:07:55 GMT

canu write code for it...

Re: how to sort internal table

Former Member — Thu, 15 Jun 2006 00:08:10 GMT

hi,

Use SORT Statement....

i.e,

sort itab.

Here is the code

TYPES: BEGIN OF PERSON_TYPE,
NAME(10) TYPE C,
AGE TYPE I,
COUNTRY(3) TYPE C,
END OF PERSON_TYPE.

DATA: PERSON TYPE STANDARD TABLE OF PERSON_TYPE WITH
NON-UNIQUE DEFAULT KEY INITIAL SIZE 5,
WA_PERSON TYPE PERSON_TYPE.

WA_PERSON-NAME = 'Muller'. WA_PERSON-AGE = 22.
WA_PERSON-COUNTRY = 'USA'.
APPEND WA_PERSON TO PERSON.
WA_PERSON-NAME = 'Moller'. WA_PERSON-AGE = 25.
WA_PERSON-COUNTRY = 'FRG'.
APPEND WA_PERSON TO PERSON.
WA_PERSON-NAME = 'Möller'. WA_PERSON-AGE = 22.
WA_PERSON-COUNTRY = 'USA'.
APPEND WA_PERSON TO PERSON.
WA_PERSON-NAME = 'Miller'. WA_PERSON-AGE = 23.
WA_PERSON-COUNTRY = 'USA'.
APPEND WA_PERSON TO PERSON.

SORT PERSON.

SORT PERSON BY NAME AS TEXT

SORT PERSON DESCENDING BY COUNTRY AGE NAME.

SORT PERSON DESCENDING BY AGE ASCENDING NAME AS TEXT.

Reward if it helps,

Regards,

Santosh

Re: how to sort internal table

Former Member — Thu, 15 Jun 2006 00:10:30 GMT

data : t_marc type standard table of marc with header line.

sort t_marc by matnr werks.

Re: how to sort internal table

RichHeilman — Thu, 15 Jun 2006 00:16:56 GMT

There are a lot of different ways to write a SORT statement. It really depends on how you want to sort.

Example.

sort ivbep by vbeln posnr ascending
              edatu descending.

Regards,

Rich Heilman