table maintenance generator

[Former Member]

what is utility of table maintenance generator ?

what is meant by maintenance type ?

what is recording routine and comparing flag ?

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[soumya_jose3]

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.

[Former Member]

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^

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Ooopsie...doopsiee... shouldn't have used the big-gun....

[Former Member]

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