topic Re: Unique Key in Application Development and Automation Discussions

Unique Key

Former Member — Tue, 07 Aug 2007 21:51:07 GMT

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.

Re: Unique Key

Former Member — Tue, 07 Aug 2007 22:07:23 GMT

Hi,

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

Thanks

Naren

Re: Unique Key

Former Member — Tue, 07 Aug 2007 22:09:10 GMT

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.

Re: Unique Key

Former Member — Tue, 07 Aug 2007 22:13:22 GMT

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.

Re: Unique Key

Former Member — Tue, 07 Aug 2007 22:21:00 GMT

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.

Re: Unique Key

Former Member — Tue, 07 Aug 2007 22:29:49 GMT

Hi,

Check out this thread

check all the answers given by John Jakabcsin in this thread

regards,

pankaj