topic Re: primary key in Application Development and Automation Discussions

primary key

Former Member — Fri, 15 Sep 2006 09:17:47 GMT

hi friends,

can u plz explain what is complex primary key?

regards,

siri.

Re: primary key

Former Member — Fri, 15 Sep 2006 09:21:48 GMT

its more than 1 field as primary key,i believe.

if you make many fields as the primary key set,it would become complex primary key.

Correct me,if i am wrong.

Message was edited by: Srikanth Kidambi

Re: primary key

Former Member — Fri, 15 Sep 2006 09:22:54 GMT

Hi,

projection view wich is combination of primary keys

of different table .

check below link

http://help.sap.com/saphelp_nw04s/helpdata/en/6d/117c44d14811d2a97400a0c9449261/content.htm

Regards

Amole

Re: primary key

Former Member — Fri, 15 Sep 2006 09:23:59 GMT

Hi,

projection view wich is combination of primary keys

of different table is example of complex primary key.

check below link

http://help.sap.com/saphelp_nw04s/helpdata/en/6d/117c44d14811d2a97400a0c9449261/content.htm

Regards,

Amole

Regards

amole

Re: primary key

Former Member — Fri, 15 Sep 2006 09:28:19 GMT

hi,

Check this out

http://database.ittoolbox.com/documents/popular-q-and-a/sql-server-simple-vs-complex-primary-keys-2124

Regards,

Santosh

Re: primary key

Former Member — Fri, 15 Sep 2006 09:28:39 GMT

hi srikanth,

even i dont know this,

i was asked this question in one my interviews.

regards,

siri.

Re: primary key

Former Member — Fri, 15 Sep 2006 09:34:46 GMT

Hello,

If group o´f fields acts as a key, then it is also called complex keys.

Regs,

Venkat Ramanan N

Re: primary key

Former Member — Fri, 15 Sep 2006 09:51:06 GMT

Hi sireesha,

1. In any table, there can be many records.

2. To UNIQUELY AND DISTINCTIVELY

identify the FULL RECORD,

we need something unique indicator.

eg. In purchase order table,

the unique thing is purchaser order number.

3. The field (Or combination of fields)

which uniquely identify the records,

IS CALLED AS PRIMARY KEY.

regards,

amit m.

Re: primary key

Former Member — Fri, 15 Sep 2006 09:55:52 GMT

hi,

A field which is used to identify a particular record in a table can be termed as a primary key. For some types of tables, in which transaction data is stored, it is not possible to identify a particular record using a single field. In these cases we have to use more than 1 field to identify the records, which can be termed as Complex Primary Key. All tables that contains master data, mostly have a singled field as Primary Key. All tables that contains transaction data, mostly have more than one field as Primary key.

Ex: EKKO - (PO Master Table) - - EBELN is the Primary Key

EBELN is used to identify records

EKPO - (PO Item Data)

- - EBELN, EBELP (complex primary key)

Both EBELN,EBELP are used to identify records

Regards,

Vinny