topic Re: accepting duplicate keys in Application Development and Automation Discussions

accepting duplicate keys

Former Member — Thu, 09 Jan 2020 16:01:25 GMT

iNSERT itab FROM wa_structure .

why it won't put me on "accepting duplicate keys" ?

how do I hang the data to the table without deleting the already present ones and accepting the duplicates?

Re: accepting duplicate keys

Sandra_Rossi — Thu, 09 Jan 2020 16:10:03 GMT

Because it's only for INSERT ... FROM TABLE ... ACCEPTING DUPLICATE KEYS, as explained in the documentation.

Hang?

Re: accepting duplicate keys

Former Member — Thu, 09 Jan 2020 16:24:06 GMT

so what instruction should I use to be able to add data to the custom database by accepting duplicate keys?

Re: accepting duplicate keys

Sandra_Rossi — Thu, 09 Jan 2020 16:29:36 GMT

Don't you think that inserting a structure and inserting an internal table of one line is the same thing?

Note that INSERT itab FROM wa_structure will return SY-SUBRC = 4 if the line already exists (considering the primary key only).

I'm not sure what you want to achieve, and if you understand exactly what means the option "ACCEPTING DUPLICATE KEYS".

What means "hang" in the context of database updates?

Re: accepting duplicate keys

Sathya_Gunasekaran — Mon, 13 Jan 2020 09:05:30 GMT

Use MODIFY. The table can't have duplicate keys!

Re: accepting duplicate keys

gayathri_jayajeevan2 — Mon, 13 Jan 2020 10:44:28 GMT

Hi,

You can not insert a duplicate key in the table.

Please go through the concept of "Primary Key" which should accept only "unique & not null" values.

you can have duplicate entries only when there is no key fields defined.

Re: accepting duplicate keys

Former Member — Mon, 13 Jan 2020 22:24:58 GMT

Change internal table and workarea definitions, to add a new field (column) to each, which will make each row unique (no duplicate keys), such as POSNR or so.