topic Re: Sorting in Application Development and Automation Discussions

Sorting

Former Member — Mon, 30 Jul 2007 10:37:30 GMT

Hi,

During sorting the internal table i was facing the problem...

See internal table having two fields namely num and name..

sort itab descending by num-->It works...

But

sort itab descending by ____.Here i need to display the value in run time..How it is possible.

Re: Sorting

seshatalpasai_madala — Mon, 30 Jul 2007 10:40:59 GMT

Hi,

If the fields are not many try using CASE ENDCASE.

CASE FLD.

WHEN FLD1.

SORT ITAB BY FLD1.

WHEN FLD2.

SORT ITAB BY FLD2.

ENDCASE.

Regards,

Sesh

Re: Sorting

Former Member — Mon, 30 Jul 2007 10:42:15 GMT

You can't SORT an internal table during runtime, because you need to mention the SORT field in the SORT statement in the coding part.

Regards,

Pavan

Re: Sorting

RaymondGiuseppi — Mon, 30 Jul 2007 10:42:50 GMT

Use Syntax

SORT itab by (fieldname).

Regards

Re: Sorting

former_member491305 — Mon, 30 Jul 2007 10:43:52 GMT

Hi ,

Pass it within the brackets.

Data var1(35).

If condition1 = true.

var1 = 'FIELD1'.

else.

var1 = 'FIELD2'.

Endif.

Sort itab by ( var1 ).

Re: Sorting

Former Member — Mon, 30 Jul 2007 10:44:39 GMT

Instead you can develop a code of this format....

parameters: p_string(10) type c default 'CARRID'.

DATA: BEGIN OF fs_spfli,

carrid TYPE spfli-carrid,

connid TYPE spfli-connid,

countryfr TYPE spfli-countryfr,

END OF fs_spfli.

DATA: t_spfli LIKE STANDARD TABLE OF fs_spfli.

START-OF-SELECTION.

SELECT * FROM spfli INTO CORRESPONDING FIELDS OF TABLE t_spfli.

IF P_STRING EQ 'CARRID'.

sort t_spfli by CARRID.

ELSEIF P_STRING EQ 'CONNID'.

SORT T_SPFLI BY CONNID.

ENDIF.

loop at t_spfli into fs_spfli.

write:

fs_spfli-carrid.

write fs_spfli-connid.

endloop.

Regards,

Pavan

Re: Sorting

Former Member — Mon, 30 Jul 2007 10:46:08 GMT

use token method:

data: fname type string.

during runtime :

fname = 'NUM' or

fname = 'NAME'.

SORT itab DESCENDING BY (fname).

Reward if useful

Regards

Pradeep

Re: Sorting

Former Member — Mon, 30 Jul 2007 10:51:55 GMT

You can use following method :

SORT <itab> BY (otab).

where otab is an internal table of type abap_sortorder_tab.

declare it as:

DATA: otab TYPE abap_sortorder_tab,

oline TYPE abap_sortorder.

in ur code:

oline-name = 'NUM'.

oline-descending = 'X'. " Descending

append oline to otab.

clear oline.

oline-name = 'NAME'.

oline-descending = ' '. " AScending

append oline to otab.

Reward if helpful

Regards

Prax