What is SAP Table Maintenance Generator?

SAP Table Maintenance Generator (TMG) is a tool to generate a table maintenance program i.e. it will generate a program to maintain (Create, Edit & Delete) entries in a table.

To generate a table maintenance generator (TMG)  for a table, display the table in ABAP Dictionary (SE11).

TMG-0

Select “Display/Maintenance Allowed” for Data Browser/Table View maintenance under Delivery Maintenance tab.

TMG-1 

Go to Menu Utilities –> Table Maintenance Generator.

TMG-2 

Enter the proper authorization group (&NC& is without any authorization) and function group. If the entered function group does not exist, it will create a new function group to store the dialog modules of TMG. Select “one step” for Maintenance type and click on “Find Screen Numbers” on application toolbar.

TMG-3

Select Propose screen numbers and click on continue.

TMG-4

The screen number for overview screen will be automatically populated. Now click on CREATE icon on application toolbar.

TMG-5

Assign TMG and function group to proper package and save.

TMG-6

Table maintenance program is created with the above message in the status bar. Now to maintain entries in the table, go to Maintain Table Views (SM30).

TMG-7

In SM30 enter table name and click on maintain.

TMG-8

Click on New Entries button on application toolbar to maintain new entries in the table.