cancel
Showing results for 
Search instead for 
Did you mean: 

Change Key field in table

rajsapabap-tech
Explorer
0 Kudos
147

Hi , I want to change custom table primary key. Already they are maintain WERKS,MATNR & MRP Area. I need to make VKORG as Key field in table but VKORG position also needs to correction. if i make the changes in table will it have any effect in existing data in the production server ?? 

Sandra_Rossi
Active Contributor
0 Kudos
Same effect as in your current environment.
View Entire Topic
Romanos
Explorer

Hello @rajsapabap-tech ,

If you change the key fields, the table will need adjustment. See Adjustment of Database Structures .
This can lead to a loss of data, depending on the new table key and the availability of the table during the adjustment period. 

In your case you will probably not lose anything from the key change, since you are adding a key field, but the table will be unavailable to calling programms during the adjustment period and this can lead to runtime errors, loss of data etc. Meaning it can create problems somewhere else.