key fields

[Former Member]

can we add more number of keys , while firstly we have added 2 key fields two the table , plz give me link also regarding dat , thanks rahul

[Former Member]

Hi,

You can add the key fields, but it won;t accept you, because key field does not contain the null value.

Goto change mode, and add a record in after the 2 key fields, then SAVE it. then goto SE14 then give that table name and press Activate and Adjust.

Regards

Sudheer

[Former Member]

hai Rahul,

ADD Key Field's And Then Save .

Go to Database Utility were U Can Adjust Database Table.

Then Come Back Then Activate .

if U want Documentation Regarding data Base Utility Go to Following Link.

http://help.sap.com/saphelp_47x200/helpdata/en/4f/991f82446d11d189700000e8322d00/frameset.htm

[vinod_vemuru2]

Hi,

u can add new key fields at any time. But if ur table has data then u will not be able to activate it. So add ur key fields and save it. In Se14 press activate and adjust data base. This will solve ur activation issues.

Another impotant point after adding new fields(Key or non key)

• if u have table maintenance generator then delete and regenerate it.*

Otherwise u will get short dump if u try to access Table Maintenance Generator(Sm30)

Thanks,

Vinod.