topic Re: APPEND LINES - with sorted table? in Application Development and Automation Discussions

APPEND LINES - with sorted table?

Former Member — Wed, 17 Dec 2008 18:08:50 GMT

Hi there,

how can I use the APPEND LINES statment with sorted tables? Is this possible???

Kind regards

Max

Re: APPEND LINES - with sorted table?

Former Member — Wed, 17 Dec 2008 18:13:20 GMT

You should use the INSERT command.

Re: APPEND LINES - with sorted table?

Former Member — Wed, 17 Dec 2008 18:15:16 GMT

Below is F1 help Of Append Lines:

"Appending square numbers to a "sorted table" with elementary row type. 

DATA: int  TYPE i, 
      itab LIKE SORTED TABLE OF int 
           WITH UNIQUE KEY table_line. 

DO 10 TIMES. 
  int = sy-index ** 2. 
  APPEND int TO itab. 
ENDDO.

Re: APPEND LINES - with sorted table?

JozsefSzikszai — Wed, 17 Dec 2008 20:35:55 GMT

Amit: the above example from you works, but the only reason for that is that the rows are appended according to the sort sequence (APPEND adds the line to the internal table one after the other). Once the sort sequence is not kept, the program will dump. An example to understand better:

Here the dump is acc. to the sort sequence, so it works:

APPEND 1.
APPEND 2.
APPEND 3.

Here the sort sequence is not kept:

APPEND 1.
APPEND 3.
APPEND 2. "this will dump at this line

As Jerry suggested already INSERT has to be used in case of SORTED (and HASHED) tables.

Re: APPEND LINES - with sorted table?

Former Member — Wed, 17 Dec 2008 21:06:51 GMT

Hi Eric,

Agreed.

But If this is the Case you would get Dump With Insert Also.

APPEND 1.
APPEND 3.
APPEND 2. "Dump ITAB_ILLEGAL_SORT_ORDER

Re: APPEND LINES - with sorted table?

Former Member — Wed, 17 Dec 2008 21:15:43 GMT

It works ok for me.

REPORT zztemp.

TYPES:  BEGIN OF intline,
  int  TYPE i.
TYPES: END OF intline.

DATA: intline  TYPE intline,
      itab LIKE SORTED TABLE OF intline WITH UNIQUE KEY int.

intline-int = 3.
INSERT intline INTO TABLE itab.

intline-int = 5.
INSERT intline INTO TABLE itab.

intline-int = 1.
INSERT intline INTO TABLE itab.

intline-int = 2.
INSERT intline INTO TABLE itab.


LOOP AT itab INTO intline.
  WRITE:/ intline-int.
ENDLOOP.

Re: APPEND LINES - with sorted table?

JozsefSzikszai — Wed, 17 Dec 2008 21:36:51 GMT


> But If this is the Case you would get Dump With Insert Also.
> APPEND 1.
> APPEND 3.
> APPEND 2. "Dump ITAB_ILLEGAL_SORT_ORDER

with simply INSERT ... INTO yes, but the correct syntax is INSERT ... INTO TABLE (I did not mention in my first reply, sorry)

Re: APPEND LINES - with sorted table?

Former Member — Wed, 17 Dec 2008 21:48:05 GMT

Yes

Re: APPEND LINES - with sorted table?

Former Member — Fri, 06 Aug 2010 09:01:53 GMT

I got the same issue.

With this code I got ITAB_ILLEGAL_SORT_ORDER

LOOP AT from_table INTO l_from.
    READ TABLE to_table INTO l_to
                           WITH KEY thekey = ...
                          BINARY SEARCH.
    IF sy-subrc EQ 0.
      MOVE sy-tabix TO l_index.
      ADD l_from-volume TO l_to-volume.
      MODIFY to_table INDEX l_index
                         FROM l_to
                         TRANSPORTING volume.
    ELSE.
      MOVE l_from TO l_to.
      MOVE ... TO l_to-....
      APPEND l_to TO to_table.
    ENDIF.
  ENDLOOP. " from_table

I replaced APPEND with INSERT and I got TABLE_ILLEGAL_STATEMENT

LOOP AT from_table INTO l_from.
    READ TABLE to_table INTO l_to
                           WITH KEY thekey = ...
                          BINARY SEARCH.
    IF sy-subrc EQ 0.
      MOVE sy-tabix TO l_index.
      ADD l_from-volume TO l_to-volume.
      MODIFY to_table INDEX l_index
                         FROM l_to
                         TRANSPORTING volume.
    ELSE.
      MOVE l_from TO l_to.
      MOVE ... TO l_to-....
      INSERT l_to INTO to_table.
    ENDIF.
  ENDLOOP. " from_table

wtf ?

Help !

Re: APPEND LINES - with sorted table?

navdeep_thakur12 — Tue, 31 Mar 2015 13:35:48 GMT

This message was moderated.