table

[Former Member]

what is the need of table maintenance option in the beginning of table creation?

[Former Member]

Option specifies whether it is possible to display/maintain a table or view using the maintenance tools Data Browser (transaction SE16) and table view maintenance (transactions SM30 and SM31).

If you specify

Display/maintenance not allowed

#1 Maintenance and display of this Dictionary object is not possible in transaction SE16.

#2 Transaction SE54 does not allow the generation of a maintenance dialog, which means automatically that calling transactions SM30/SM34 for this Dictionary object is no longer possible.

Display/maintenance allowed to limited extent

#1 Transaction SE16 allows the display function for this Dictionary object, but no maintenance.

#2 Generation of a maintenance dialog for this Dictionary object is possible using transaction SE54

#3 Transaction SM30 does not allow maintenance and display functions for this Dictionary object

Display/maintenance allowed

#1 Transaction SE16 allows the maintenance and display functions for this Dictionary object

#2 Transaction SE54 allows the generation of a maintenance dialog for this Dictionary object

#3 Transaction SM30 allows the display and maintenance functions for this Dictionary object.

Hope this helps

Vinodh Balakrishnan

[Former Member]

hi kaladhar,

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.

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.

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.

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.

plz reward if helpful.

regards,

srikanth