Menu

How to Manage Table Maintenance Dialogs in SAP ERP

DevWorkbench    Sunday August 17th, 2014   

I want to write about table maintenance dialogs in SAP ERP a bit – partly because they’re one of the most-used features of SAP development, and partly because some of their better functionality is hidden quite well. Today, I’ll discuss the basics.

Generating a table maintenance dialog

Creating a table maintenance dialog for a table has many advantages. You can maintain data much more comfortable than via the Data Browser (SE16/SE16N) and it’s possible to use the SAP Change and Transport System to move table entries into subsequent systems. Moreover, there’s very useful advanced functionality, such as maintenance views or adding application logic to your maintenance dialog.

Test Table for Maintenance Generator

Test Table for Maintenance Generator

Let’s start with the creation of a maintenance dialog. The screenshot above shows you a test table I created – a simple table that lets me record additional text for company codes. To create a table maintenance dialog, select Utilities > Table Maintenance Generator from the menu bar. You’re taken to a dialog, where you have to provide details for the table maintenance dialog.

Generation of Table Maintenance Dialog

Generation of Table Maintenance Dialog

The following fields are available:

  • The authorization group is an object that can be provided if the access to table maintenance should be restricted by authorization. The user has to have the appropriate authorization for the object S_TABU_DIS. If you don’t want to restrict entries, enter the value &NC& here.
  • The function group is created automatically by the table maintenance generator. It will contain the necessary ABAP programming objects.
  • The maintenance type decides whether you can enter data directly in the table overview (one step) or if you have to double-click an entry to be taken to the detail screen (two step).
  • For the maintenance screen numbers, you should click Find Scr. Number(s) and then select Propose Screen Numbers to have the system select them for you.
  • The recording routine decides whether table entries have to be recorded in a transport request (standard Recording) or if you can make entries without a request (no recording).
  • The compare flag is relevant if you work with Business Configuration Sets. You can control the integration into these sets here.

After you’ve made your entries, click the Create icon (New Icon) to generate your table maintenance dialog. If everything goes well, you can now call transaction SM30 and enter your table name to be presented with a table maintenance screen where you can maintain the table’s content.

Table Maintenance with Transaction SM30

Table Maintenance with Transaction SM30

That’s it already – you can now maintain entries for your table. Read on to learn how to re-generate the table maintenance dialog if the underlying table changes.