insert with accepting duplicates

[Former Member]

insert ztable from wa_ztable

how to add code to accept duplicates as well ?

[Former Member]

INSERT ztable FROM TABLE itab ACCEPTING DUPLICATE KEYS. All this does is that if there is an entry with a duplicate key, it will simply drop the record and the SY-DBCNT will give you the number of inserted records.

[Former Member]

Do not maintain any primary keys in your ztable.

INSERT command will insert a row if it does not find one with matching primary keys. If it finds it will not insert the row.

Thanks,

Santosh