Skip to Content
Author's profile photo Jitendra Soni

View/Maintain subset of data in Table Maintenance Generator

Many times the number of records in table maintenance increases so large that it will become difficult to maintain them. Using subset, it would be easy to maintain those records.


  1. Create a table for which you want to create TMG.


   2.Create table maintenance generator.

Step 2.JPG

3. Create transaction for table maintenance.

Step 3.JPG

Enter all the information

Step 3_1.JPG

                 Choose the UPDATE_LTD option instead of UPDATE.

UPDATE -> Will show all the records.

UPDATE_LTD -> Will show limited (LTD) records based on the values enter in popup.

Step 3_2.JPG

Step 3_3.JPG

Now save the transaction.

4. Execute the transaction.

Step 4.JPG

It will give you popup to enter criteria for maintaining/modifying data.

Step 5.JPG

Select all & proceed

Step 5_1.JPG

Now it is asking for filter values.

Step 5_2.JPG

Say I enter nothing in any parameter and go ahead. So it will show all data.

Step 5_3.JPG

Now I maintained 5 records & come out of transaction.

Step 5_4.JPG

Again execute the transaction and filter on the Roll no.

Step 5_5.JPG

I want to see details from 10 to 30.

Step 5_6.JPG

It will only show me those records which satisfies the criteria.

Step 5_7.JPG

Say I click on “New Entries” and tries to maintain records for Roll no 60 .

System will throw an error because value 60 does NOT satisfies the work area condition (which is 10 to 30). So it will not allow me to maintain that record.

Step 5_8.JPG

So using the option UPDATE_LTD, we can maintain relevant records, no need to see all the records.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good One.