Monday 28 May 2012

Basics of ABAP : Table Maintenance Generator and Its Events

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.




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. 

1 comment:

  1. Aw, this was a really nice post. Spending some time and actual
    effort to create a superb article… but what can I say… I put things off a lot and
    never seem to get nearly anything done.
    My webpage ; chicago pool table movers

    ReplyDelete