Table maintenance generator is a user interface tool which is used to change the entry of the table or delete an entry from the table or create an entry for the table. Without Table maintenance generator, we cant' change the table entries directly in the system. we can change the data in a table only through the program.
While creating the database table, we need to maintain the flag in the 'Delivery and Maintenance' tab, the 'Table View Maint.' should have the "Maintenance allowed" property defined.
Creating TMG (Table maintenance generator):
Go to SE11 and create a table with the fields as per the requirement.
In table change mode, click on Utilities and then click on Table maintenance generator.
Go to SE11 and create a table with the fields as per the requirement.
In table change mode, click on Utilities and then click on Table maintenance generator.
Following are the available options available for the users
Authorization Group: this option is to provide authority to certain users to maintain the data, if it is not needed fill it as NC.
Maintenance screens: Maintenance can be done in 2 ways
1. Maintenance and Overview both on one screen
2. Maintenance on one screen and Overview on another screen.
In table change mode, click on Utilities and then click on Table maintenance generator.
Implementation of table maintenance generator for a custom table:
Go to SE11 and create a table with the fields as per the requirement.
In table change mode, click on Utilities and then click on Table maintenance generator.
Following
screen will be displayed for setting up the Maintenance generator
Following are the available options available for the users
Authorization Group: this option is to provide authority to certain users to maintain the data, if it is not needed fill it as NC.
Function group this is the function group under which the maintenance
function module will be generated.
Maintenance screens: Maintenance can be done in 2 ways
1. Maintenance and Overview both on one screen
2. Maintenance on one screen and Overview on another screen.
Maint. Screen number : A screen number should be given, if it is a
single screen, only one screen is enough. If there are 2 screens you need to
provide 2 screen numbers.
Please note that when this table maintenance generated, It will
generate screens under the function group hence the screen number should not be
utilised already in the function group.
Dialogue data Transport details.
There are 2 options one is standard recording routine and the user
recording routine,
If you select the standard record routine then you will get a
option of storing the data under the transport request and move it across the
system.
After saving the changes, go to SM30 for maintaining the table.
