Skip to Content
author's profile photo Former Member
Former Member

what is the use of table maintenance generator

hi

what is the use of table maitenace generator..how to use it in applications

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 06:53 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 08:05 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 04:14 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 05:03 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 04:01 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.