topic Re: Sort Itab in Application Development and Automation Discussions

Sort Itab

Former Member — Mon, 08 Oct 2007 11:38:15 GMT

Hello friends,

Can anyone tell me how will this statement behave

Sort itab by field1

where my itab has 2 fields 1 is customer no and 2 is description.

Now , here the sort is sorting the itab by fields 1 as well by description.

can anyone please tell me is this behavior normal for sap i:e after field one system will sort itab by field 2 also without mentioning in the SORT statement.

Please help.

Thanks n Regards,

AShwini

Re: Sort Itab

Former Member — Mon, 08 Oct 2007 12:02:26 GMT

Hi Ashwini,

System will not automaticaly sort itab by field2 unless mentioned. It does happen if the entries in database tables are already in sorted form.

Else you need to mention both fields in sorting.

sort itab by field1 field2.

Regards,

Arati.

Re: Sort Itab

Former Member — Mon, 08 Oct 2007 12:19:07 GMT

you can do that by

sort itab by field1 feild2

simply sort itab

Reward if usefull

Re: Sort Itab

Former Member — Mon, 08 Oct 2007 12:19:42 GMT

Hi Ashwini,

Sort itab by field1

will sort the itab by field 1 i.e.,customer number.The other fields related to field1(i.e.description) also gets sorted automatically according to the key field (customer number).

thanks,

Shanmugapriya

Re: Sort Itab

rodrigo_paisante3 — Mon, 08 Oct 2007 19:50:41 GMT

Hi,

when you use sort itab field1 field2 ... fieldn (you can use optional ascending or descending)

you specific the priority sort to your table.

Example:

Field1 Field2 Field3

A........104........2

A........105........2

A........106........6

B........107........7

B........108........7

when you just use sort itab by field, the table is sorted by this field.

Try to see the abap help about sort, there are useful samples here.

Regards.

Re: Sort Itab

Former Member — Tue, 09 Oct 2007 05:37:10 GMT

Hi,

supposse the IT has the following records,

cust-id cust-desc

104 doctor

101 doctor

105 student

102 merchant.

SORT tbl_cust by cust-id.

then tbl_cust contain records like

cust-id cust-desc

101 doctor

102 merchant.

104 doctor

105 student

In above sort statement sorth the records a/c to cust-id in acending order.

SORT tbl_cust by cust-desc.

then tbl_cust contain records like

cust-id cust-desc

104 doctor

101 doctor

102 merchant.

105 student

In above sort statement the records a/c to cust-description in alphabetical order.

SORT tbl_cust by cust-desc cust-id.

then tbl_cust contain records like

cust-id cust-desc

101 doctor

104 doctor

102 merchant.

105 student

In above sort statement, the records first sort a/c to cust-desc

104 doctor

101 doctor

then it sort agian cust-id in acending order.then finally it sort into

101 doctor

104 doctor

hope you can understand with above examples.

<b>Reward with points if helpful.</b>

Regards,

Vijay

Re: Sort Itab

Former Member — Wed, 10 Oct 2007 11:32:05 GMT

It may be the case that your DB table (for where you are working on the internal table) is a sorted table and the sorted field is by default Field 2.

Hence, in your case, its better to write the sort statement as :

<b>sort itab by field 1 field 2.</b>

Reward if helpful,

Thanks and Regards,

Anindita