Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table creating error

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

1.

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

Tags:
Former Member
Former Member replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question