sapdev logo background
sapdev logo sapdev logo

Creating transaction code for table maintenance (SM30)

Allowing access to table maintenance via a custom transaction code is fairly straight forward. Once the table maintenance has been generated for a specific database table you need to create a parameter transaction which will essentially call transaction SM30 and pass the relevant details of the table you want to maintain. See below for example

Step 1 - Create parameter transaction (i.e. via SE93)

Step 2 - Enter GUI support
If you see the option to select GUI support (newer systems) then select the appropriate ones you would like to use, usually just select windows.

Step 3 - Enter transaction code.
Now enter the transaction you want to execute (In this case it is SM30). Also Select the transaction radio button if using an older SAP system. You also get the option to skip the intial screen which I have ticked in this example so that the user is taken straight to the table view. We assign which table they are going to see in the below default/proposed value(step 4).

Step 4 - Enter transaction details.
Now within the Proposed/Default values section there are a number of values which can be setup, simply press the add(+) button and use the drop down menu to view the list. The 2 values assigned in this example are as follows:

	VIEWNAME 	<tablename>	Sets table name to be maintained
	UPDATE 		X	Open table for update

If you want the table maintenance to be display only, simply add the SHOW value equals 'X' instead update.
	VIEWNAME	<tablename>	Sets table name to be maintained
	SHOW		X		Open table for display

Step 5 - Update for newer gui screens.
Your SAP gui screen may look more like this but it is still basically the same so instructions as above are still valid

comments powered by Disqus