topic Re: Table without primary key in Application Development and Automation Discussions

Table without primary key

Former Member — Thu, 29 Oct 2009 11:31:18 GMT

Hello,

I have customized table with only one primary key that is client (MNDT). ...total fields are 20.but when i am trying to insert data into it.its only taking one record.what is the reason for this?

Regards,

Soniya.s

Re: Table without primary key

Former Member — Thu, 29 Oct 2009 11:33:20 GMT

It Clearly tells you that you need keep one or more fields as KEY fields based on your requirement

Hope this is clear to you.

Cheers

Re: Table without primary key

Former Member — Thu, 29 Oct 2009 11:35:13 GMT

Hello

There is one reason: you do not read SAP documentation and you do not search SDN.

Re: Table without primary key

Former Member — Thu, 29 Oct 2009 11:37:35 GMT

HI,

Since you have declared only MANDT as the primary key, only one record would get saved in the table because primary keys should be unique for all the records. Hence declare another field which would be unique for all the records as a primary key along with the MANDT.

Thanks,

Harini

Re: Table without primary key

Former Member — Thu, 29 Oct 2009 11:37:42 GMT

Hi,

primary key is a unique key....

so mandt is the only primary key and the first record has met that condition.. it cant take same mandt for the second record..

so make another primary key..

Re: Table without primary key

Former Member — Thu, 29 Oct 2009 11:38:27 GMT

Is it really so hard to understand why?

Did you even give a moment's thought before posting a question here???

Re: Table without primary key

Former Member — Thu, 29 Oct 2009 12:03:43 GMT

Hi:

you need to add one more field as primary key.

Regards

Shashi

Re: Table without primary key

Former Member — Thu, 29 Oct 2009 12:16:49 GMT

By any chance, don't let your MANDT (Client) see this question.

Regards

Karthik D

Re: Table without primary key

ThomasZloch — Thu, 29 Oct 2009 12:54:45 GMT

or else we might end up client-independent!