Key field add in existing table

[Former Member]

Dear gurus,

I want to add a field as key field in the existing table.

I would like to know what is the impact when i do?

What is the procedure to do this ?

Kindly provide the solution.

Regards

R. Rajendran

[Former Member]

Hi Rajendra,

Just add your field in the table add check for the key field and go to Transaction SE14 give your table name adjust and activate your table.

You will have to maintain TMG if it was created previously.

Regards.

Mona

[Former Member]

hi,,,,,,

If you add your field as a primary key field, then all the entries in that field should be identical means no duplicate entries,

If you add that field as a foreign key then you can attach your keys content as the check values for other tables which are having the same key, and more over you xcan apply the join conditions.

the another advantage could be while creating the index you can create the unique index and that key field.

to create a foreign key there is a pushbutton with the key as a icon just go to se11 and while adding the name of the field prees that button and follow the procedure,

Thanks

Saurabh

[Former Member]

Hi Rajendran,

If you want to add a new field as a key field in a table then first of all make sure that it has a unique value throughout the table entries. Later on in SE11 you can make this field as a primary key for the table.

In case of the making this field as the foreign key you have to provide the table entry checks for that field. Moreover you can make a join on that table with other table using that field.

A table can have 16 primary keys.

For more details about the primary key of the table go through the link :

http://help.sap.com/erp2005_ehp_04/helpdata/EN/28/262640632cec01e10000000a155106/frameset.htm

https://www.sdn.sap.com/irj/scn/wiki?path=/display/maxdb/primary%252bkeys%252band%252bindexes

Thanks,

Nitesh Jain