Thursday, April 9, 2020

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.