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

sort internal table

Former Member — Mon, 24 Mar 2008 06:35:16 GMT

Hi all,

I have a requirement in which i have to sort an internal table based on field value.

suppose i have 3 fields order number , line item ,order type .

there are 5 records

1 10 zabc

20 s1

30 d2

40 f5

50 zabc

I want to sort the records on the basis of zabc.Please let me know how can i do this.

Thanks in advance

Lalit

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:37:13 GMT

Hi,

Use the statement

SORT ITAB BY ORDERTYPE.

It will sort according to the ordertype.

Thanks and Best Regards,

Ruthra

Re: sort internal table

former_member210123 — Mon, 24 Mar 2008 06:38:11 GMT

SORT <itab> BY (otab).Otab is the field name.

This should satisfy your requirement.

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:38:53 GMT

Hi,

If u want to sort the internal order type based on irder number

SORt itab by orderno,order_type.

or esle if u want to sort the entire internal table by order type

Sort itab by ordertype.

regards

Sheeba

Re: sort internal table

vinod_vemuru2 — Mon, 24 Mar 2008 06:39:41 GMT

Hi Lalit,

Do like this.

SORT itab BY ordertype(Here give the actual field name of the internal table.

Thanks,

Vinod.

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:40:52 GMT

Hi,

SORT ITAB BY FIELDNAME.

Example :

SORT ITAB BY ORDERTYPE.

SORT ITAB BY ORDERTYPE ASCENDING.

If its useful reward points.

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:40:55 GMT

hI,

Data:begin of it_ord occurs o,

ord_typ,

ord_no,

ord_ln,

end of it_ord.

sort it_ord by ord_typ ord_no.

Ord_typ should be the first field of ur itab.

Reward if helpful.

Regards,

Kumar

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:40:57 GMT

I dont want to sort on order type..i want to sort on the value of order type.if i sort it by order type it will come as

zabc

but i want all the records with value zabc at the top.

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:43:43 GMT

Hi,

sort it_ord by ord_typ ord_no descending.

it will work.

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:44:03 GMT

Sort itab by order type Descending.

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:46:37 GMT

Hi,

You can try as below.

SORT lt_tab BY otype DESCENDING.

Regards,

Farheen

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:47:59 GMT

Hi,

You can use Sort like,

Sort It_vbrk by Vbeln erdat DESCENDING.

Regards,

Mehul Shah.

Re: sort internal table

Former Member — Mon, 24 Mar 2008 06:56:37 GMT

if i will sort it by descending it will come as

zabc

zbbc

zcbc

but i want records as

zdbc

zabc

sort on a particular field value....

could you please help...

Re: sort internal table

Former Member — Mon, 24 Mar 2008 07:04:37 GMT

Hi friend,

Use

Sort itab by order type Ascending.