Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

custon table

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

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

0 Kudos

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

0 Kudos

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

0 Kudos

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

Regards,

Satish

Former Member
0 Kudos

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