04-23-2007 1:18 PM
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
04-23-2007 1:19 PM
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
04-23-2007 1:19 PM
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
04-23-2007 1:19 PM
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
04-23-2007 1:20 PM
04-23-2007 1:21 PM
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
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
04-23-2007 1:21 PM
Go and Adjust the table using data base utility (Utilities Menu).
Create table maintainace from table maintainance generator by pressing on the pencil button
04-23-2007 1:22 PM
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