Table updation

[Former Member]

Hi,

i created one customised table ( ex: zXXXX) when i am inserting data into this table using Insert command inserting only once, if i insert again the same record it is not inserting . I think duplicate records r not updating. i want to insert all the recoreds . Any one idea pls let me know...

Regards ,

sksk.

[GauthamV]

hi,

you can insert duplicate records into your table only if you change the value of primary key fields.

you cannot have duplicate records for primary key conditions.

[Former Member]

Hi,

Primary cannnot have duplicate entries....so you cannot enter the same record more than once.

If the same record more than once and you need to add one more field for Sequence Number and this should be the part of the Primary Key.

This will help you....

[Former Member]

Hi,

this happens due to your primary key of that table.....check your primary keys.....if the 2nd time entry is similar to the 1st time entry in primary key then no duplicate entry will occur in the table..

Arunima

[Former Member]

Hi,

If u want to insert the duplicate records in your tabel you need to remove the primary keys.

Because primary keys are meant when u want only single record for the specifications.

try removing primary key. It will help u out

Thanks & Regards

[Former Member]

Hi SK,

instead of using the key word INSERT use MODIFY.

MODIFY will insert if the primary key value is not available and if available it modifies the existing record.

for further help please go through the key word documentataion.

hope this will serve your purpose.

if you still want the duplicate primary as we find in VBAP table

use a line item type field as key field and increase the counter value every time you insert a value into it.

or dummy key field which gets the value from a NUMBER RANGE OBJECT.

Thanks and regards

Ramchander Rao.K

Edited by: ramchander krishnamraju on Nov 20, 2008 7:31 AM

[Former Member]

closed