what is the use of table maintenance generator

Hi Prashanth,

Table Maintenance Generator is used to maintain the values of a table.Means we can add new records/entries and can even change the existing records.This is actually meant and easy for users.

We can also do this kind of activity through transaction SE16.But in realtime in Production environments, Users will not have access to SE16. So, through this table maintenance (transaction code:SM30) users can add or change the records in a table if there is a requirement to do so by getting proper approvals from their managers/management.

For example: A custom transaction is posting the invoice amounts to a GL account say 12345. For some reason the business want the amounts to be posted to a different account 12346.In this case, if we just change the GL account and save.From next time the invoice amounts will be posted to this GL account.So, there is no necessity to change any config or the code.

If you want to create table maintenance generator, please try like the following:

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.

Other useful links:

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

You can use the SM30 to maintain a table or you can create a separate custom transaction code for that table to maintain.

If you want to create a custom transaction to maintain a table,please try following:

Go to transaction code: SE93 and click on create.

Then select Parameter Transaction and give SM30 in the t.code in Default Values tab.

Check the checkbox Skip Initial Screen.

And In the default values, write:

VIEWNAME = (give your table name).

SHOW = X

Finally, save and use the new t.code to maintina your table.

Hope this helps.

Thanks,

Srinivasa

But the most important reason to use the table maintenance generator is that users can maintain tables without being given authorization to use SM30.

Rob

Hi

Table maintenace generetor is generally used for creating new entries and modifying existing data in a table with ease.It is Generally for end users so that they can enter data , delete or modify

with ease.

Table maintenance generator is used to create screen to maintain values in a table. Once you create maint generator you can goto transaction SM30 and add data to table

To create Table maintenance genetrator,

Go to Utilities->Table maintenance generator

Then Enter Authorisation group(For eg &NC&)

Function group ( You can create function group in SE37. Here in the menu GOTO->Function group-> Create group)

Then you can select either one step or two step. Assign Screen numbers (To assign Screen numbers click on the button 'Find Scr no' . It will propose screen no:s)

Then Create.Save

Table maintenance is created.

Regards,

Maha.

The Table Maintenance Generator is used to create table maintenance program to add, modify or delete records in the database table. This can be accessed using transaction SE54 or in SE11 using the menu Utilities->Table Maintenance Generator.