topic Re: TABLE MAINTENANCE in Application Development and Automation Discussions

TABLE MAINTENANCE

Former Member — Fri, 01 Dec 2006 15:31:09 GMT

HI,

I created a 'z' table and moved it to testing environment. People uploaded some data from excel file through a selectoin screen. This data is wrong, and users wanted to delete this data from the table in testing environment. So I created table maintenance generator in development. I want to move this to testing environment. I have some data in development testing environment. My question is what happens if I move the maintenance generator to testing environment. I have data in the table in both environments. finally my goal is to remove data from the table in testing environment. Your help is appriciated.

Thank you,

Surya.

Re: TABLE MAINTENANCE

Former Member — Fri, 01 Dec 2006 15:42:27 GMT

the table maintenance has generated a request number...Now just goto SM30 and check the table whethere the existing data which was in developemnt is shown up...it should show...Later move the request no to testing system and using SM30 u can see the data and accordingly modify or delete the data.

Re: TABLE MAINTENANCE

Former Member — Fri, 01 Dec 2006 15:45:11 GMT

What will happen to my data in testing environment already? The data in developmnet and testing are different.

Re: TABLE MAINTENANCE

Former Member — Fri, 01 Dec 2006 15:54:34 GMT

When you generate a table maintenance view ...it is basically a module pool abap and the transport would migrate the screen and abaps, making it possible for you to modify/delete/insert data into your ztable via SM31 transaction.

Please note the data would not be migrated !!

Message was edited by:

Anurag Bankley

Re: TABLE MAINTENANCE

Former Member — Fri, 01 Dec 2006 16:04:29 GMT

Hi,

If you want to remove all the records from the table...

Goto SE14 ..Give the table name..

Press Edit..

Then select "Delete data" radio button...

Then press the button "Activate and adjust database"...

Be Careful while doing this..

Also by moving the table maintenance..Will not be problem...The data will not be moved..And while moving the data in the test environment will not be affected..

Thanks,

Naren

Message was edited by:

Narendran Muthukumaran

Re: TABLE MAINTENANCE

Former Member — Sat, 02 Dec 2006 10:26:44 GMT

Surya,

When u generate Table maintenance system will create new Module pool program enabling through SM30 to enter or chage data .

1. When moved to test environment no data is moved respective data in the system will be untouched .

2.But possible to change/insert/delete using new table maintenance

3. If u need to move data from one system to other u should create table maintenance with option Standard user routine - When this option is selected when data is saved it will ask for transport request that will enable you to take the data through out the land scape.

Hope this helps .

Regards

Ramvelu