topic Re: custon table in Application Development and Automation Discussions

custon table

Former Member — Tue, 13 Nov 2007 21:27:25 GMT

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

Re: custon table

Former Member — Tue, 13 Nov 2007 21:32:10 GMT

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

Re: custon table

Former Member — Tue, 13 Nov 2007 21:36:50 GMT

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

Re: custon table

naimesh_patel — Tue, 13 Nov 2007 21:40:05 GMT

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

Re: custon table

Former Member — Tue, 13 Nov 2007 21:41:46 GMT

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

Regards,

Satish

Re: custon table

Former Member — Tue, 13 Nov 2007 21:42:19 GMT

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

A582 * A

A582 * L

A582 * N

A582 * K

....

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

A582 * A

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

Regards

Anji