topic Re: Insert statement Acepting duplicate Keys ??? in Application Development and Automation Discussions

Insert statement Acepting duplicate Keys ???

NR_Ranasingh — Fri, 20 Aug 2010 10:29:33 GMT

Hi ,

i am updating a ztable ZMM_PRIMO_DUPERR from itab I_DPAIR .

in my ztable there is a field PROCESSING_DATE which is the only primary key .

and in my itab i have 2 records on the same processing date . i mean for a particular key, Duplicate record exists in I_DPAIR .

i want to update both records into the ztable.so i write the below code,but its not working, Its only inserting the first record ?

how this below syntax works ??

INSERT ZMM_PRIMO_DUPERR FROM TABLE I_DPAIR ACCEPTING DUPLICATE KEYS

please share your thoughts ..

Re: Insert statement Acepting duplicate Keys ???

Former Member — Fri, 20 Aug 2010 10:37:41 GMT

Hi,

As you said its not inserting 2 similar records.

It would never insert 2 records with same primary key.

Otherwise what's the use of primary key.

Re: Insert statement Acepting duplicate Keys ???

NR_Ranasingh — Fri, 20 Aug 2010 10:42:30 GMT

yes you are true ...

But wht is the use of ACCEPTING DUPLIACTE KEYS ??

Re: Insert statement Acepting duplicate Keys ???

Sandeep_Panghal — Fri, 20 Aug 2010 10:42:43 GMT

you have to redesign you DB table.

Re: Insert statement Acepting duplicate Keys ???

Former Member — Fri, 20 Aug 2010 10:51:50 GMT

Hi Sagar,

Using "Accepting duplicate keys" will only set the sy-subrc = 4 when you try to insert duplicate records into the DB table from an internal table so that we can handle this exception.

Regards,

Re: Insert statement Acepting duplicate Keys ???

NR_Ranasingh — Fri, 20 Aug 2010 10:52:50 GMT

HI Nagraj,

so you mean , the syntax is only to avoid sortdump , but it wont add any dupliacte records .?

Re: Insert statement Acepting duplicate Keys ???

Former Member — Fri, 20 Aug 2010 10:55:33 GMT

Yes thats correct. In this case all the unique records will be inserted and the duplicates will be rejected.

Re: Insert statement Acepting duplicate Keys ???

Former Member — Fri, 20 Aug 2010 11:07:34 GMT

Hi,

ACCEPTING DUBLICATE ENTRIES is to avoid the dump.It wont add duplicate entries in the database table.If you don't use the keyword ACCEPTING DUBLICATE ENTRIES, you will get a dump.

Re: Insert statement Acepting duplicate Keys ???

RaymondGiuseppi — Fri, 20 Aug 2010 11:07:39 GMT

In case of doubt, read the Abap documentation first [FROM TABLE itab [ACCEPTING DUPLICATE KEYS]|http://help.sap.com/abapdocu_70/en/ABAPINSERT_SOURCE.htm#&ABAP_ALTERNATIVE_2@2@] or via F1, it is cleary written.

(SQL basic : A Primary Key Constraint is an extension of [Unique Key|http://en.wikipedia.org/wiki/Primary_key] Constraint with the addition of a Not Null Constraint)

Regards,

Raymond

Re: Insert statement Acepting duplicate Keys ???

kesavadas_thekkillath — Fri, 20 Aug 2010 11:10:31 GMT

Then what is the exact purpose of primary key ?

you have to create one more primary key which together uniquley identifies a record.

Re: Insert statement Acepting duplicate Keys ???

Former Member — Fri, 20 Aug 2010 11:29:54 GMT

Hi,

Just CHeck this Documentation from SAP :

... ACCEPTING DUPLICATE KEYS

Effect

If a line cannot be inserted, the system does not

terminate with a runtime error but only sets the return value SY-SUBRC to 4. All other lines are inserted after the command is executed

i.e. so as to just avoid the dump we can use this syntax.

But we cannot insert duplicate records in a table.

Any ways if you have to insert duplicate you have to change your primary key's and table design.

Re: Insert statement Acepting duplicate Keys ???

NR_Ranasingh — Mon, 23 Aug 2010 04:43:43 GMT

HI ,

Yes now i am clear.. Thanks to all for their valuable tips ..

I have to redesign the DB table.

Thanks to all