Working with Internal Tables

追加数据

APPEND

• APPEND statement always adds the record at the end of the table and is used with standard tables.

You need to use caution when using an APPEND statement with sorted tables; the system may produce a runtime error if the new row does not match the sort sequence of the table or if the table is defined with a unique key and the new row creates a duplicate entry

• Recommend always using the INSERT statement with sorted tables.

• Can't use APPEND statements with hashed tables, because they only support INSERT statements.

To add a record to an internal table, first fill the work area with the required data and then append it to the table using the APPEND statement.

TYPES : BEGIN OF ty_sflight.
        CARRID TYPE S_CARR_ID.
        CONNID TYPE S_C0NN_ID, 
        FLDATE TYPE S_DATE, 
END OF ty_sf1ight.

DATA : 
        1t_sflight TYPE STANDARD TABLE OF ty_sflight, 
        wa_sflight TYPE ty_sflight.

wa_sflight-carrid - *AA’. 
wa_sflight-connid = '0004’. 
wa_sflight-fldate = "20140101••APPEND wa_sflight TO it_sf1ight. "Adds the first row to the table wa_sflight-carrid = 'AB'. 
wa_sflight-connid = '0005'. 
wa_sflight-fldate = '20140102’.

APPEND wa_sflight TO it_sf1ight. "Adds second row to the table

INSERT

• INSERT statement behaves like an APPEND statement for standard tables in that it adds a record at the end of the table if no explicit index is speci­ fied

• With sorted tables, the INSERT statement automatically selects the posi­tion based on the sort sequence of the table.

When an index is supplied with the INSERT statement, the record is added explicitly in that row. If the index supplied is greater than the line of the table, no record is inserted and the system field sy-subrc is set to 4.

wa_sflight-carrid = 'AC'. 
wa_sflight-connid = '0006'. 
wa_sflight-fldate = '20140103'.
INSERT wa_sflight INTO TABLE it_sflight.

wa_sflight-carrid = 'AD'.
wa_sflight-connid = ’0007’. 
wa_sflight-fldate = ’20140104'.
INSERT wa_sf1ight INTO it.sflight INDEX 1