topic Re: regarding ABAP-dictionary in Application Development and Automation Discussions

regarding ABAP-dictionary

Former Member — Tue, 17 Apr 2007 11:06:27 GMT

Is it possible two primary keys for one database table ? tell me indetail

Re: regarding ABAP-dictionary

Former Member — Tue, 17 Apr 2007 11:09:46 GMT

yes the tables can have one or more primary keys...the combination then becomes primary key(composite key)

for ex:

in the table VBAP - VBELN & POSNR are both primary key fields.

the combination of keys that you define as 'KEY' while creating a DB table becomes primary key.

regards,

madhu

Re: regarding ABAP-dictionary

shishupalreddy — Tue, 17 Apr 2007 11:12:43 GMT

Hello Amar,

It is possible to have more than one primary key anyhow u can see in anyof the table u can find two primary keys in which on is Client (mandt) and atleast a single primary key field related to the table .

so u can have ..........

regards

Re: regarding ABAP-dictionary

Former Member — Tue, 17 Apr 2007 11:13:09 GMT

Hi Reddy,

Welcome to SDN...

Yes, You can have one or more keys to be primay keys for a table.

These primay keys combination is called composite primay key and it will uniquely identifies an entry in a database table.

When creating database table, Give the Key field to be check for the fields which you want to be primay keys.

Thanks,

Vinay

Re: regarding ABAP-dictionary

Former Member — Tue, 17 Apr 2007 11:32:00 GMT

HI,

U can have two or more fields in the primary key of a db table. This type of key is composite primary key. but u can't have more than one primary key for a table, i.e more than one composite primary key.

Combination of primary key fields uniquely identifies the record present in the data base table.

Re: regarding ABAP-dictionary

former_member196299 — Tue, 17 Apr 2007 11:36:25 GMT

hi Reddy,

You can have multiple primary keys in ur transparent table .

The group of primary keys are called as composite Key .

For all the fields you want to define as a primary key ,tick mark the respective fields on the right side .

General you should keep all the primary keys on the top of your Trans. Table.

While writing a select querry use the max number of primary keys as that helps

in better performance.