Re: TABLE MAINTENANCE GENERATOR
Posted: Feb 11, 2008 10:42 AM in response to: siva kumar E-mail this message Reply
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.
Bluesky
