2007 Mar 22 9:08 PM
insert ztable from wa_ztablehow to add code to accept duplicates as well ?
2007 Mar 22 9:12 PM
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.
insert ztable from wa_ztablehow to add code to accept duplicates as well ?
2007 Mar 22 9:12 PM
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.
2007 Mar 22 9:13 PM
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
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |