topic Re: regarding Sorting in Application Development and Automation Discussions

regarding Sorting

Former Member — Thu, 13 Jul 2006 06:44:29 GMT

hi friends,

I want to sort a internal table by two or more fields.Mentioning those fields dynamically.

Thanks all,

Harikrishna Adipuram.

Re: regarding Sorting

Former Member — Thu, 13 Jul 2006 06:48:08 GMT

Hi ,

<b>SORT</b>
Addition 1 
... BY f1 f2 ... fn 

Effect 
Uses the sort key defined by the sub-fields f1, f2, ..., fn of the table itab instead of the table key. The fields can be of any type; even number fields and tables are allowed. 

You can also specify the sort fields dynamically in the form (name). If name is blank at runtime, the sort field is ignored. If itab is a table with a header line, you can also use a field symbol pointing to the header line of itab as a dynamic sort criterion. A field symbol that is not assigned is ignored. If a field symbol is assigned, but does not point to the header line of the internal table, a runtime error occurs.

regards

Prabhu

Re: regarding Sorting

naimesh_patel — Thu, 13 Jul 2006 06:51:51 GMT

Hello,

Use this code.

Regards,

Naimesh

REPORT ZTEST_NP.

data: begin of itab occurs 0,

f1,

f2,

f3,

end of itab.

DATA: BEGIN OF IT_SORT OCCURS 0,

FLD(10),

END OF IT_SORT.

ITAB-F1 = 6.

ITAB-F2 = 5.

ITAB-F3 = 4.

APPEND ITAB.

ITAB-F1 = 1.

ITAB-F2 = 2.

ITAB-F3 = 3.

APPEND ITAB.

IT_SORT = 'F1'.

APPEND IT_SORT.

IT_SORT = 'F2'.

APPEND IT_SORT.

IT_SORT = 'F3'.

APPEND IT_SORT.

sort itab by (IT_SORT).

LOOP AT ITAB.

WRITE: / ITAB.

ENDLOOP.

Re: regarding Sorting

dani_mn — Thu, 13 Jul 2006 06:53:09 GMT

Hi,

Use field symbols to do it.

FIELD-SYMBOLS: <FS> type any.

FIELD-SYMBOLS: <FS1> type any.

ASSIGN field_name to <FS>.

ASSIGN field_name1 to <FS1>.

SORT ITAB by <FS> <FS1>.

Regards,

Wasim Ahmed

Re: regarding Sorting

nishanthbhandar — Thu, 13 Jul 2006 06:57:18 GMT

You have to make use of field symbols to sort the internal table dynamically.

declare the field symbols first of type ANY.

field-symbols : <f1> type any,

<f2> type any.

Assign the fields to the field symbols.

assign dynamic-field1 to <f1>.

assign dynamic-field2 to <f2>.

Then sort dynamically using the below syntax.

sort ITAB by (<f1>) (<f2>).

Message was edited by: Nishanth Bhandar

Re: regarding Sorting

Former Member — Thu, 13 Jul 2006 06:57:33 GMT

Hi,

Consider this code.


REPORT zztest_arun_2.

PARAMETERS p_matnr TYPE mara-matnr.
DATA : it_mara TYPE STANDARD TABLE OF mara WITH HEADER LINE.

DATA : field1 TYPE string,
       field2 TYPE string.

START-OF-SELECTION.

  SELECT * FROM mara INTO TABLE it_mara UP TO 200 ROWS WHERE matnr = p_matnr.

  field1 = 'MATNR'.
  field2 = 'MTART'.
  SORT it_mara BY (field1) (field2).

Regards,

Arun Sambargi.

Re: regarding Sorting

Former Member — Thu, 13 Jul 2006 07:02:50 GMT

hi naimesh,

if i mention like this ,it will sort by standard key.

I already try this one

Thanks,

Harikrishna

Re: regarding Sorting

Former Member — Thu, 13 Jul 2006 07:09:28 GMT

i want use one dynamic varible to sort the internal table by two or more fields.

Thanks all,

Harirkishna adipuram