topic Re: database table in Application Development and Automation Discussions

database table

Former Member — Tue, 19 Aug 2008 13:42:45 GMT

Hi all,

I have created a database table with the following fields

1) mandt

2) matnr

3) werks

4) lgort

5) length - used my own datatype

6) erfme

7) erfmg

i have mandt as primary field.

now after inserting the first record while i am trying to insert a new one, it always gives me the same message however i change the data.

it says A DATA RECORD WITH THE SPECIFIED KEY ALREADY EXISTS.

plz help me out on this.

Thanks and Regards,

C.A

Re: database table

Former Member — Tue, 19 Aug 2008 13:44:24 GMT

> i have mandt as primary field.

what about other key fields will that table in active state.

If you enter duplicate keys then it will not allow you to create the entries.

Re: database table

bpawanchand — Tue, 19 Aug 2008 13:44:33 GMT

MANDT is the client login number so when ever you try to insert another record with the same primary key it triggers an error.

you should define along with MANDT one more fields as primary KEY

Regards

pavan

Re: database table

Former Member — Tue, 19 Aug 2008 13:45:24 GMT

Hi Vijay,

I have only mandt as primary field.

Regards,

C.A

Re: database table

Former Member — Tue, 19 Aug 2008 13:45:40 GMT

The thing is you have specified only MANDT as primary key. So, it always holds only record and so it gives the message.

You need to specify more fields as key fields. May be MATNR and WERKS also make them as primary keys...

In this way you can insert more records...

Re: database table

Former Member — Tue, 19 Aug 2008 13:47:37 GMT

Hi,

In the Database table you have mentioned MANDT as primary key.

But Mandt by default filled as the logon client number.

So again if you insert new records it will take same client no but in Database table it is not possible. Thats why it is showing the error.

Better you add one more primary key except MANDT then there will be no problem.

Regards,

Sujit

Re: database table

Former Member — Tue, 19 Aug 2008 13:48:17 GMT

Hi,

When you used only MANDT as key field

it will not allow to enter the records more than 1

Because the table checks the entries against key fields in the table

So it looks for mandt in your case. but the record will be in the table already

So you need to create one more key field based on your requirement.

Regards,

Siva Chalasani

Re: database table

Former Member — Tue, 19 Aug 2008 13:48:49 GMT

Hello

For correct work it is necessary to do several primary fields.

For example - mandt + matnr + werks

Re: database table

Former Member — Tue, 19 Aug 2008 13:49:33 GMT

along wiht MANDT, you should set the 2) matnr

3) werks

fields also key fields. then it consider the combination of these three fields is unique.

Re: database table

Former Member — Tue, 19 Aug 2008 13:49:48 GMT

If you have one primary key that is mandt then how can you insert the other records.

include other key/s and it will allow you to create multiple entries, until unless you don't have any duplicates.