Unique Key

[Former Member]

Hi Guys,

When u enter EKKO in SE11 and click Enter then u enter into the other screen in that Screen what does the column " Key " means is it Primary Ket or Unique Key?

Thanks,

Srinivas.

[Former Member]

Hi,

IF the flag is set then it Identifies a key field of a table

Thanks

Naren

[Former Member]

It is primary key and so it also unique key. You can have only one primary key set for a table (that checkbox checked) whereas there can be several unique keys defined by defining indexes on it.

[Former Member]

Hi Srinivas,

But a Primary key should never have a Null Value,but in in SAP Database table for Ex : BSAK i am having values Null for some Primary Fields.

So how can we get a Unique row of records from set of Primary Keys?or Is there any problem with the data?

Thanks,

Gopi.

[Former Member]

I am not sure why you think primary key field should not be null. It may appear null but in the underlying DB table (at Oracle or some other DB level), all primary key fields are filled with their initial values not NULL values. The check box next to the key field 'initial values' is typically checked for that reason only. You can check the documentation on that checkbox. If you have one or more of the key fields initial, you can still get unique records because the uniqueness is enforced by the database once you specify that group of fields as key fields. So even if you have one field initial, the other key fields should still result in a uniques record.

[Former Member]

Hi,

Check out this thread

check all the answers given by John Jakabcsin in this thread

regards,

pankaj