Client as a primary key

[Former Member]

Hi Experts,

I need to create a custom table in SE11. I dont want primary key in my table. I know that, we cant create a table without primary key.

So that I used client(MANDT) as a primary key and I have totally five fields in my table. Now when i creating entry to my table it will not accept duplicate entries. But in some standard table's i saw a duplicate entries.

Example table SWFDEVTYP has the client as the primary key and its accepting Duplicate entries.

How its possible??

Thanks,

Helps wil be appreciated.

[Former Member]

Hi Experts,

I need to create a custom table in SE11. I dont want primary key in my table. I know that, we cant create a table without primary key.

So that I used client(MANDT) as a primary key and I have totally five fields in my table. Now when i creating entry to my table it will not accept duplicate entries. But in some standard table's i saw a duplicate entries.

Example table SWFDEVTYP has the client as the primary key and its accepting Duplicate entries.

How its possible??

Thanks,

Helps wil be appreciated.

[Former Member]

hi ,

In this table SWFDEVTYP there are 4 key fields OBJCATEG, OBJTYPE, EVENT, RECTYPE . You 'll not get any duplicate records in this table with cobination of these 4 fields . therefore you to define some fields as key field in z table according to your requirement .

Jitendra

[Former Member]

Having single Mandt field as key field, system will keep overrighting the entries or return error message for duplicate entries.

I would suggest, define all fields as key fields, which solve your problem as you are not sure abt the key fields and also system accrpt all table entries as you update