01-10-2008 3:13 PM
Dear All,
I have a custom table with some data. now I have to add 2 more fields to that table. I made changes and it shows me no syntax errors. Now I want to activate thia table.
I wonder what happens to my old data and what will be corresponding new field value. One of my friend was saying that it will ask you to do some repair. in Which T code should I do it.
Thanks
Madhu
01-10-2008 3:15 PM
Hi ,
U have to Repair and Adjust ur table if u have included it any program or used as reference for any other table.
U can do it using SE14.
OR
U can also do it as follows.
Open Ur Table.
In the Utilities Menu --> Database Object --> Database Utility
Select the Radio Button DIrect.
Click The Button Activate and Adjust. Keep Save Radio Button Selected.
Now ur old data will not be deleted.
Awrd points If useful
Bhupal
01-10-2008 3:15 PM
Hi ,
U have to Repair and Adjust ur table if u have included it any program or used as reference for any other table.
U can do it using SE14.
OR
U can also do it as follows.
Open Ur Table.
In the Utilities Menu --> Database Object --> Database Utility
Select the Radio Button DIrect.
Click The Button Activate and Adjust. Keep Save Radio Button Selected.
Now ur old data will not be deleted.
Awrd points If useful
Bhupal
01-10-2008 4:02 PM
Dear Bhupal, John, Max.
Thank you very much for your quick replies. My issue is resolved.
Thank You again for your time and knowledge sharing. I am alloting points.
Regards
madhu
01-10-2008 3:16 PM
Use SE14
and select the radio button to adjust table and save existign data (reads something like that).
01-10-2008 3:18 PM
Hi
If you have added the new fields as last fields of your Z-TABLE, nothing'll happen.
U can active it and the system'll mantain all old data.
Only if you can't actve it for some reason, you can use the database utility (trx SE14) to active the dictionary and database table: here you can choose to keep or delete the old data.
But it usually need to use SE14 when it deletes some fields.
Max
01-10-2008 3:26 PM
hi,
you can add more fields to your ztable whenever you want.
it will not affect the previous data present in your table. the new fields will be inserted and for the previous table records, the new field's value would be blank.
plz reward points if helpful..