Application Development and Automation 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: 
Read only

Table without primary key

Former Member
0 Likes
1,144

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

8 REPLIES 8
Read only

Former Member
0 Likes
1,071

Hi

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

Rm

Read only

Former Member
0 Likes
1,071

Hello

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

Read only

Former Member
0 Likes
1,071

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

Read only

Former Member
0 Likes
1,071

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..

Read only

Former Member
0 Likes
1,071

Is it really so hard to understand why?

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

pk

Read only

Former Member
0 Likes
1,071

Hi:

you need to add one more field as primary key.

Regards

Shashi

Read only

Former Member
0 Likes
1,071

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

Regards

Karthik D

Read only

0 Likes
1,071

or else we might end up client-independent!