topic Re: table maintenance in Application Development and Automation Discussions

table maintenance

former_member582701 — Mon, 23 Apr 2007 12:18:08 GMT

Hello!

I have modified one field (name and type) of an existing table. I think i need to do the maintenance table again to insert entries. Is it true? How i delete last maintenance for create the new?

Thx

Re: table maintenance

Former Member — Mon, 23 Apr 2007 12:19:13 GMT

Ya u need to create table maintenance by going in se11 enter the table name press change->Utilities->Table maintenance generator

Then go in SM30 n change delete or create entries.

or use txn se14 to adjust the database table

Hope this helps

regds

Seema

Re: table maintenance

Former Member — Mon, 23 Apr 2007 12:19:46 GMT

Hi Manel,

for this you need to adjust table.

You can do it using T Code SE14.

in SE14 give table name and click Adjust table with or without delete data..as u want to do it.

and to maintain table...from UTILITIES menu... go to TABLE MAINTANANCE GENERATOR and create it there..

then through SM30 you can maintain the table entries.

This will help.

Reward points if answer was helpful,

Regards,

Tejas

Re: table maintenance

Former Member — Mon, 23 Apr 2007 12:20:03 GMT

check tcode Se54, here u can delete or Adjust.

Regards

prabhu

Re: table maintenance

Former Member — Mon, 23 Apr 2007 12:21:25 GMT

Hi Manel,

Table maintenance is used to maintain data in the tables created (ZTABLE)

Generally for inserting new records into custom table thru transaction SM30, we need to enter all the values manually and save the record.

When certain data for the key fields needs to be populated automatically while creating entries, the steps involved are:

Maintaining the subroutine in view V_TVIMF for a particular custom table.

Logic for extracting relevant data for the fields entered, when user press enter button.

Check this blog for more information on extracting data in table maintenance.

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

check these links --

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: table maintenance

Former Member — Mon, 23 Apr 2007 12:21:29 GMT

Go and Adjust the table using data base utility (Utilities Menu).

Create table maintainace from table maintainance generator by pressing on the pencil button

Re: table maintenance

Former Member — Mon, 23 Apr 2007 12:22:29 GMT

Hi Manel,

Yes, you are right.

To modify or to delete or to insert any existing table,

table maintenance is necessary.

Thanks and Regards,

Archana