Maintenance dialogue

[Former Member]

Hi all,

What is maintenance dialogue?

I have added a field to the table and then transport it to the productive system.

What happened is that: System 099 is set to 'Not modifiable' when I have typed sm31 and want to add records into table?

What is happening, I was able to add record into this table just before the modification.

Thanks.

[Former Member]

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.

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.

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).

[Former Member]

hi check this..

/people/community.user/blog/2007/01/07/transport-table-entries

regards,

venkat

[Former Member]

Hi,

You can generate database table and view maintenance dialogs to maintain customizing data. You can create, change and delete customizing data with these maintenance dialogs. You can also use maintenance dialogs for customer database table and maintenance views.

You can modify maintenance dialogs flexibly to your requirements by defining variants of an existing maintenance view, or adding your own modules to existing maintenance dialogs. You can make further functional enhancements at predefined events in the table maintenance dialog flow. You can collect related data from more than one table/view in a view cluster.

Use

The creation of table/view maintenance dialogs is described here. Maintenance dialogs can be created for SAP or customer tables or views.

There are two steps:

Define table/view

if the table or view does not yet exist.

Define maintenance dialog

Define table/view

The table/view is defined in the Dictionary. A view comprises a primary table and secondary tables which have a foreign key relationship to the primary table. Secondary tables can be

Dependent tables: These are auxiliary primary tables and have the same key as the primary table. All fields can be maintained directly. The secondary tables are linked by a foreign key with dependency factor "ID" and cardinality 1 or C, except for text tables, which must have dependency factor TEXT. The logon language is assigned to the language key when you save.

Referred tables: The primary table contains fields which belong to the referred secondary table. The secondary table can have other key fields which are not known to the primary table. The secondary table fields cannot be maintained, they can only be displayed. The referred secondary tables are linked by a foreign key with dependency factor OBL or OPT and cardinality CN or N. All other secondary tables which depend on the referring table, are also only referred tables for the primary table.

You can display the view structure graphically with the View hierarchy struct. function in the Utilities menu.

To create a table/view:

Choose view type Maintenance view.

All primary table key fields must be in the view definition.

The client field must be included for client-dependent tables/views. The field is not displayed in the maintenance dialog.

The language key must not be included for secondary text tables. The logon language is automatically used in maintenance.

The key fields must be defined before the function fields. Function fields and key fields must not be mixed.

Fields of a referred table cannot be maintained and have the maintenance attribute 'R'.

Each field can have a maintenance attribute.

You can specify the maintenance status of the entire table/view with the Maintenance status option. You can:

read only

read, change, delete and create (default setting)

read and change

read and change (time-dependent views)

In time-dependent views, the key comprises a time-independent part and the validity range. Choosing read and change (time-dependent views) restricts maintenance to changing and creating the validity range of existing keys.

Define maintenance dialog

You must specify the following parameters in the maintenance dialog definition:

Function group: the function group in which the tables/view-specific maintenance dialog components are generated. The function group is created if necessary.

Authorization group: the users who are authorized to maintain the table/view contents.

Maintenance type: one or two-step dialog. One-step dialogs comprise only an overview screen containing all fields. In two-step dialogs, only the key and text fields with a length of more than 20 characters are displayed in the overview screen. All fields are offered in the detail screen.

Maintenance screens: the internal number of each maintenance screen. You can get possible values in a search function.

Recording routine: Specify whether and how the table/view contents maintained with the dialog are put in a transport.

Result

The maintenance dialog is generated after all values have been entered. If there are no errors, the dialog can be used immediately to maintain table/view contents.

Reward If Helpful