Table Key Field Selection

[Former Member]

Hi,

I just want to ask if there is a way to get the key field/s of a specific SAP table.

Thanks in advance!!!

[athavanraja]

you can use FM

<b>GET_KEY_FIELDS_OF_TABLE</b>

to get the key fields of a table.

Regards

Raja

[Former Member]

Thanks so much duraraj!!!

You have solved my problem!!

[athavanraja]

Glad, it was helpful.

Regards

Raja

[Former Member]

Hi,

Check in Table<b> DD03L</b> , give the table name and

it will list all the fields, if you want to see the info of all key fields in the table just look for <b>KEYFLAG</b> field in DD03L.

regards

vijay

[Former Member]

Hi ,

Can you be more specific on your question.

If it is Primary key of a table then in transaction SE11 type the Table name and click on display button.

It will open a table, in that click on the Fields tab where you would be able to see Primary keys being checked under the column name 'key'.

If it is foreign key, you can find that in the same table in the entry help/check tab under column name 'Foreign key'checked and giving the table where it exists as primary key.

hope it helps.

Regards,

Vivek