topic Re: Table maintainance generator in Application Development and Automation Discussions

Table maintainance generator

Former Member — Thu, 20 Sep 2007 06:37:20 GMT

what is Table maintainance generator. how to do that

Re: Table maintainance generator

gopi_narendra — Thu, 20 Sep 2007 06:42:28 GMT

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.

Regards

Gopi

Re: Table maintainance generator

Former Member — Thu, 20 Sep 2007 06:54:57 GMT

Maintenance Genarators

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.

Maintenance Status

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

The maintenance status can be defined as follows:

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.

Restrictions for Maintenance

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.

Reward if usefull

Re: Table maintainance generator

Former Member — Thu, 20 Sep 2007 06:54:58 GMT

Hi,

1. Steps to create table maintainance generator.

1. Display the table then go to Utilities then select table maintanace generator give below parameters.

Table/View ZXXXXX

Authorization groups ZXXX

Authorization object S_TABU_DIS

Function group ZXXXXX

Development class ZXXXXXX

Maintenance type One-step

Main. screen no. Overview screen 3

Single screen 0

Recording routine no or user recording routine

Compare flag automatically adjustable

2. After passing the parameters click on create button on top left it will show the CTS press enter.

3. One Step:-

Only one maintenance screen is processed during extended table maintenance. The entries are displayed in list form on this screen.

Two Step:-

Two maintenance screens are processed during the extended table maintenance.

After copletion of table maintanence generator go to sm 30 t_code then pass the table name,Click on maintain button then click on new entries then insert the records then create transport request and save it and transport to quality.

Reward points if it is useful....

Thanks & Regards,

Vasudeva Rao.

Re: Table maintainance generator

former_member196299 — Thu, 20 Sep 2007 07:18:40 GMT

Hi ,

Here you go with the details of table maintenenve generator :

Below is the process for generating table maintenance generator :

Go to se11

open the table

go to Utilities in the menu bar ->Table maintenance generator .

give the function group name which you want to link here .

give the authorization group name as &NC& if you are not aware of it .

Select Maintenance type as one step .

Provide maintain screen number ,say 1 .

Click on create.

Save the table maintenance generator , go back and activate the table again .

HOW TO USE table maintenance generator ?

Now go to txn SM30 , give the table name and click on maintain. Then you will reach to the maintain table screen.

Here you click on the new entries, and then fill the rows with needed values ..

Click on save for saving the values in the database.

Hope this will be helpful to you .

Regards,

Ranjita