topic Re: table maintenance in Application Development and Automation Discussions

table maintenance

Former Member — Tue, 13 May 2008 12:50:16 GMT

I have modified(added some fields)in a Z table . Now i need to know how to adjust the table maintenace generator wheather we need to delete and recreate or any other option is there

pls let me know

Thanks

sai

Re: table maintenance

Former Member — Tue, 13 May 2008 12:54:20 GMT

hi,

You need not delete it and regenerate do this way ...

Go to Table Maintainence screen in change mode .. click on the change button You will get a popup in that press 'Expert Mode' button and select last check box 'Refresh Overview screen' and press enter ...

Regards,

santosh

Re: table maintenance

former_member673464 — Tue, 13 May 2008 12:55:22 GMT

hi,

You can use the table maintanance generator in Utilities in SE11 for table maintanance.

Regards,

Veeresh

Re: table maintenance

Former Member — Tue, 13 May 2008 13:08:28 GMT

Hi Santosh,

Thanks for reply .

I did as you mentioned all fields are coming except last one

When i press maintain button after the step done which you told i am getting an error like

"Address cannot be maintained,entry in the table TSADRV missing"

Pls let me know what is the problem.

thanks

sai

Re: table maintenance

Former Member — Tue, 13 May 2008 13:11:01 GMT

hi,

I guess there is some problem in generation ... So delete and regenerate to avoid that problem...

Regards,

Santosh

Re: table maintenance

Former Member — Tue, 13 May 2008 13:54:10 GMT

Hi,

Go to SE14 ->Give table name ->At the bottom , you will find one tab "Activate and Adjust Database" ->select radio button "Save Data".

Automatically, your database table will be adjusted and saved.

Regards

Sandeep reddy