topic Re: Database table without key in Application Development and Automation Discussions

Database table without key

former_member353207 — Fri, 16 Mar 2007 07:17:31 GMT

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

Re: Database table without key

Former Member — Fri, 16 Mar 2007 07:19:27 GMT

1) It is possible.

**Please reward suitable points***

With Regards

Navin Khedikar

Re: Database table without key

Former Member — Fri, 16 Mar 2007 07:21:52 GMT

Could you kindly elaborate on this with ex ?

Re: Database table without key

Former Member — Fri, 16 Mar 2007 07:23:09 GMT

Hi,

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

Regards

Sudheer

Re: Database table without key

Former Member — Fri, 16 Mar 2007 07:29:41 GMT

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.

Re: Database table without key

former_member353207 — Fri, 16 Mar 2007 07:33:17 GMT

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

Re: Database table without key

Former Member — Fri, 16 Mar 2007 07:38:42 GMT

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.