custon table

[Former Member]

Hi,

i have created a custom table in SE11

and now i want to populate it..when i got o SM30 and inputed a thesame value it will have an error:"An entry already exists with the same key".

Does anyone here knows how to populate the table with one field has the same value with the previous..

example i want to populate the table with:

A582 * A 1:00:00 2:00:00

A582 * L 3:00:00 4:00:00

A582 * N 6:00:00 9:00:00

i hope someone could help me...

thank you...

regards,

mae

[Former Member]

Hi,

if A582 value column is key field in the table, you can not have mor than one entry with that value. that is uniqueness.

if you want to have same values then you should not consider that field as key field.

Reward points if it helps,

Satish

[Former Member]

hi,

but when i activate the table it will asked for a key field can you suggest what keyfield to be used?

thank you

regards,

mae

[naimesh_patel]

The simple way is to include another field in the primary key

Here you can make your 3rd characther N, C as part of the primary key.

Regards,

Naimesh Patel

[Former Member]

have you used MANDT field in your table? just try with only MANDT field as the key field.

Regards,

Satish

[Former Member]

Hi

Make the first 2 fields as KEY fields then you can enter values as you have entered

like

A582 * A

A582 * L

A582 * N

A582 * K

....

Again you can't enter the bothe fields having similar value

like

A582 * A

A582 * A

This is called the Primary key effect (uniqueness to be maintained)

Regards

Anji