sm30.

[Former Member]

For what we use sm30 transaction.

[Former Member]

It is the table maintainance transaction . You can easily add, delete or modify the entries.

Basically it will allow you to maintain your table .

Assign points if it helps.

-Gaurang

[Former Member]

Hi,

It is used to maintain views and database tables.

U can maintain only those table which are activated for mainatainance.

Rgds,

Prakash

[Former Member]

Hi Sasidhar,

SM30 is used for table maintainence(addition or deletion of records),

For all the tables in SE11 for which Table maintenance is selected , they can be maintained in SM30

Sm30 is used to maintain the table ,i.e to delete ,insert or modify the field values and all..

It creates the maintenance screen for u for the aprticular table as the maintenance is not allowed for the table..

In the SE11 delivery and maintenance tab, keep the maintenance allowed..

Then come to the SM30 and then enter the table name and press maintain..,

Give the authorization group if necessary and give the functiongroup and then select maintenance type as one step and give the screen numbers as system specified..

Then create,,,

Then u will able to see the maintenance view for the table in which u can able to insert and delete the table values...

Regards,

Priyanka.

[amit_khare]

Check this link -

Regards,

Amit

[Former Member]

Hi,

We use SM30 transaction for entering values into any DB table.

First we create a table in SE11 and create the table maintenance generator for that Table using (utilities-> table maintenance generator) and create it.

Then it will create a View.

After that from SM30, enter the table name and Maintain, create new entries, change the existing entries for that table.

reward if useful

regards,

Anji

[Former Member]

If you want to update any tables, you generally dont have the rights on the production server to do it directly in SE11 or so.

If you want to maintain a table entry, in that case, you need to create a table maintainence.

[Former Member]

Hi Sasidhar,

table maintanance Generator is used to manually

input values using transaction sm30

follow below steps

1) go to se11 check table maintanance check box under

attributes tab

2) utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

3)

select standard recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

it to request.

4) select maintaience type as single step.

5) maintainence screen as system generated numbers

this dialog box appears when you click on create

button

6) save and activate table

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

http://help.sap.com/saphelp_46c/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

/message/2831202#2831202 [original link is broken]

One step, two step in Table Maintenance Generator

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

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 this link --

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

refer.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20im...

Hope this resolves your query.

Reward all the helpful answers.

Regards

[shishupalreddy]

hI

hOPE These may helps you ....

https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_forums&query=tablemaintanencegenerator&adv=false&sortby=cm_rnd_rankvalue

Regards,