Table maintainance generator

[former_member549415]

hi all.

Why we use Table maintainence generator..?

thank you.....

[Former Member]

Hi Somnath,

Table maintainence is used to maintain the custom tables.

Using table maintenence you can insert, modify, delete and perform all other tasks related to tables.

You can create the table maintenence using se11--> zXXX(table name) >utilities> table maintenance generator. and create your table maintenance for your custom table.

If you want to validate the fields of the table[for eg., employee no. should start with 'E'],you can write your own validations in the program if you generated table maintenance.

Please check the following links

Have a look at SAP help on generating a table maintenance dialog.

http://help.sap.com/saphelp_47x200/helpdata/en/91/ca9f0ea9d111d1a5690000e82deaaa/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

http://help.sap.com/saphelp_webas630/helpdata/en/06/395e3c80530f6be10000000a11405a/frameset.htm

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

Authorization Group in Table maintenance

http://help.sap.com/saphelp_47x200/helpdata/en/a7/5134d2407a11d1893b0000e8323c4f/frameset.htm

u can go to se54 and do the same.

with this we are generating a maintanance dialog (screen)

which is an interface to mainatain (update) tables using sm30.

single step:Only one maintenance screen is processed during extended table maintenance. The entries are displayed in list form on this screen.

two step:Two maintenance screens are processed during the extended table maintenance:

On the Overview screen the entries are displayed in list form.

On the Single screen one entry is displayed. The single screen can be called from the overview screen, by function key, for every entry.

<b>Reward points if this helps.

Manish</b>

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

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]

Hi,

We can create entries into table , directly from se11utilitiescreate entries, but why we are using table maintanace generator is because , after development server the things will transfer to testing and then to production there u can not access to se11 and se16 to get go thru the table and make changes here we have to check se16n.so, we go for table mainatance generator.

Regards,

kavitha.k

[Former Member]

HI somnath,

If you are using ECC6.0 then there will bit less use of table maintenance generator. I mean when you create a relation between 2 tables through foreign key then in the case of 4.7 you have generate table maintanence then only the records entry will be correct according to the parent table.

Overall TMG is used to create a screen where we can enter multiple entries in table rather than one one entry at a time.