topic Primary Key in Application Development and Automation Discussions

Primary Key

Former Member — Tue, 16 Oct 2007 12:07:45 GMT

hi all,

i have created ZTABLE with MANDT key and Maintenance View. i have entered one record through Maintenance View. while trying to save second record it is giving error 'An entry already exists with the same key'. my ztable is

Field Key Initial Type

MANDT X X MANDT

FIELD1

FIELD2

FIELD3

No Primary Key except MANDT. but it is giving error while saving 2nd record.

pl. give me solution any one.

Thanks.

Re: Primary Key

Former Member — Tue, 16 Oct 2007 12:11:29 GMT

hi,

try giving one more field as the key field.

are u entering MANDT in the maintenace view while entering records?

Re: Primary Key

Former Member — Tue, 16 Oct 2007 12:12:15 GMT

Hi,

I think you should have another primary key in your ztable.

As mandt will always be same for every entry.

Regards,

Pritha.

Re: Primary Key

Former Member — Tue, 16 Oct 2007 12:14:58 GMT

hi,

you have declared mandt as primary key thats why when you are trying to save second record mandt is same and as it is primary it cant be duplicate, so u have to declare one more field as primary key,

if you dont have any field for primary key use serial no.1,2,3 etc.

now u have to create table again and do tale maintenance also, cos u cant make changes in fields once maintenance generation is done.

Re: Primary Key

Former Member — Wed, 17 Oct 2007 04:47:40 GMT

THE PROBLEM WITH UR TABLE IS

YOU HAD DECLARED MANDT AS THE PRIMARY KEY AND THERE IS NO OTHER KEY IN UR TABLE

WHEN YOU ENTER THE DATA IN YOUR TABLE IT WILL ACCEPT UR 1ST RECORD DATA

WHEN YOUR TRYING TO PUT ANOTHER RECORD THEN AT THAT TIME THE MANDT VALUE IS SAME THAT WHY IT IS SHOWING THE ERROR MESSAGE

SO TRY TO PUT ONE MORE FIELD AS THE PRIMARY KEY SO THAT YOUR PROBLEM WILL SOLVE VERY EASILY

MANDT VALUE ALLWAYS DEPENDS ON THE CLIENT

IF YOU ENTER IN THE 800 CLIENT THEN FOR THAT TABLE THE 800 VALUE IS SAME FOR ALL RECORDS

REWARD IF USEFUL

Re: Primary Key

Former Member — Wed, 17 Oct 2007 05:11:51 GMT

Thank you sonali. you solved my problem.