Table Maintainance

Tcodes
SE11 : Viewing Table
SE16 - Viewing Table Data
SM30 - Table Maintenance


Creating Maintenance View
Go to SE11 --> Utilities --> Table Maintenance Generator
It takes you to the below screen.

Technical Dialog Details
Enter 'Authorization Group' 'Function Group' and Package(gets added directly based on function group) .

Maintenance Screens
We can type how steps we need while creating entries. You can choose either One step or Two steps. check them individually and see which satisfies your needs better.

Assign the overview screen and single screen numbers. One step needs onyl Overview screen number.  You can use 'Find Scr. Number(s) from the top of the screen to check the previously used numbers and available ones.
Each Function group has its own screen number.

Dialog Data Transport Details
***Use the default.

Click on create and the table maintenance generator is created.
Go to SM30 and add entries.


Note
When creating the table, 'Delivery and Maintenance' should be 'Display/Maintenance Allowed'

Whenever you are adding a new field / removing field, Table Maintenance needs to be regenerated.

      

Common Warnings/Errors

• SM30 gives error after moving transport to different system
• When table maintenance is generated, it also creates 2 FMs under a function group and if the function group entries are moved, system doesn't allow us to maintain values.

• View/table ZTEST_TABLE can only be displayed and maintained with restriction
• When creating the table, 'Delivery and Maintenance' should be 'Display/Maintenance Allowed'

Transporting table entries ( when transport is not asked by default )

Go to SE09

Select you task and enter as follows

Program ID : R3TR

Object Type : TABU

Object Name : <Table name>

 

Click on (Object with Keys ) icon and it takes you to the screen with table entries

You can entry under table Keys. The main screen only gives the key field value to be entered. Internally, it collects the whole entry.

If you want to check the whole entry, click on table entries you can actually select the how you want to see the entries.

Once the entries are entered, you can see them all under the task. The table entries cannot be locked by the transport unlike programs and other other objects.