topic Custom table data entry in Application Development and Automation Discussions

Custom table data entry

Former Member — Mon, 06 Oct 2008 14:37:34 GMT

Hi All,

I have a scenario...

where I have three key fields in my table: zgrp, zrole and zdate and two non key fields zdatum and zpur

Now I want to enter the following records:

zgrp - > 1

zrole-> xyz

zdate->12/12/2008

zdatum->12/11/2007

zpur->1

zgrp - > 1

zrole-> xyz

zdate->12/12/2008

zdatum->12/11/2006

zpur->2

zgrp - > 1

zrole-> xyz

zdate->12/12/2008

zdatum->12/11/2007

zpur->3

zgrp - > 2

zrole-> abc

zdate->12/12/2008

zdatum->12/11/2007

zpur->1

zgrp - > 2

zrole-> abc

zdate->12/12/2008

zdatum->12/11/2007

zpur->2

but I am not being able to insert these records, as soon as I enter the first record it gives me the follwoing error:

"An entry already exists with the same key"

Thanks,

Rajeev

Re: Custom table data entry

Former Member — Mon, 06 Oct 2008 14:41:04 GMT

How about looking in the table with SE16 to see what's already in there?

edit.

By the way: even if you manage to insert the first one, other's will go wrong. Given your examples: your primary key is not unique.

Re: Custom table data entry

Former Member — Mon, 06 Oct 2008 14:42:43 GMT

The table has just one recoed that I entered !!!!

Re: Custom table data entry

Former Member — Mon, 06 Oct 2008 14:44:45 GMT

Hello ,

The first 3 entries that you want to add to you table all have exactly the same values for the key field. That is why you are getting the error.

You will need to rethink the keys that are needed for you table. You may need to add another key field to make the entries in you table unique by those key values.

Regards

Greg Kern

Re: Custom table data entry

former_member226519 — Mon, 06 Oct 2008 14:48:38 GMT

you need one more key field to build an unique key: i.e. zcount type numc4 so you could add from 1 to 9999 records with eaqual keys.

you can not add a second record with key

zgrp - > 1

zrole-> xyz

zdate->12/12/2008