topic Re: table maintenance generator in Application Development and Automation Discussions

table maintenance generator

Former Member — Mon, 23 Apr 2007 03:17:37 GMT

wat is the use of table maintainance generator?

use of sm30?

tell me details.dont give links.

vijay

Re: table maintenance generator

Former Member — Mon, 23 Apr 2007 03:21:19 GMT

Hi,

table maintenance generator is used to automatically generate screens for maintaining the entries of the table..

SM30 can used for maintaining the table entries if they have a table maintenence screen generated..

Thanks,

Naren

Re: table maintenance generator

Former Member — Mon, 23 Apr 2007 03:32:15 GMT

Hi Vijay,

table maintanance Generator is used to manually

input values using transaction sm30

When ever you create An custom table ( Z or Y ) Table, You have maintain that table to see the values, Where as for standard tables, it is not necessary.

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

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

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.

Regards,

Priyanka.

Re: table maintenance generator

Former Member — Mon, 23 Apr 2007 06:01:36 GMT

Hi Vijay,

Jus Check this link.

https://www.sdn.sap.com/irj/sdn/forums

Regards,

-->Suresh

Message was edited by:

Suresh Ramamoorthy

Re: table maintenance generator

Former Member — Mon, 23 Apr 2007 06:03:22 GMT

Hi Vijay,

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

Generally for inserting new records into custom table thru transaction SM30, we need to enter all the values manually and save the record.

When certain data for the key fields needs to be populated automatically while creating entries, the steps involved are:

Maintaining the subroutine in view V_TVIMF for a particular custom table.

Logic for extracting relevant data for the fields entered, when user press enter button.

Check this blog for more information on extracting data in table maintenance.

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

With the help of the table maintenance generator, you are able to maintain the ENTRIES of the table in SM30 transaction.

It can be set in transaction SE11 - Tools - Table maintenance generator.

Table maintenance Generator is used to manually input values using transaction sm30

follow below steps

1) go to se11 check table maintenance check box under attributes tab

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 maintenance generator to move table

contents to quality and production by assigning it to request.

4) Select maintenance type as single step.

5) maintenance screen as system generated numbers this dialog box appears when you click on create button

6) save and activate table

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.

SM30 is used for table maintenance(addition or deletion of records),

For all the tables in SE11 for which Table maintenance is selected , they can be maintained in SM30

Sm30 is used to maintain the table ,i.e. to delete ,insert or modify the field values and all..

It creates the maintenance screen for u for the particular table as the maintenance is not allowed for the table..

In the SE11 delivery and maintenance tab, keep the maintenance allowed..

Then come to the SM30 and then enter the table name and press maintain..,

Give the authorization group if necessary and give the function group and then select maintenance type as one step and give the screen numbers as system specified..

Then create,,,

Then u will able to see the maintenance view for the table in which u can able to insert and delete the table values...

We use SM30 transaction for entering values into any DB table.

First we create a table in SE11 and create the table maintenance generator for that Table using (utilities-> table maintenance generator) and create it.

Then it will create a View.

After that from SM30, enter the table name and Maintain, create new entries, change the existing entries for that table.

check these links --

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

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]

Hope this resolves your query.

<b>Reward all the helpful answers.</b>

Regards

Re: table maintenance generator

Former Member — Mon, 23 Apr 2007 06:25:56 GMT

Hi Vijay Reddy,

Go through this info.

With the help of the table maintenance generator, you are able to maintain the ENTRIES of the table in SM30 transaction.

It can be set in transaction SE11 - Tools - Table maintenance generator.

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

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.

SM30 is used for table maintenance(addition or deletion of records),

For all the tables in SE11 for which Table maintenance is selected , they can be maintained in SM30

Sm30 is used to maintain the table ,i.e to delete ,insert or modify the field values and all..

It creates the maintenance screen for u for the aprticular table as the maintenance is not allowed for the table..

In the SE11 delivery and maintenance tab, keep the maintenance allowed..

Then come to the SM30 and then enter the table name and press maintain..,

Give the authorization group if necessary and give the function group and then select maintenance type as one step and give the screen numbers as system specified..

Then create,,,

Then u will able to see the maintenance view for the table in which u can able to insert and delete the table values...

We use SM30 transaction for entering values into any DB table.

First we create a table in SE11 and create the table maintenance generator for that Table using (utilities-> table maintenance generator) and create it.

Then it will create a View.

After that from SM30, enter the table name and Maintain, create new entries, change the existing entries for that table.

Hope this resolves your query.

*************Reward all the helpful answers.

Rgds,

P.Naganjana Reddy

Re: table maintenance generator

Former Member — Mon, 02 Jun 2008 15:36:04 GMT

Hi , as understood we can maintain a ztable through sm30 . But does anyone have a report which when run can automatically update the ztable through this report. I mean can anyone if they have send me a report which when executed will fill the entered data in the selection screen to the ztable and update it automatically rather than updating it through sm30.

If yes , please help me as I ahve been asked to create a report to automatically update the records to a ztable through a report transaction. I have tried creating the report but its just updating the entreis that alerady exists in the tabel already and assign it a new date that is the todays date.

Thnaks for help.

Aarav.

Re: table maintenance generator

Former Member — Mon, 02 Jun 2008 20:06:12 GMT

Hi Aarav,

You should create your own thread.

Cheers, Heinz