Create Table Maintenance Generator

Updated May 19, 2018

How to Create Table Maintenance Generator?

Go to SE11, give the table name and click on change. Then Go to utilities--> Table maintenance generator.

In the Table maintenance generator (TMG) 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.

Read more here SAP ABAP Tutorial

Comments

05 Apr 2008 9:31 am Guest Helpful Answer
If we are creating a Maintanance Generator for a DB tab , does is means that for that DBTab in se11 under tab Delivery and Maintanance we should choose Disply/Maintanance Not Allowed?
I mean what is the basic purpose or benifit of using a tabloe maintanance generator?

Vivek.

15 Feb 2009 1:26 pm Guest
u had to select table maintanance allowed, it is used to update and delete records from the table
cheers
uday

22 May 2009 6:04 pm Guest
Hi Vivek,

If you dont want the user to maintain the table contents, or if you dont to create entires and maintain the same using Data Browser (SE16) you can set the display maintainance not allowed. With this you can maintain data in the table consistently.

You use the table maintainance generator to maintain the data using the SAP Generated Function Modules. You need to take care of the SAP Locking mechanism to Create Update and Delete entries in the Table. Through Table Maintainance Generator you can achieve all of these.

24 Feb 2010 5:30 am Guest
Hi,
If we maintain table entries through table maintenance then can we update the entries in that table using MODIFY/UPDATE/INSERT/DELETE commands through a report or FM.
so,u can help to me about create the table in sao for abap.
sonali

07 Jun 2010 8:35 pm Guest
What is the difference between ZTable ( Add, Delete, Modify ) and Table maintenance Generator , both of them has the same features , then what is the major difference.
obaid ur rahman
hyderabad.

20 Oct 2010 10:15 am Guest
what is the maintenance screen no?

25 Nov 2010 8:19 am Guest
what is the use of authorization group and function group in table maintenance generator

10 Dec 2012 1:10 pm Guest
how maintain single table ?....

14 Dec 2012 5:19 am Guest
list of users who are authorized to run that table is authorization group.
function group is used to store the function modules.