Skip to Content
avatar image
Former Member

table maintainence generator

how to maintain table mainteneance Generator for a table

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 10, 2007 at 08:31 AM

    hI,

    Table maintenance is used to maintain entries in the table.

    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.

    download document from

    https://wwwn.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 08:32 AM

    Hi,

    Well the purpose of table maintainence generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

    SE11->Utillities->table maintainence generator

    You need to enter the values of following fields:

    1. Table name

    2. Authorization group , and authorization object (select the suitable one )

    3. Function group and package

    4. Maintainence type : single or double screen maintainence view depending on the option selected.

    5. Maintain screen number : you may specify a value or let the system generate one for you.

    The validation code for the table entry is written in the flow logic of this screen. Even some of the fields may be made display only , by adding suitable code in the logic or directly disabling the input in table control in the layout.

    >> Activate

    Reward if helpful.

    Regards,

    Nagaraj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 08:35 AM

    Hi

    <b>Maintenance Genarators</b>

    A maintenance view permits you to maintain the data of an application object together.

    The maintenance status determines which accesses to the data of the underlying tables are possible with the maintenance view.

    Mai<b>ntenance Status</b>

    The maintenance status of a view controls whether data records can also be changed or inserted in the tables contained in the view.

    <b>The maintenance status can be defined as follows:</b>

    Read only: Data can only be read through the view.

    Read, change, delete, insert: Data of the tables contained in the view can be

    changed, deleted, and inserted through the view.

    Read and change: Existing view entries can be changed. However, records

    cannot be deleted or inserted.

    Read and change (time-dependent views): Only entries whose non-time

    dependent part of the key is the same as that of existing entries may be

    inserted.

    <b>Restrictions for Maintenance</b>

    There are some restrictions for selecting the secondary tables of a maintenance view or help view. The secondary tables have to be in an N:1 dependency to the primary table or directly preceding secondary table. This ensures that there is at most one dependent record in each of the secondary tables for a data record in the primary table.

    Table maintenance allows you to create entries for that table

    Follow these steps to generate table maintenance

    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 if usefull</b>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 08:35 AM

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

    Check the following blog on table maintenance:

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

    check the following link table maintenance:

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

    *******************

    Importance of table maintenance

    from SE11 , enter the table name and then click on change, then in the menu Utilities->Table maintenance Generator.

    give authorization group,Function Group, Sngle screen(radio Button),Mainitenance screen no, and Standard Recording Routine Radio Button ..

    and save it.

    and then Go to SM30 and check it with the same name.

    ******************

    Here is an extension to table maintenance generator.

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 08:38 AM

    Hi,

    In the menu bar of ur D/b table, go to

    <b>Utilities-------> Table Maintenance generator</b>,

    then create the table maintenance generator,

    give <b>Authorisation group = &NC</b>& if without authorisation.

    create a Function group in SE80 and assign there in <b>Function group</b> field

    then put <b>Maintenance type = One step</b> (if u want dispaly and modification in one screen),

    then put <b>Overview screen no.</b> as any no.

    then click on the Create button on the application tool bar.

    In this way you can create Table maintenance generator.

    Reward point if helpful.

    Gud luck,

    Bhawani

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 08:39 AM

    hi

    good

    Table maintenance allows you to create entries for that table

    Follow these steps to generate table maintenance

    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.

    reward point if helpful.

    thanks

    mrutyun^

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10, 2007 at 08:40 AM

    Hi...

    Parameter Transaction can be created for Table Maintenance program of a Custom Table in SAP.

    Steps:

    1. Create a Z table and Activate - SE11

    2. Generate the Table Maintenance using SE54

    It will Generate the Function group and Screens.

    3. Create a Parameter transaction to Call this Table maintenace program

    Goto SE93.

    Create a Tcode :

    Name : ZTCODE1

    Type : Parameter Transaction

    In the Attributes of Parameter Transaction

    Enter The Transaction SM30

    Select the Checkbox : Skip first Screen

    Enter the Following Fields below in the Table provide.

    <b> FieldName FieldValue</b>

    VIEWNAME <YOUR ZTABLE>

    UPDATE X

    Save the Parameter Transaction and execute it like ant other Tcode..

    It will allow you to maintain the Table entries.

    <b>reward if Helpful.</b>

    Add comment
    10|10000 characters needed characters exceeded