topic Re: Table creating error in Application Development and Automation Discussions

Table creating error

Former Member — Sat, 04 Oct 2008 21:25:42 GMT

Hi All.

I am working on an issue....there is one ztable named as zemp with the following fields:

MANDT MANDT CLNT 3 0 Client

ZNUM ZNUM CHAR 6 0 Employee number

ZDATE ZDATE DATS 8 0

ZROLE ZROLE CHAR 1 0 emp role

ZCLASS ZCLASS CHAR 2 0 emp class

where mandt is the only key field in it and now I am trying to put the data in it, when I put the first entry using sm30

empnum 1

date 08/08/2008

zrole 3

empclass 12

and now when I am trying to enter the second record:

empnum 1

date 08/08/2008

zrole 2

empclass 12

it's giving me the following error:

An entry already exists with the same key

can you please tell me what exactly the problem is..

Thanks,

Rajeev

Re: Table creating error

Former Member — Sat, 04 Oct 2008 21:37:05 GMT

Hi Rajiv,

The problem is with the KEY field MANDT, as you have mentioned "mandt" as the only key field it is throwing out this error. This is because when you are working on a system, suppose say your clinet number (MANDT) is "800", you are trying to enter second record with the same client, moreover you have made this "mandt" as the key field. This is the cause for your errot.

I think your requirement is to enter different employee data into this table. Now, make mandt & emp no (both of them ) as the key fields and try entering the data.

This should not create any problem.

Re: Table creating error

Former Member — Sat, 04 Oct 2008 22:09:55 GMT

Hi,

Make Empname also key field and enter your data.

mandt 200

empnum 1

date 08/08/2008

zrole 3

empclass 12 like this...you dont get any error.

Thanks,

Sree.

Re: Table creating error

Former Member — Sat, 04 Oct 2008 22:42:37 GMT

Thanks for the reply srinivas. This time I amde enum also as a key field and tries to enter the following records:

empnum 1234

date 08/08/2008

zrole 2

empclass 12

and now when I tried to enter the seod record as :

empnum 1234

date 08/08/2008

zrole 3

empclass 12

I am facing the same problem !!!

Re: Table creating error

Former Member — Sun, 05 Oct 2008 01:26:19 GMT

Give the value like this,

empnum 1234

date 08/08/2008

zrole 2

empclass 12

empnum 1235

date 08/08/2008

zrole 3

empclass 12

Regards,

Midhun Abraham

Edited by: Midhun Abraham on Oct 5, 2008 3:27 AM

Re: Table creating error

Former Member — Sun, 05 Oct 2008 02:12:02 GMT

Hi Midhun.

My problem is in my scenario a employee can have multiple roles .....

Re: Table creating error

Former Member — Sun, 05 Oct 2008 02:18:04 GMT

hey ,

tell me the exact field which are the key fields now.

Re: Table creating error

Former Member — Sun, 05 Oct 2008 02:21:36 GMT

mandt and empnum are the two key fields !!!

Re: Table creating error

Former Member — Sun, 05 Oct 2008 02:26:50 GMT

hey ,when you make the empnum as the key field it will not allow similar enteries ,for example in the key field there should be change so that the values you give.Here you are entering 1234 for the both of the enteries that will not be accepted because repeatation occurs.So check that will you be able to make some other fields as the key field.