SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for SAP HANA and ABAP, HANA Database, SQLScript, SAP UI5, Screen Personas, Web Dynpro, Workflow

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.

create new SAP transaction using SE93 tcode

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.

new SAP transaction code

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)

new SAP transaction start object selection

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.

create new SAP transaction to maintain ABAP table using SM30

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.

maintain table with specific tcode

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.

maintain ABAP table in SAP using new transaction code



SAP HANA and ABAP

Install SAP Free
CRM Companies List
Web Based CRM Software


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.