Skip to Content
avatar image
Former Member

table maintenance generator

what is utility of table maintenance generator ?

what is meant by maintenance type ?

what is recording routine and comparing flag ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 19, 2008 at 06:32 AM

    Hi,

    Answer to your question is,

    Use

    In one-step maintenance only one maintenance screen (overview screen) is processed at run time. Entries are displayed here in the form of lists. An entry should be able to be displayed in one line of the screen.

    In two-step maintenance an additional maintenance screen (single screen) is processed at run time, as well as the overview screen. A single entry is displayed on the single screen. The single screen can be called from the overview screen by function key, for every entry.

    3) what is recording routine and comparing flag ?

    Recording Routine

    Indicator which recording routine should be used for changes to table contents.

    Dependencies

    Changes to a task can be recorded. This can be done either automatically or manually, depending on the client settings.

    A standard routine or an individual routine can be used as the recording routine. It is also possible to enhance the standard routine with individual routines.

    The individual routines must be defined as events. The definition is made via the menu function Environment -> Events and concerns the events 10, 11 and 12.

    The recording depends upon the client setting. The following settings are possible:

    1. Changes without automatic recording

    Changes are not automatically recorded. It is, however, possible to make manual recordings.

    2. Automatic recoding of changes

    All changes are automatically recorded.

    3. No changes allowed

    Changes can not be made, it is, however, possible to record table contents manually for the transport.

    4. No transport allowed

    Changes can be made here, but they can be neither automatically nor manually recorded for the transport

    Flag: Object can be adjusted

    This flag indicates whether the maintenance transaction allows the (checked) activation of Business Configuration Sets (BC Sets), and the adjustment. This is the case if the maintenance transaction can run in the background.

    For more information, see the Application Help for the table maintenance generator (transaction SE54).

    The following settings exist:

    • No Information

    The system does not know whether the maintenance transaction allows BC Set activation and adjustment.

    As with the setting "Not Adjustable", the content of the BC Sets is written to the Customizing tables without being checked.

    • Not Adjustable

    The BC Sets cannot be activated and checked. The maintenance transaction does not support the adjustment.

    The content of the BC Sets is written to the Customizing tables without being checked.

    Instead of an adjustment, you can only compare the views or tables with another client or system. Any modifications that arise from an adjustment must be made manually.

    • Adjustable in Dialog

    As with the setting "Not Adjustable", the content of the BC Sets is written to the Customizing tables without being checked.

    An automatic adjustment is not possible, however, you can compare the views or tables with another client or system, and adjust the differences (either all of them or a selection) with the dialog adjustment function.

    Automatically Adjustable

    BC Sets are activated with all field checks.

    The object can be adjusted automatically against another client as part of a Customizing import. This means that the data with differences can be imported from the comparison client. As well as the automatic adjustment option, the maintenance transaction also offers the dialog adjustment function.

    Compare flag

    Flag: Object can be adjusted

    This flag indicates whether the maintenance transaction allows the (checked) activation of Business Configuration Sets (BC Sets), and the adjustment. This is the case if the maintenance transaction can run in the background.

    For more information, see the Application Help for the table maintenance generator (transaction SE54).

    The following settings exist:

    No Information

    The system does not know whether the maintenance transaction allows BC Set activation and adjustment.

    As with the setting "Not Adjustable", the content of the BC Sets is written to the Customizing tables without being checked.

    Not Adjustable

    The BC Sets cannot be activated and checked. The maintenance transaction does not support the adjustment.

    The content of the BC Sets is written to the Customizing tables without being checked.

    Instead of an adjustment, you can only compare the views or tables with another client or system. Any modifications that arise from an adjustment must be made manually.

    Adjustable in Dialog

    As with the setting "Not Adjustable", the content of the BC Sets is written to the Customizing tables without being checked.

    An automatic adjustment is not possible, however, you can compare the views or tables with another client or system, and adjust the differences (either all of them or a selection) with the dialog adjustment function.

    Automatically Adjustable

    BC Sets are activated with all field checks.

    The object can be adjusted automatically against another client as part of a Customizing import. This means that the data with differences can be imported from the comparison client. As well as the automatic adjustment option, the maintenance transaction also offers the dialog adjustment function.

    Table content recording routine

    Indicator which recording routine should be used for changes to table contents.

    Dependencies

    Changes to a task can be recorded. This can be done either automatically or manually, depending on the client settings.

    A standard routine or an individual routine can be used as the recording routine. It is also possible to enhance the standard routine with individual routines.

    The individual routines must be defined as events. The definition is made via the menu function Environment -> Events and concerns the events 10, 11 and 12.

    The recording depends upon the client setting. The following settings are possible:

    1. Changes without automatic recording

    Changes are not automatically recorded. It is, however, possible to make manual recordings.

    2. Automatic recoding of changes

    All changes are automatically recorded.

    3. No changes allowed

    Changes can not be made, it is, however, possible to record table contents manually for the transport.

    4. No transport allowed

    Changes can be made here, but they can be neither automatically nor manually recorded for the transport.

    <REMOVED BY MODERATOR>

    GAURAV J.

    Edited by: Alvaro Tejada Galindo on Aug 15, 2008 3:45 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2008 at 10:30 AM

    Hello,

    The table maintenance generator is a utility which allows you to create maintenance screens for your Z database tables.

    For example, you have created a new table called Z_TABLE in the database. You want to allow users to maintain entries in this table directly. You would therefore create a table maintenance for this table via the table maintenace generator. Users can then maintain entries in this table via transaction SM30

    The maintenance type defines whether the maintenance you create consists of 1 or 2 screens. If you choose "one step", then a single screen will be created from which you can view or maintain the entries. if you choose 2 step, then 2 screens are created. The first screen is where you see all the entries in the table and the second screen is what pops up when you want to create new entries in the table.

    Recording routine - whether changes to the entries are automatically recorded for transport to other systems

    Compare flag - this is important for customising settings. Often the customising settings made in a database table via table maintenance may have been made in accordance with the requirements of the customising system. When transporting the changes to production, the system is set up different which would require different entries in the database table. For example, by setting the compare flag to *adjustable in dialog", a standard SAP functionality is triggered which checks for differences, alerts the system prior to import of the differences and allows the user to adjust the entries.

    Hope this helps.

    Regards,

    NW

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2008 at 10:05 AM

    Hi,

    table maintenence is basically used for the easy inserting and ediiting of the data values.

    SM30 transaction is used fro this purpose.

    Regards,

    Mansi.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2008 at 10:05 AM

    what is utility of table maintenance generator ?

    To maintain table contains like add, modify or delete rows

    what is meant by maintenance type ? .

    Maintenance type determine that whether in table control screen there will be two screen or one screen and the respective screen no.

    Compare flag

    Flag: Object can be adjusted

    This flag indicates whether the maintenance transaction allows the (checked) activation of Business Configuration Sets (BC Sets), and the adjustment. This is the case if the maintenance transaction can run in the background.

    For more information, see the Application Help for the table maintenance generator (transaction SE54).

    The following settings exist:

    No Information

    The system does not know whether the maintenance transaction allows BC Set activation and adjustment.

    As with the setting "Not Adjustable", the content of the BC Sets is written to the Customizing tables without being checked.

    Not Adjustable

    The BC Sets cannot be activated and checked. The maintenance transaction does not support the adjustment.

    The content of the BC Sets is written to the Customizing tables without being checked.

    Instead of an adjustment, you can only compare the views or tables with another client or system. Any modifications that arise from an adjustment must be made manually.

    Adjustable in Dialog

    As with the setting "Not Adjustable", the content of the BC Sets is written to the Customizing tables without being checked.

    An automatic adjustment is not possible, however, you can compare the views or tables with another client or system, and adjust the differences (either all of them or a selection) with the dialog adjustment function.

    Automatically Adjustable

    BC Sets are activated with all field checks.

    The object can be adjusted automatically against another client as part of a Customizing import. This means that the data with differences can be imported from the comparison client. As well as the automatic adjustment option, the maintenance transaction also offers the dialog adjustment function.

    Table content recording routine

    Indicator which recording routine should be used for changes to table contents.

    Dependencies

    Changes to a task can be recorded. This can be done either automatically or manually, depending on the client settings.

    A standard routine or an individual routine can be used as the recording routine. It is also possible to enhance the standard routine with individual routines.

    The individual routines must be defined as events. The definition is made via the menu function Environment -> Events and concerns the events 10, 11 and 12.

    The recording depends upon the client setting. The following settings are possible:

    1. Changes without automatic recording

    Changes are not automatically recorded. It is, however, possible to make manual recordings.

    2. Automatic recoding of changes

    All changes are automatically recorded.

    3. No changes allowed

    Changes can not be made, it is, however, possible to record table contents manually for the transport.

    4. No transport allowed

    Changes can be made here, but they can be neither automatically nor manually recorded for the transport.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2008 at 10:07 AM

    Table maintenance generator helps us in providing user entr screen for the data maintenance of that table.

    Record routine basically tells us if the changes are recorded or not.

    Compare flag

    This flag indicates whether the maintenance transaction allows the (checked) activation of Business Configuration Sets (BC Sets), and the adjustment. This is the case if the maintenance transaction can run in the background.

    Rgds,

    Hema

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2008 at 10:14 AM

    Hi,

    Please find below answers :

    1) what is utility of table maintenance generator ?

    You can insert, delete and modify values into the table directly.

    2)what is meant by maintenance type ?

    Table maintenance dialog maintenance type

    Table/view maintenance type key.

    Use

    In one-step maintenance only one maintenance screen (overview screen) is processed at run time. Entries are displayed here in the form of lists. An entry should be able to be displayed in one line of the screen.

    In two-step maintenance an additional maintenance screen (single screen) is processed at run time, as well as the overview screen. A single entry is displayed on the single screen. The single screen can be called from the overview screen by function key, for every entry.

    3) what is recording routine and comparing flag ?

    Recording Routine

    Indicator which recording routine should be used for changes to table contents.

    Dependencies

    Changes to a task can be recorded. This can be done either automatically or manually, depending on the client settings.

    A standard routine or an individual routine can be used as the recording routine. It is also possible to enhance the standard routine with individual routines.

    The individual routines must be defined as events. The definition is made via the menu function Environment -> Events and concerns the events 10, 11 and 12.

    The recording depends upon the client setting. The following settings are possible:

    1. Changes without automatic recording

    Changes are not automatically recorded. It is, however, possible to make manual recordings.

    2. Automatic recoding of changes

    All changes are automatically recorded.

    3. No changes allowed

    Changes can not be made, it is, however, possible to record table contents manually for the transport.

    4. No transport allowed

    Changes can be made here, but they can be neither automatically nor manually recorded for the transport

    Flag: Object can be adjusted

    This flag indicates whether the maintenance transaction allows the (checked) activation of Business Configuration Sets (BC Sets), and the adjustment. This is the case if the maintenance transaction can run in the background.

    For more information, see the Application Help for the table maintenance generator (transaction SE54).

    The following settings exist:

    • No Information

    The system does not know whether the maintenance transaction allows BC Set activation and adjustment.

    As with the setting "Not Adjustable", the content of the BC Sets is written to the Customizing tables without being checked.

    • Not Adjustable

    The BC Sets cannot be activated and checked. The maintenance transaction does not support the adjustment.

    The content of the BC Sets is written to the Customizing tables without being checked.

    Instead of an adjustment, you can only compare the views or tables with another client or system. Any modifications that arise from an adjustment must be made manually.

    • Adjustable in Dialog

    As with the setting "Not Adjustable", the content of the BC Sets is written to the Customizing tables without being checked.

    An automatic adjustment is not possible, however, you can compare the views or tables with another client or system, and adjust the differences (either all of them or a selection) with the dialog adjustment function.

    Automatically Adjustable

    BC Sets are activated with all field checks.

    The object can be adjusted automatically against another client as part of a Customizing import. This means that the data with differences can be imported from the comparison client. As well as the automatic adjustment option, the maintenance transaction also offers the dialog adjustment function.

    Thanks,

    Sriram Ponna.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2008 at 10:15 AM

    Hi,

    what is utility of table maintenance generator ?

    Once table maintenance generator is generated , a transaction can be created for it, thus entries in the table can be created/modified using that transaction.

    This is done b'coz in production system, we cannot generally create data through se11, as we do not have authorization for it.So only to specific users who need to insert data into these table, authorization for the transaction is given and for others they can only view the data.

    Regards,

    Soumya.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2008 at 10:20 AM

    hi

    good

    table maintenance generator->

    Table Maintenance Generator (TMG) is a tool which is used to create a equipment by which customized tables created by end users can be changed as required,such as making an entry to that table,deleating an entry etc.

    SM30 is the transaction code to create table maintenance generator.

    Maintenance Type->

    http://help.sap.com/saphelp_nw2004s/helpdata/en/c5/e4afe6453d11d189430000e829fbbd/content.htm

    thanks

    mrutyun^

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2008 at 10:41 AM

    Hi

    Hope it will help you.

    <REMOVED BY MODERATOR>

    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

    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.

    Edited by: Alvaro Tejada Galindo on Aug 15, 2008 3:44 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 19, 2008 at 06:33 AM

    Hi Sir ,

    Please have a look below .Hope it is suitable and simpler solution for your question.

    <REMOVED BY MODERATOR>

    Thankx.

    Go to SE11, give the table name and click on change. Then Go to utilities--> Table maintenance generator.

    In the table maintenance generator screen, we should give Authorization Group, Function Group name (Function Group name can be same as table name), Maintenance type can be one step or two step, usually we will create with one step. we should give maintenance screen number. After clicking on create button, a table maintenance generator will be created.

    To check it go to SM30 . In SM30, we find display, Maintain options.

    We can view the table contents by choosing Display and we can create table entries by choosing Maintain.

    Why we have to go for Table maintenance generator, when we can edit the table by SE16 or SE11, utilities->create entries?

    In the production system, end-users will not be having access to transaction codes like SE11 and SE16. Developers will not be having access to many transaction codes including the above two.

    To view the contents of the database table, we will use SE16n in Production system. Please find out the difference between SE16 and SE16n.All these authorizations will be maintained by BASIS team, by creating access profiles.

    So in order to edit or create the contents of a database table, we should go for table maintenance generator. In real time, authorizations will be maintained in production system. (even in development and Test systems to some extent).

    There is an audit like Sarbanes-Oxley Act for American clients, where every thing will be audited by government agency. To know more about SOX, use the links on the right hand side of this page.

    The second reason is, we can edit or create multiple entries at a time, using table maintenance generator.

    Apart from that we have options like 'Enter conditions' in table maintenance screen SM30. Please try to find out the use of those, by creating an example.Table Maintenance generator: Difference between one step and two steps.

    While creating table maintenance generator, we find below options:

    1. When we choose one step, we have to give the screen number in Overview Screen field.

    2. When we choose two step, we have to give both overview screen number and single screen number.

    You can give any number for screen. Don’t give 1000 screen number. As this number is reserved for selection screen.

    When we choose two step, two screens will be created for table maintenance. For single step only one screen will be created.

    When we choose two step, table maintenance will work as follows:

    Go to SM30, give the table name for which you have created table maintenance-

    Overview screen will be displayed. To create entries, when you click on ‘new entries’.

    Another screen will be displayed, where you give input and save.

    You can enter one record at a time.

    We use single step generally, as it is user friendly.

    To completely understand the difference and above points please do exercise by creating table maintenance generator in both ways (using single step and two step).

    <REMOVED BY MODERATOR>

    Edited by: Alvaro Tejada Galindo on Aug 15, 2008 3:45 PM

    Add comment
    10|10000 characters needed characters exceeded