What is requirement of table maintenance generator .

[Former Member]

Hi Experts .

What is purpose of applying Table maintenance generator for a Ztable ?

in Which scenrio it is required ?

what is the Harm if a table do not holding Table Maintenance generator .?

Regards : rajneesh

[Former Member]

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

Why we have to go for Table maintenance generator, when we can edit the table by SE16 or SE11, utilities->create entries?

In the production system, end-users will not be having access to transaction codes like SE11 and SE16. Developers will not be having access to many transaction codes including the above two.

To view the contents of the database table, we will use SE16n in Production system. Please find out the difference between SE16 and SE16n.All these authorizations will be maintained by BASIS team, by creating access profiles.

So in order to edit or create the contents of a database table, we should go for table maintenance generator. In real time, authorizations will be maintained in production system. (even in development and Test systems to some extent).

There is an audit like Sarbanes-Oxley Act for American clients, where every thing will be audited by government agency. To know more about SOX, use the links on the right hand side of this page.

The second reason is, we can edit or create multiple entries at a time, using table maintenance generator.

Apart from that we have options like 'Enter conditions' in table maintenance screen SM30. Please try to find out the use of those, by creating an example.Table Maintenance generator: Difference between one step and two steps.

While creating table maintenance generator, we find below options:

1. When we choose one step, we have to give the screen number in Overview Screen field.

2. When we choose two step, we have to give both overview screen number and single screen number.

You can give any number for screen. Don’t give 1000 screen number. As this number is reserved for selection screen.

When we choose two step, two screens will be created for table maintenance. For single step only one screen will be created.

When we choose two step, table maintenance will work as follows:

Go to SM30, give the table name for which you have created table maintenance-

Overview screen will be displayed. To create entries, when you click on ‘new entries’.

Another screen will be displayed, where you give input and save.

You can enter one record at a time.

We use single step generally, as it is user friendly.

To completely understand the difference and above points please do exercise by creating table maintenance generator in both ways (using single step and two step).

Reward if Helpful

[Former Member]

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.

Reward points..

[Former Member]

Hi,

Table maintanance Generator is used to manually

input values using transaction sm30.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

follow below steps

go to se11 check table maintanance check box under

attributes tab

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.

select maintaience type as single step.

maintainence screen as system generated numbers

this dialog box appears when you click on create

button

save and activate table

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

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.

please check the link for getting information about table maintenance generator !

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=use%20of%20table%20maintenance%20generator&cat=...

http://www.sapdevelopment.co.uk/tips/tips_tabmaint_tcode.htm

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

Regards,

Satish

[Former Member]

Hi,

Table maintenance generator is used to create screen to maintain values in a table. Once you create maintenance generator, you can goto transaction SM30 and add data to table .

Check the following blog on table maintenance:

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

Check the following link table maintenance:

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

Refer

https://forums.sdn.sap.com/click.jspa?searchID=10856418&messageID=4805352

Regards

Kiran Sure

[Former Member]

Hi,

1.For multiple records Update or modify , we need table maintenace generator.

2.Without Table maintenace generator,The performance can decrease by every time hitting the database , the Ztable.

3.Not only that for end user purpose also.The end user directly cann't update the Ztable.

4.So better to use Table maintenace.

Regards,

Shiva Kumar(Reward if helpful).

[Former Member]

Table maintanance generator is nothing but we can give access to enduser to edit/insert/delete records from the table within his prod dept.For that we have to give authorization to him to do maintanance in his place.So after creating a table in SE11 just go to SE54 and give authorization for that table and activate.

It is useful whenever he wants a table in his production itself instead access from dev..so we have to move this table to prod...so at that time you just include this table in SM30 and create one transaction in SE93 for this table parameters...so when you give tcode to enduser he may have both table and table contents via tcode...if he wants any changes he directly change without interacting with dev guys...this is the main purpose...

Reward if it helpful.

Dara.