topic Re: regarding table maintainance generator in Application Development and Automation Discussions

regarding table maintainance generator

Former Member — Thu, 10 Jan 2008 08:51:13 GMT

what is the maintainance screen and what is the use of it

Re: regarding table maintainance generator

Former Member — Thu, 10 Jan 2008 08:53:06 GMT

Hi,

steps for table Maintenance

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

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.

You need to create a "Parameter Transaction".

What this means is that you will have a transaction (let's call it "ZMAINT") which calls "SM30" and passes in your table name.

Go to transaction SE93 and enter your new transaction code. Enter in the Tcode description and choose "Transaction with Parameters" (it shouldbe the last radio button).

Enter in the default transaction "SM30" and tick the "Skip Initial Screen" check box. Hit Enter.

Now scroll to the bottom of the screen and you will see a Table Control where you will need to enter in the values to the SM30 selection screen.

Because you hit ENTER, the program will have loaded in the Selection Screen parameters into it's memory. Hit the drop down for "Name of Screen Field" and select "VIEWNAME" and then enter in your Z Table in the "Value" column.

Now go to the next line and hit the drop down and select "UPDATE" in the "Name of Screen Field". Enter in a "X" in the value column.

Now save the transaction and there you have it.

You need to create a Parameter transaction - In SE93 while creating the tcode, specify the last option (Transaction with Parameters or Parameter Transaction).

In the subsequent screen, under the Defaults block, specify the transaction as SM31 and select the check-box 'Skip initial screen'.

At the bottom of this screen, in the list you would specify the following-

Name of screen field -

Values

UPDATE -

VIEWNAME -

Name of your table

Save all these.

http://www.sap-img.com/abap/create-a-table-maintance-program-for-a-z-table.htm

Regards,

Satish

Re: regarding table maintainance generator

Former Member — Thu, 10 Jan 2008 09:02:08 GMT

Hi naveen,

Table maintainance generator is used to maintain entries(data records) in table.

First you create table maintainance generator in SE11 for the table you want to maintain entries.

In SM30 you actually maintain entries for the table. You can also assign a transaction code for the table maintainance screen of the table in SE93.

Regards,

Archana.

Re: regarding table maintainance generator

Former Member — Thu, 10 Jan 2008 16:16:20 GMT

Table maintenance is used to maintain data in the tables created (ZTABLE).

We can use Table Maintenance generator is required to do user as manually in tabl e entries. suppose if we want to update a table automatically rather programatically u can go for tbale maintenance generator

*To create Table maintenance genetrator,

Follow the steps to create and maintain data

1) Goto SE11- > enter the table name

2) Utilities - > Table Maintenance 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

Regards,

Maha