We had a custom transparent table with a lot of data in it. Recently we needed one of the keys to be expanded. And the key is in the first field of the table. I want to know it won't impact the data after I change it. What's the steps to do it? What should I be careful for? I will appreciate your time.
You change the key field in SE11. When you generate the table, you'll
be prompted to adjust the table in the database (this is the same as
transaction SE14). For making a key larger, say from NUMC1 to NUMC2, this
adjustment ensures the integrity of your data.
However, in cases like this, where there is a lot of data, I'd suggest making a copy of your table, without data, in your development instance. Add a few representative records, then change the key field, and adjust the table. Check the conversion has worked.
This was first published in October 2001