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

Database table without key

former_member353207
Participant
0 Likes
900

Hello community

I want to create a database table (SE11) without primary key. Our user should be able to change every field in the table with <Update>. Seems it isn't possible ?

If not what's the easiest way to create a pseudo key ?

regards joerg

6 REPLIES 6
Read only

Former Member
0 Likes
810

hi

1) It is possible.

**Please reward suitable points***

With Regards

Navin Khedikar

Read only

0 Likes
810

Could you kindly elaborate on this with ex ?

Read only

Former Member
0 Likes
810

Hi,

You can create but at the same time select the initial checkbox in the table

Regards

Sudheer

Read only

Former Member
0 Likes
810

HI,

for this purpose u can use MANDT as primary key and you can use remaining field as non key...

Hope this will help u.,

If not write once again I will give alternate solutions.

DARSHAN

    • GIve points if u find it helpful.

Read only

0 Likes
810

If I use only MANDT as key, I can create only ONE entry in the table ... isn't is ??

Read only

0 Likes
810

Ho joerg,

1. By using sap data dictionary, it won't allow a table without primary key

2. If I use only MANDT as key, I can create only ONE entry in the table ... isn't is

Yes, u are right. Only One record will be allowed. (One record Per Client)

regards,

amit m.