Create SAP Transaction to Maintain ABAP Table using SM30
ABAP developers can create new transaction code which call SAP SM30 Maintain Table Views tcode to prevent direct call of SM30 by SAP user. If you do not prefer to give permission to your SAP users to run SAP SM30 transaction, an ABAP developer can create a new SAP transaction which will run SM30 in the background behind the scenes.
This ABAP tutorial shows how to create transaction code to execute SM30 to maintain ABAP tables by SAP users.
Before we start our SAP tutorial, I assume that you have already create ABAP table in your development SAP system.
I created a dummy local object user table named ZUSERTABLE for this tutorial.
I also create the table maintenance dialog screen using the SE11 screen menu "Utilities > Table Maintenance Generator"
After I activate the table and generate the table maintenance dialog screens, I can display and maintain ZUSERTABLE ABAP table content using SAP SM30 transaction code.
Let's now create new SAP transaction which differs a little bit from the referenced ABAP tutorial.
First of all, call SE93 SAP transaction.
SE93 transaction code will display the Maintain Transaction screen.
Enter a non-existing new tcode in Transaction Code textbox on the screen.
For example, I use ZUSERTABLE_SM30 for test purpose.
Press on Create button to continue transaction code creation process
The following screen in transaction code generation wizard, the type of the new SAP transaction will be defined. This screen is important. ABAP programmer will not continue with default option but choose Transaction with parameters (parameter transaction)
Press Enter or Continue button for following step.
If you select Transaction with parameters (parameter transaction) in previous screen, following transaction code create dialog screen will be shown.
Please pay attention to areas where marked with red borders.
First of all the new transaction will call SM30 tcode which I provided in Default values for Transaction textbox.
An other important customization on above screen is, ABAP developers should add two new parameters namely UPDATE and VIEWNAME. The ViewName parameter defines the target ABAP table which will be maintained via SM30 using the new SAP transaction. The Update parameter provides the permission to edit the table content, not to display as readonly
Save the transaction.
Now you can call new created SAP transaction ZUSERTABLE_SM30 to maintain target ABAP table (defined in tcode properties) without SM30 call on the foreground.