Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

table maintenance

former_member582701
Contributor
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Manel,

for this you need to adjust table.

You can do it using T Code <b>SE14</b>.

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 <b>UTILITIES menu... go to TABLE MAINTANANCE GENERATOR</b> and create it there..

then through SM30 you can maintain the table entries.

This will help.

<b>Reward points if answer was helpful,</b>

Regards,

Tejas

6 REPLIES 6

Former Member
0 Kudos

Hi

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

Former Member
0 Kudos

Hi Manel,

for this you need to adjust table.

You can do it using T Code <b>SE14</b>.

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 <b>UTILITIES menu... go to TABLE MAINTANANCE GENERATOR</b> and create it there..

then through SM30 you can maintain the table entries.

This will help.

<b>Reward points if answer was helpful,</b>

Regards,

Tejas

Former Member
0 Kudos

check tcode Se54, here u can delete or Adjust.

Regards

prabhu

Former Member
0 Kudos

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%20im...

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

Hope this resolves your query.

<b>Reward all the helpful answers.</b>

Regards

Former Member
0 Kudos

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

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

Former Member
0 Kudos

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