topic Re: Facing Problem in SORT statement in Application Development and Automation Discussions

Facing Problem in SORT statement

Former Member — Fri, 25 May 2007 11:18:38 GMT

Hi All,

I have Five fields in my internal table.

Say FIELD1, FIELD2, FIELD3, FIELD4, FIELD5.

I wan to display FIELD1 and FIELD3 in ascending order. Fields are Cobination of Text and Numerals.

Both should be displayed in ascending order. Is it possible? How can I achieve it.

Points Assured.

Regards,

Suresh

Re: Facing Problem in SORT statement

Former Member — Fri, 25 May 2007 11:21:15 GMT

hi,

use this

<b>sort itab ascending by field1 field3.</b>

With REgards,

S.BArani

Message was edited by:

S BHARANIDARAN

Re: Facing Problem in SORT statement

Former Member — Fri, 25 May 2007 11:21:27 GMT

Use SORT ITAB BY field1 field3

but this sort is done based on the first character (first letter) of the field.

Reward points if useful

Regards

Anji

Re: Facing Problem in SORT statement

Former Member — Fri, 25 May 2007 11:21:29 GMT

u have to use

SORT ITAB BY FIELD1 FIELD3.

Re: Facing Problem in SORT statement

Former Member — Fri, 25 May 2007 11:22:11 GMT

try using Sort itab ascending by field1 field2

hope this works

Regards

Shiva

Re: Facing Problem in SORT statement

alex_m — Fri, 25 May 2007 11:22:55 GMT

Its not possible in single SORT statement, you may need to copy into another table and do some manipulation to get the final one.

Re: Facing Problem in SORT statement

Former Member — Fri, 25 May 2007 11:27:37 GMT

hi,

U CAN WRITE THE LIKE THIS.

DATA: BEGIN OF ITAB occurs 0,

MATNR TYPE MARA-MATNR,

ERSDA TYPE MARA-ERSDA,

ERNAM TYPE MARA-ERNAM,

VPSTA TYPE MARA-VPSTA,

PSTAT TYPE MARA-PSTAT,

END OF ITAB.

select * from mara into CORRESPONDING FIELDS OF TABLE itab.

sort itab DESCENDING by VPSTA MATNR.

loop at itab.

write: / itab.

endloop.

RGDS,

bharat.

Re: Facing Problem in SORT statement

Former Member — Fri, 25 May 2007 11:34:34 GMT

Hi,

I wan to display Field1 and Field3 in ascending order. Based on the Field1, Field3 may get suffled.

How to avoid this.?

Regards,

Suresh