TABLE MAINTENANCE GENERATOR

[Former Member]

HI

what is the use of table maintainence generator.

[Former Member]

hi siva,

if u want to create the SE16 functionality we can do it with the table maintenance generator..........

*if useful reward with points*

[Former Member]

Table maintenance is used to maintain the data for that table

Table maintanence generator is nothing but making a table available for adding records and deleting records. The transaction code used is SM30.

Follow below steps to create TMG.

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

using sm30 you can create entries manually.

[Former Member]

Hi siva kumar,

If you want insert more than one record at a time in to the database table you can insert through Table maintenance Generator. and it is used to maintain data through table control.

Plzz reward if it is useful,

Mahi.

[Former Member]

if we generate a table maintanance proram it iwll automatically generate module pool program and authorization checks will be taken care by that. validation also taken care by the maintanace program. it will take care of add,modifiy an deletion of the entries in the table.

in case of our own program we have to take care of all thos ethings like validation,authorization checks etc. it also time consuming.

[Former Member]

Hi,

To maintain(add, delete modify) more than a one record at time table maintenance generator is useful. It is like table control.

regards,

kamala.

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

Table Maintenance Generator is used to maintain the values of a table.Means we can add new records/entries and can even change the existing records.This is actually meant and easy for users.

We can also do this kind of activity through transaction SE16.But in realtime in Production environments, Users will not have access to SE16. So, through this table maintenance (transaction code:SM30) users can add or change the records in a table if there is a requirement to do so by getting proper approvals from their managers/management.

For example: A custom transaction is posting the invoice amounts to a GL account say 12345. For some reason the business want the amounts to be posted to a different account 12346.In this case, if we just change the GL account and save.From next time the invoice amounts will be posted to this GL account.So, there is no necessity to change any config or the code.

If you want to create table maintenance generator, please try like the following:

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.

Other useful links:

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

You can use the SM30 to maintain a table or you can create a separate custom transaction code for that table to maintain.

If you want to create a custom transaction to maintain a table,please try following:

Go to transaction code: SE93 and click on create.

Then select Parameter Transaction and give SM30 in the t.code in Default Values tab.

Check the checkbox Skip Initial Screen.

And In the default values, write:

VIEWNAME = (give your table name).

SHOW = X

Finally, save and use the new t.code to maintina your table.

[Former Member]

Table Maintenance is used to maintain the values of a custom table. Based on the requirements, one can change or add/delete the contents of the custom table.

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

reward if useful

[Former Member]

T.M.G is used actually to give entries more than one which will be highly useful for the enduser while giving entries.

well another use is T.M.G is used for checking the foreign key relationships between the tables while giving entries.

Simple steps to use T.M.G is after you create your table go to utilities T.M.G and give the authorization &NC& and create a function group by using SE37 and assign the created function group for that table. Save check and activate. Then again go to table activate again to remodify the objects. Then goto utilities create entries cheers you will get table entries where you can enter more than one. + symbols are visible for each column if you want to modify the + symbols with ur fields tell me i will give you the process.

[Former Member]

Hi,

It is mainly used for updating ztables. To maintain means inserting, deleting and updating the database tables. Generally updating database tables we are using standard applications XK01, MM01 etc. whereas ztables we need application program to update the ztable. Creating such application in modulepool is very time consuming. Intead of developing code youself, system generates code automatically by using table maitenance genrator.

Reward me if it is useful

[Former Member]

Hi Siva..

You can go thru this...

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

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.

[Former Member]

Hi,

one of the main things abt Table Maintenance Generator is authorisation group and auth object and the function group.

The authorization group allows extended authorization protection for particular objects. The authorization groups are freely definable.

Authorization objects enable you to define complex authorizations by grouping up to 10 authorization fields

reward if helpful,

teja.

[Former Member]

Hi,

Table maintenance generator is used to create the entries in the table. We means developers have the access only in SE11 in that also we have to enter one after one entry. But if TMG is maintained then the Production people enter the entries through SM30. Through TMG we can restrict by authorisation groups. There we are giving function group so system will create reports, includes etc. And also we can deside whether it is single step or two step. Then we can give the screen number in that it going to create a program.

Thanks

sarada