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, create the table in ABAP Dictionary SE11.
Select “A” (Application table) for Delivery Class and “Display/Maintenance Allowed” for Data Browser/Table View maintenance under Delivery and Maintenance tab.
Moreover, Add some field line for table.
Later on, we click Technical Settings button and fill in the blanks just like the following screen. We write “APPL0" for Data Class and “0” (Zero) Size Category. If all is okey, click REVISED <-> ACTIVE and SAVE buttons in order.
And go to Menu Utilities –> Table Maintenance Generator.
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 Table Maintenance Generator. Select “One Step” for Maintenance type like following screen.
And click on left corner CREATE button on application toolbar. Select Propose screen numbers and click on continue. The screen number for overview screen will be automatically populated.
Table maintenance program is created. Now to maintain entries in the table, go to Maintain Table Views (SM30),write table name and show what we do but this is not user friendly, for this reason we create unique transaction code for this table. Go to SE93 and create new transaction code.
In this Maintain Transaction SE93 screen, ABAP developers or SAP users can edit or change an existing transaction code as well as create SAP transaction code.
As you can see in the below screen, I want to create a new ABAP transaction code “ZAACAR01” for calling a Table Maintenance. So I type the new SAP transaction code in the text input area. Then click Create button to create the new transaction code.
Following screen enables SAP users to enter a short text description for the new SAP transaction code.
Among the Start object radio buttons, select the Transaction with parameters (parameter transaction) for calling a Table Maintenance using this new SAP transaction code.
After transaction attribute short text is entered in Create Transaction screen click the green OK button or press enter to continue for SAP transaction creation.
In this part,we looking some important ones. We write SM30 for Transaction part, click all checkbox in GUI support part and finally we write table name and add update “X”. If all of done, click save button and transaction code was created.
SAP users are now ready to use the new SAP transaction code “ZAACAR01”. Type the transaction code and navigate to the new screen by calling the transaction report behind the scene.
Thank you for reading. Stay tuned!
What do you guys think? I love to know your thoughts. Kindly like, share or comment below.