topic sorting a table in Application Development and Automation Discussions

sorting a table

Former Member — Wed, 07 May 2008 07:48:27 GMT

Hi ,

i want to sort a table with reference of two fields.

one field with ascending and and one field with decending ,

so how can i write sort statement for this ,

can any one pls help

Re: sorting a table

Former Member — Wed, 07 May 2008 07:53:49 GMT

Hai ,

Sort it_tab by value1 descending by value2.

this may work.

Thanks

Swetha

Re: sorting a table

Former Member — Wed, 07 May 2008 07:55:15 GMT

Hi use this,

Sort It_table by f1 ascending

f2 descending.

Reward points if useful.

Re: sorting a table

Former Member — Wed, 07 May 2008 07:57:20 GMT

hi,

sort itab by field1 descending field2 .

ascending is default. u have to specify descending explicitly.

regards,

madhumitha

Re: sorting a table

Former Member — Wed, 07 May 2008 08:05:51 GMT

Hi Chaaya,

Refer to the following code:

SORT int_aeoi ascending BY datuv andat DESCENDING.

Hope this helps.

Reward if helpful.

Regards,

Sipra

Re: sorting a table

Former Member — Wed, 07 May 2008 08:06:39 GMT

Hi Chaaya,

Refer below Code:

DATA:
  wa_vbap TYPE vbap,
  t_vbap  TYPE TABLE OF vbap.

SELECT *
  FROM vbap
  INTO TABLE t_vbap.

SORT t_vbap BY vbeln ASCENDING posnr DESCENDING.

LOOP AT t_vbap INTO wa_vbap.

    WRITE:
      / wa_vbap-vbeln, '     ',
    wa_vbap-posnr, '     ',
    wa_vbap-matnr.
ENDLOOP.

Regards,

Sunil.