topic Re: Transaction sm30 ??? in Application Development and Automation Discussions

Transaction sm30 ???

Former Member — Thu, 01 Mar 2007 04:27:31 GMT

Hi,

How to use transaction sm30 ???

Regards,

V.Raghavender.

Re: Transaction sm30 ???

Former Member — Thu, 01 Mar 2007 04:30:31 GMT

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

Re: Transaction sm30 ???

Former Member — Thu, 01 Mar 2007 04:31:16 GMT

Hi ,

Go to SE11 - > Enter the table name -> Display -> Utilities Menu -> Table maintenance Generator ( Ofcourse you have to be Edit mode ) . Once you generate the Maintenance View you will be able to make entries from sm30.

Hope this helps

Sunil.M

Re: Transaction sm30 ???

Simha_ — Thu, 01 Mar 2007 04:34:12 GMT

Hi,

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...

Cheers,

Simha.

Re: Transaction sm30 ???

Former Member — Thu, 01 Mar 2007 04:36:40 GMT

Hi ,

Whenever a table is created in se11 depending on the data the table is going to store the table maintainance may be created or not , for eg many standard tables which store master data dont have this table maintainance view this is because SAP does not want the general user to have authorisation to change add or delete master records directly withoput using the proper business process transactions to achieve the same , but for a few tables table maintainance is allowed , in the sense one can modify,add or delete entries in this table.

To do this one goes in transaction sm30 and goes in the change mode and directly updates the entries in the table........

This is generally used in the customization process where in some fields of the table are maintained by the end user itself.

Regards,

Sunmit.

Re: Transaction sm30 ???

Former Member — Thu, 01 Mar 2007 04:40:42 GMT

Hello Raghavender,

SM30 is used for table maintenance.

The procedure for table maintenance is:

1)Go to se11 and type the table name in Display or change mode.

2)Using the menu path Utilities -> Table Maintenance Generator .Table maintenance is generated.

3)To be able to maintain your table using a transaction(using a transaction for table maintenance dialog),you need to do the following.

•Create a new transaction of the type “Parameter Transaction” from SE93, specifying SM31 as the transaction.

•The VIEWNAME parameter is set to your table name with the option ‘Skip initial Screen’ set.

•The UPDATE parameter is set to value ‘X’.

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

regards,

Beejal

**Reward if this helps

Re: Transaction sm30 ???

Former Member — Thu, 01 Mar 2007 06:04:51 GMT

Hi,

in SM54 also u can do the same.

Regards,

Kishore