topic Re: inserting duplicate value into custom table in Application Development and Automation Discussions

inserting duplicate value into custom table

Former Member — Fri, 03 Sep 2010 06:59:43 GMT

I have created a custom table containing 5 fields .there are two primary key fields MANDT,MIRN(custom field).

When I am trying to insert duplicate value into custom table using " INSERT YMCR296 from TABLE git_table ACCEPTING DUPLICATE KEYS." It is not updating the cuplicate values.Please Help

Re: inserting duplicate value into custom table

Former Member — Fri, 03 Sep 2010 07:05:23 GMT

Hi,

Accepting duplicate keys is not to update the table with the duplicate entries. It simply avoids the dump for DUPREC.

If you want to add a record with the same mandt and MIRN fields, Add another field also as a primary key.

Hope it helps.

Sujay

Re: inserting duplicate value into custom table

Former Member — Fri, 03 Sep 2010 07:10:13 GMT

Hi,

See SAP Documentation on INSERT

If, for one or more of the rows to be inserted, a row with the same primary key 
or the same unique secondary key already exists and the ACCEPTING DUPLICATE KEYS 
addition is specified, the rows are not inserted and sy-subrc is set to 4. If, in this case, 
the addition ACCEPTING DUPLICATE KEYS is not specified, no rows are inserted. 
Prior to Release 6.10, this raises an exception that cannot be handled; as of Release 6.10, 
this raises the exception that can be handled CX_SY_OPEN_SQL_DB.

Regards

Vinod

Re: inserting duplicate value into custom table

Former Member — Fri, 03 Sep 2010 11:05:14 GMT

Hi,

Instead of insert use modify statement to update the database records.

Whenever you update any custom table always use modify statement instead of insert to update duplicate values.

Hope it hepls.

Karishma.

Edited by: Karishma Kadivar on Sep 3, 2010 1:05 PM

Edited by: Karishma Kadivar on Sep 3, 2010 1:14 PM

Re: inserting duplicate value into custom table

kesavadas_thekkillath — Fri, 03 Sep 2010 21:53:03 GMT

If you are inserting duplicate values then what is the need of primary key in your table?

Re: inserting duplicate value into custom table

syed_ibrahim5 — Sat, 04 Sep 2010 05:45:23 GMT

hi,

try to use some sort of an dummy deletion indicator as the primary key by concatenating date and time which would be unique always and that would enable the insertion of duplicate entries...

with regards,

syed

Re: inserting duplicate value into custom table

Former Member — Sat, 04 Sep 2010 06:30:56 GMT

Hi,

Add 1 more column as key say CNTR type NUMC. Increment this whenevr you add any duplicate entry. You can check duplicate entry by checking Sy-SUBRC = 4 when you use INSERT statement. For example :


INSERT ZTABLE FROM WA_ZTABLE.

IF SY-SUBRC <> 0.

SELECT MAX( CNTR ) FROM ZTABLE INTO WA_ZTABLE-CNTR
              WHERE MIRN = WA_ZTABLE-MIRN.

WA_ZTABLE-CNTR = WA_ZTABLE-CNTR + 1.

INSERT ZTABLE FROM WA_ZTABLE.

ENDIF.

Thanks & Regards,

Rock.