topic Re: Table Key Field Selection in Application Development and Automation Discussions

Table Key Field Selection

Former Member — Mon, 30 Jan 2006 05:28:13 GMT

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!!!

Re: Table Key Field Selection

athavanraja — Mon, 30 Jan 2006 05:37:34 GMT

you can use FM

GET_KEY_FIELDS_OF_TABLE

to get the key fields of a table.

Regards

Raja

Re: Table Key Field Selection

Former Member — Mon, 30 Jan 2006 05:39:30 GMT

Hi,

Check in Table DD03L , 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 KEYFLAG field in DD03L.

regards

vijay

Re: Table Key Field Selection

Former Member — Mon, 30 Jan 2006 05:39:56 GMT

Thanks so much duraraj!!!

You have solved my problem!!

Re: Table Key Field Selection

Former Member — Mon, 30 Jan 2006 06:04:42 GMT

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

Re: Table Key Field Selection

athavanraja — Mon, 30 Jan 2006 06:05:48 GMT

Glad, it was helpful.

Regards

Raja