Ztt_db_table2 is the Database table name
PARAMETER | OPEN-SQL-INSERT | INTERNAL TABLE-INSERT |
Structure | i) INSERT ztt_db_table2 FROM ls_contact ii) INSERT INTO ztt_db_table2 VALUES ls_contact | i) APPEND ls_contact TO lt_contact ii) INSERT ls_contact INTO TABLE lt_contact iii) INSERT ls_contact INTO lt_contact INDEX 1 |
Internal table | i) INSERT INTO ztt_db_table2 FROM TABLE lt_internal_table ii) INSERT INTO ztt_db_table2 FROM TABLE lt_internal_table ACCEPTING DUPLICATE KEYS | i) INSERT LINES OF lt_contact2 INTO TABLE lt_contact ii) INSERT LINES OF lt_contact2 INTO lt_contact INDEX 1. iii) INSERT LINES OF lt_contact2 FROM 1 TO 3 INTO TABLE lt_contact iv) INSERT LINES OF lt_contact2 USING KEY primary_key INTO TABLE lt_contact v) APPEND LINES OF lt_contact2 TO lt_contact. vi) APPEND LINES OF lt_contact2 FROM 1 TO 2 TO lt_contact vii) DATA lt_contact2 TYPE SORTED TABLE OF ztt_db_table2 WITH UNIQUE KEY primary_key COMPONENTS contact_id. APPEND LINES OF lt_contact2 USING KEY primary_key TO lt_contact |
VALUE | lt_internal_table = VALUE #( ( contact_id = 101 contact_name = ‘Raj’ ) ( contact_id = 102 contact_name = ‘Mike’ ) ). |