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

Sub:table maintenance generator

Former Member — Tue, 08 Jul 2008 17:39:42 GMT

hi guru's,

Can u explain me ,what is the need of table maintenance generator and how it will effect our tables.what is authorization group and functional group in it.what are the options i have to select in that.

thank you,

Re: Sub:table maintenance generator

bpawanchand — Tue, 08 Jul 2008 17:48:42 GMT

As all of you know, we can create database tables in SAP using transaction code SE11. A table can be manipulated by a program or manually.

When creating table, you will find a check box 'Table maintenance allowed'. If we check that option, we can manually enter entries using SE16 or table maintenance generator screen.

SE16 is for data browser.

further reference

http://sapstore.blogspot.com/2006/11/table-maintenance-generator.html

Regards

Pavan

Re: Sub:table maintenance generator

uwe_schieferstein — Tue, 08 Jul 2008 19:51:48 GMT

Hello Sravan

In order to allow users to enter data into DB tables you need a corresponding maintenance view.

Most of the SAP standard customizing tables (transaction SPRO) are maintained via maintenance views.

A maintenance view consists of a DDIC object and dialog modules and screens which are stored within a function group.

If you define authorization group &NC& (= no authorization required) for your maintenance view every user who can call transaction SM30 can maintain records. If this is not intended you need to use either a standard or custom authorization group.

In general I recommend to create a separate maintenance view instead of defining the maintenance dialog for the table directly (which is also possible).

Regards

Uwe

Re: Sub:table maintenance generator

Former Member — Wed, 09 Jul 2008 04:22:32 GMT

Hi,

The main purpose of Table Maintenance Generator is to

Create/Change/Delete the table entries with out writing any

code. When ever we create table maintenance generator it

will generate a standard program.

Please use the following link which explains you step by step procedure to create a table maintainance generator.

http://saptechnical.com/Tutorials/ABAP/TableMaintenance/demo.htm

Thanks,

Naveen Kumar.

Re: Sub:table maintenance generator

Former Member — Wed, 09 Jul 2008 04:33:27 GMT

Hi Sravan,

Hi,

By creating the table maintenace generator only u can display those fields.

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

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.

If Found Help Full Do Reward.

Regards.

Eshwar.

Re: Sub:table maintenance generator

Former Member — Wed, 09 Jul 2008 04:44:07 GMT

hi,

table maintenance genartor..

1>go to t-code: sm30

2>enter the table name there...for which u want 2 create table maintenance..

3> click maintain..

4> on the next screen...go to create option....

5> give authorization group as : &wc&..the very first option...

6> give one step..radiobuton...

7> overview screen as 1...

8> create a function grp/or gve table name as func grp....

and simply create table maintenance...

this table maintenance can b directly created through utilities in the table itself...there is an option of table maintenace genartor....

the saem screen appears there also...

reward if helpful....

Re: Sub:table maintenance generator

Former Member — Wed, 09 Jul 2008 05:48:48 GMT

Hi,

In order to do the manual enteries on the tables table mainteinance generator is created so that one can do any kind of modifications on the table enteries.

Assign points if helpful.

Regards,

Amit

Re: Sub:table maintenance generator

Former Member — Wed, 09 Jul 2008 05:50:02 GMT

Hi sravan,

Table Maintenance Generator 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.

How to create TMG was already described in the previous threads.

Hope it clear ypur doubts.

Reward if it helps you.

Thanks

Re: Sub:table maintenance generator

Former Member — Wed, 09 Jul 2008 10:31:40 GMT

Hi,

Throught Table Maintenace generator you can perform DML operation on the Table like INSERT, UPDATE and DELETE.

If you run this tool then the datarecords of the table is displayed in the form of spreadsheet like EXCEL.

To run the Table Maintenance generator, authorizarion is required in real time.

SM30 is the Transaction code or you can go for this option in UTILITY menu.

Rest is same as other techies sujected...

With Regards,

Rupinder

Re: Sub:table maintenance generator

Former Member — Wed, 09 Jul 2008 10:41:24 GMT

Hi sravan,

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

Check these links out

http://help.sap.com/saphelp_bw21c/helpdata/en/21/153ed1d08711d2960f0000e82de14a/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

Best of luck,

Bhumika

Re: Sub:table maintenance generator

Former Member — Thu, 10 Jul 2008 05:32:19 GMT

Hi,

Table Maintenance generator is required to do Manual entries in the Table.

If the requirement is to update the table only programmatically

and not manually then table maint generator is not required.

Manual entries in table can be maintained ( New record can be inserted / existing can be modified )

using transaction SM 30, if the table maintenance for the table is generated.

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

How to activate Table maint.

Goto SE11 and open the table.

Click UTILITIES -> Table Maint. Generator, Enter the details and click on Save. Then activate the table.

Thanks,

Khushbu.

Re: Sub:table maintenance generator

Former Member — Fri, 11 Jul 2008 18:07:01 GMT

i got excellent answers