TMG (Table Maintaince Generator)

TMG (Table Maintenance Generator) :

• Table Maintenance Generator is used to insert, update and delete the data of data base table without any code (without DML Commands).
• Table Maintaince Generator is only possible for custom tables.
• The transaction code for TMG is SM30.

Step to Create TMG:
Note : I Already create table if you don't know how to create Transparent table then please follow the link.
http://abaptutorialspot.blogspot.in/2018/01/create-transparent-table.html

Execute SE11

Provide Data base Table Name and Click on change.

Click on Utilities and click on Table Maintenance Generator

Provide Authorization Group &NC&(Default Group), Provide Function group same as Data base Table Name, Select Radio Button One step or two step base on requirement and provide screen number and click on Create

Note: If you select single screen then Provide only one screen number (9000) or if you provide two step then provide two screen number.

Click on Create

Save in our package or local object

Click on save and back button.

Execute SE93

Provide Transaction Code and Click on Create Button.

Provide Short Description and Select the Radio Button Transaction with parameters.

Provide Transaction SM30 and check Skip initial screen check box.

Select all GUI Check Box.

Scroll down and Provide VIEWNAME as Data Base Name and UPDATE = 'X'

Click on SAVE Button

Save the Transaction in Package or Local Object

Now Execute Transaction: ZTRANSACTION

Now you see the + if you want to give the name then in MENU Bar Click on System and select Status.

Double Click on the Screen 9000

Now click on Layout

In Screen Painter Screen is coming and click on Edit, Double click on + Symbol provide the Name

Provide Name in Text

Click on save button and back button.

Activate Screen and Click on Back Button

Once again Execute Transaction and you can see Name is showing.