topic Re: SORT ITAB BY <VARIABLE_NAME> in Application Development and Automation Discussions

SORT ITAB BY

naveenvishal — Sat, 16 May 2009 08:59:09 GMT

hi,

i want to sort the int table with variable parameters, like VKBUR, BUDAT, VKORG, MATNR, etc.

for that ive created a char variable of 5 length (say CRIT) and assigned value based on selection criteria by the user.

Then, im using SORT ITAB BY CRIT. Its not getting sorted properly.

Any suggestions,

Regards,

Naveen

Re: SORT ITAB BY

Former Member — Sat, 16 May 2009 09:29:48 GMT

please send the code with internal table structure, so ican send th correct code what to write..

Regards,

Prabhudas

Re: SORT ITAB BY

Former Member — Sat, 16 May 2009 10:01:16 GMT

Probably your assignement to variable could be wrong CRIT.

Check in debugger if the selected field is getting passed correctly.

Regards

Shital

Re: SORT ITAB BY

Former Member — Sat, 16 May 2009 10:43:42 GMT

Hi,

Char data type sort frist charectar wsie.

if u sort itab value -- 20

29.

After Sort Output:- 1

I sugest define CRIT - NUMC type.

Re: SORT ITAB BY

MarcinPciak — Sat, 16 May 2009 11:24:06 GMT

Field is provided dynamically so it must be enclosed in paranthesis.


SORT ITAB BY (CRIT). "depending on CRIT content i.e 'VKBUR' , 'BUDAT' it will sort using this field

Regards

Marcin

Re: SORT ITAB BY

Former Member — Mon, 18 May 2009 10:24:23 GMT

You can easily achieve it by using filed symbols.

Assign the field (upon which you require sorting) to field symbol<Fs> and then sort the table with (<Fs>)reference.

Sample code is given below for your help.

DATA: BEGIN OF x1 OCCURS 0,
        t1 TYPE string,
        t2 TYPE string,
        t3 TYPE string,
       END OF x1.

FIELD-SYMBOLS: <fs> TYPE ANY.

x1-t1 = 'B'.
x1-t2 = 'D'.
x1-t3 = '9'.
APPEND x1.

x1-t1 = 'C'.
x1-t2 = 'X'.
x1-t3 = '4'.
APPEND x1.

x1-t1 = 'F'.
x1-t2 = 'Y'.
x1-t3 = '6'.
APPEND x1.

LOOP AT x1.
  WRITE: / x1-t1, '    ', x1-t2, '    ', x1-t3.
ENDLOOP.

SKIP 2.

* Sort by field T1
ASSIGN 't1' TO <fs>.
SORT x1 BY (<fs>).

LOOP AT x1.
  WRITE: / x1-t1, '    ', x1-t2, '    ', x1-t3.
ENDLOOP.

skip 2.

* Sort by field T3
ASSIGN 't3' TO <fs>.
SORT x1 BY (<fs>).

LOOP AT x1.
  WRITE: / x1-t1, '    ', x1-t2, '    ', x1-t3.
ENDLOOP.