topic Re: primary keys in Application Development and Automation Discussions

primary keys

Former Member — Mon, 23 Jun 2008 12:49:57 GMT

Dear gurus,

How many primary keys can be there in the table?

Regards

R.Rajendran

Re: primary keys

Former Member — Mon, 23 Jun 2008 12:50:48 GMT

We can define 16 primary keys at max.

Re: primary keys

Former Member — Mon, 23 Jun 2008 12:51:03 GMT

hiii

primary key is created by SAP automatically.so it will be only one in table.Secondary keys can be many in table.

\[removed by moderator\]

thx

twinkal

Edited by: Jan Stallkamp on Jun 23, 2008 3:04 PM

Re: primary keys

Former Member — Mon, 23 Jun 2008 12:51:20 GMT

There can be one primary key basically But you can create as many secondary indexes in the database corresponding to the table. But this will take the memory ....

\[removed by moderator\]

Edited by: Jan Stallkamp on Jun 23, 2008 3:04 PM

Re: primary keys

Former Member — Mon, 23 Jun 2008 12:51:26 GMT

You can define 16 primary keys in a table.

Thanks

Nayan

Re: primary keys

Former Member — Mon, 23 Jun 2008 12:53:43 GMT

hi,

16 primary keys.

Primary Index is created by the system automatically and not primary keys.

\[removed by moderator\]

Warm Regards

R Adarsh

Edited by: Jan Stallkamp on Jun 23, 2008 3:04 PM

Re: primary keys

MarcinPciak — Mon, 23 Jun 2008 12:56:26 GMT

Hi,

When defining table you can set as many fields as PRIMARY KEY as you wish.

If only one field is set as a primary key, the key is SIMPLE, if more it is COMPLEX.

Go to SE11 and see any table

i.e. T500L (simple key -only one key has tick next to it in the KEY checkbox)

Regards,

Marcin

Re: primary keys

Former Member — Mon, 23 Jun 2008 13:04:42 GMT

hiiii

read this article for specially sap people..read 1st paragraph & 3rd paragraph under title Internal tables with secondary keys

http://www.sap.info/public/INT/int/printout/article/Category-28943c61b1e60d84b-int/3/articlesVersions-32466479756b7ba526/?PHPSESSID=be2d0fd662166b2e255969dd1181e12c

\[removed by moderator\]

thx

twinkal

Edited by: Jan Stallkamp on Jun 23, 2008 3:09 PM

Re: primary keys

Former Member — Mon, 23 Jun 2008 13:06:56 GMT

hiii

we can create total 16 keys..including 1 primary key & 15 secondary key at maximum level.

thx

twinkal

Re: primary keys

JozsefSzikszai — Mon, 23 Jun 2008 13:16:30 GMT

hi all,

just to make things clear: There are no such things as primary keys! There are key fields and primary index .

Key fields are which are marked as key in SE11 by table creation. There could be not more than 15 key fields in a table.

Primary index is the index with all the key fields. This is created automatically by SAP. Secondary indexes are created manually by developers. There is no upper limit for secondary indexes, however it is not worth to create too much, because the optimezer will have hard time to choose the most suitable index. The meaningful upper limit is probably 5-6 secondary indexes.

hope it is clear now

Re: primary keys

ThomasZloch — Mon, 23 Jun 2008 13:22:51 GMT

Where there's life, there's hope...

Re: primary keys

JozsefSzikszai — Mon, 23 Jun 2008 14:00:22 GMT

yes... and in Bangalore everything is possible...