topic Sorting in Application Development and Automation Discussions

Sorting

Former Member — Sun, 10 May 2015 20:37:40 GMT

Hi,

I have an internal table itab1

itab1:

400

200

700

for that entries i am selecting data from another db table using FOR ALL ENTRIES and i am getting data in sorted manner as below:

f1 f2

200 545

400 222

700 845

So how to get my original order back.

Re: Sorting

paul_bakker2 — Mon, 11 May 2015 02:33:45 GMT

Hi,

You'll have to sort Table2 the same way you sorted Table1.

The database table doesn't hold rows in any defined order, so you'll never know what you'll get - you have to sort the result yourself.

cheers

Paul

Re: Sorting

VijayaKrishnaG — Mon, 11 May 2015 03:05:01 GMT

Hi Krishna,

After getting data into second internal table move the data into another (third) internal table and refresh the second table. When you are moving the data into new table, loop the first table and read the second table with key as 'f1'.

LOOP AT TABLE1 INTO WA1.

READ TABLE TABLE2 INTO WA2 WITH KEY F1 = WA1-F1.

IF SY-SUBRC = 0.

APPEND WA2 TO TABLE3.

ENDIF.

ENDLOOP.

REFRESH TABLE2.

Regards,

Vijay