topic Re: table maintenance in Application Development and Automation Discussions

table maintenance

Former Member — Thu, 26 Jul 2007 08:08:16 GMT

Hi Gurus,

I created one ztable. and I want create table maintenace for this.

how to create that please any body give me the steps.

Regards,

Shashikumar.G

Re: table maintenance

gopi_narendra — Thu, 26 Jul 2007 08:10:04 GMT

Go to SE11.

Write table name.

Click on Utitlities > table maintenance generator

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.

Regards

Gopi

Re: table maintenance

seshatalpasai_madala — Thu, 26 Jul 2007 08:10:21 GMT

HI,

Open that tbale in SE11.

And goto the menu Utilites->Table Mainteneance Generator.

This will guide to create one.

You need to mention the function group and the screen number there where you want the code to be generated.

Regards,

Sesh

Re: table maintenance

Former Member — Thu, 26 Jul 2007 08:10:31 GMT

Hi,

Just go to SE11 -> Utilities -> table maintainance generator

and create the same

Regards,

Atish

Re: table maintenance

Former Member — Thu, 26 Jul 2007 08:11:42 GMT

Hello,

refer.

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

Regards,

Deepu.K

Re: table maintenance

Former Member — Thu, 26 Jul 2007 08:36:25 GMT

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

reward if useful

anju

Re: table maintenance

Former Member — Thu, 26 Jul 2007 08:38:37 GMT

Hi,

Please try this.

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. 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 maintenance 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.

<b>Reward points if useful</b>

Regards

Ashu

Re: table maintenance

Former Member — Thu, 26 Jul 2007 08:44:59 GMT

Hi,

With the help of the table maintenance generator, you are able to maintain the ENTRIES of the table in SM30 transaction.

It can be set in transaction SE11 - Tools - Table maintenance generator.

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

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.

SM30 is used for table maintenance(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 function group 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...

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.

For further help look into these links

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

Regards

Re: table maintenance

Former Member — Thu, 26 Jul 2007 10:19:26 GMT

Hi Gurus,

Thank you Gurus I leart how to create table maintenance with your answers.

Thank you for all.

Thanks and Regards,

Shashikumar.G