topic Re: Update Custom table with data ?? in Application Development and Automation Discussions

Update Custom table with data ??

Former Member — Thu, 10 Jan 2008 15:13:43 GMT

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

Re: Update Custom table with data ??

Former Member — Thu, 10 Jan 2008 15:15:53 GMT

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.

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

Re: Update Custom table with data ??

Former Member — Thu, 10 Jan 2008 15:16:17 GMT

Use SE14

and select the radio button to adjust table and save existign data (reads something like that).

Re: Update Custom table with data ??

Former Member — Thu, 10 Jan 2008 15:18:41 GMT

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

Re: Update Custom table with data ??

Former Member — Thu, 10 Jan 2008 15:26:00 GMT

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..

Re: Update Custom table with data ??

Former Member — Thu, 10 Jan 2008 16:02:06 GMT

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