topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Tue, 16 May 2006 14:50:28 GMT

Hi,

I have a ztable. This is also maintained using sm30. Now I have modified the table to add some new fields. In sm30 I want to maintain values for this new fields. The condition is I don't want to lose the values that were prevously maintained for the other fields. Is there anyway this can be achieved.

Regards,

Varun.

Re: Table maintenance

RichHeilman — Tue, 16 May 2006 14:52:46 GMT

Just regenerate the table maintenance the same way that you created it. It will ask you about the changes, just say "New Fields". It will rebuild your maintenance program.

Regards,

Rich Heilman

Re: Table maintenance

Former Member — Tue, 16 May 2006 14:55:12 GMT

Hi Rich,

This is what I did.

I went to se11 and entered thentable name and clikced change. Uitilities -> table maintenance generator.

F7 -> checked new field.But I couldn't see any changes.

Can you please explain the process in detail.

Regards,

Varun.

Message was edited by: varun sonu

Re: Table maintenance

suresh_datti — Tue, 16 May 2006 14:57:49 GMT

Use Tcode SE14, to activate & adjust database without deleting existing entries.

regards,

Suresh datti

Re: Table maintenance

Former Member — Tue, 16 May 2006 14:58:10 GMT

Do you activation in se14 transaction.

Chose the radio-button for Save data and click on the button Adjust and activate database.

Then regenerate your table maintenance.

Regards,

Ravi

Re: Table maintenance

Former Member — Tue, 16 May 2006 14:59:52 GMT

Data will not be lost if U regenerate the table maintenance again....New fields will not have data but other fields of the record will have the old data...

Re: Table maintenance

Former Member — Tue, 16 May 2006 15:00:23 GMT

hi Varun,

Go to SE14 give the object name and press edit button in that press button activate & adjust database without deleting existing entries.

and go to se11 and enter the Ztable name and then follow this path UTILITIES->TABLE MAINTAINENCE GENEATOR. Delete the existing view and create a newer one.

Note:Donot worry about losing the data in this process your data will not be deleted

Regards,

Santosh

Re: Table maintenance

Former Member — Tue, 16 May 2006 15:01:28 GMT

after adding fields to a table we have to adjust & activate in SE14

Re: Table maintenance

RichHeilman — Tue, 16 May 2006 15:02:14 GMT

You want to add the fields so that you can maintain them in SM30 right? Well, we have to regenerate the table maintenance program. First go to SE11, enter your table name, click change. Click Utitlies, Table Maintenance Generator. Click the change button. You will get a dialog asking what kind of changes are needed, select the checkbox for "New Field". Click green check. System will regenreate the table maintenance. Now when you go to SM30, your new fields should be there.

Regards,

Rich Heilman

Re: Table maintenance

Former Member — Tue, 16 May 2006 15:04:53 GMT

Hi All,

When I click the new fields a new pop up is coming. IN that I am selecting fieldtype as normal. What should be the type of screen ? Single or overview ?

Regards,

Varun.

Message was edited by: varun sonu

Re: Table maintenance

Former Member — Tue, 16 May 2006 15:05:08 GMT

While in table maintenance generator during modification, tick on the screens so that they are deleted and regenerated again otherwise changes will not get reflected in your screen of table maintenance.

Re: Table maintenance

Former Member — Tue, 16 May 2006 15:27:17 GMT

Hi all,

Thank you all for your help friends.

Regards,

Varun.