primary keys

[Former Member]

Dear gurus,

How many primary keys can be there in the table?

Regards

R.Rajendran

[Former Member]

We can define 16 primary keys at max.

[Former Member]

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

[Former Member]

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

[Former Member]

You can define 16 primary keys in a table.

Thanks

Nayan

[Former Member]

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

[MarcinPciak]

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

[Former Member]

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

\[removed by moderator\]

thx

twinkal

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

[Former Member]

hiii

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

thx

twinkal

[JozsefSzikszai]

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

ec

[ThomasZloch]

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

[JozsefSzikszai]

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