Skip to Content
0
Former Member
Dec 17, 2008 at 06:39 AM

Insert into table irrespective of sorting order of a field

77 Views

Hi All,

I am not able to insert data in the data base table(YY...) as it is in the internal table.

I do have data in following order in the internal table :

I am simply using statement insert (database table) from (wa) in the loop...endloop.

001 0002 2008 0000494219 001 0000494219 254.02 W4136 Keller & Kalmbach Widex

001 0002 2008 0000198630 001 0000494219 100.10 W4136 Keller & Kalmbach Widex

001 0002 2008 0000198418 001 0000494219 39.57 W4136 Keller & Kalmbach Widex

001 0002 2008 0000198419 001 0000494219 89.93 W4136 Keller & Kalmbach Widex

but when data is inserted in the table it appears as below:

Means system is sorting the data in ascending order based on 4th column which is document number.

001 0002 2008 0000198418 001 0000494219 39.57 W4136 Keller & Kalmbach Widex

001 0002 2008 0000198419 001 0000494219 89.93 W4136 Keller & Kalmbach Widex 001 0002 2008 0000198630 001 0000494219 100.10 W4136 Keller & Kalmbach Widex 001 0002 2008 0000494219 001 0000494219 254.02 W4136 Keller & Kalmbach Widex

How can I keep the sequence of data as it is in the internal table when I insert them into data base table.

Thanks,

Mark