How-to find a maintenance dialogue for the SAP table

Dmitry Kaglik

February 2, 2015


No Comment

You already know from SAP Expert how to find a maintenance dialogue for values in a particular field in SAP transaction.

Today we will look at this question from a slightly different point of view. Say you don’t know the specific field, but you know the name of the configuration table that contains it. It is very likely you will be able to find the name of the configuration table in SAP forums, SAP Notes or any other resource. Can you actually maintain the table knowing only its name?

The generic answer is: use transaction SM30. You can either launch this transaction using its code, or by choosing menu System – Services – Table Maintenance – Extended Table Maintenance on any SAP screen.

Let’s look at several options to use this transaction.

  1. Direct maintenance in SM30

This is a very straight forward way to maintain the table. Put the table name into the only field on the screen and click the button “Maintain”.

SM30 - USR40
SM30 – USR40

You get directly into the maintenance screen of the table in question.

SM30 - USR40 - maintenance
SM30 – USR40 – maintenance

However, often you get the message “The maintenance dialog for … is incomplete or not defined” quoting your table name. It means that it is time to try option number 2.

  1. Find a customizing transaction in SM30

Put the table name into the field on the screen and click the button “Customizing”.

SM30 - T030K
SM30 – T030K

You will get a pop-up window where you can put an IMG project name for an additional search restriction, or “Continue w/o Specifying Project”. It is exactly the same window that is mentioned in points 2 and 3 of the previous article. Obviously, the results will be the same: you will get a list of IMG nodes where you can maintain the table in question.

However, even this approach does not guarantee a result. You may get a message “No object … maintenance IMG activity exists” quoting your table name, or none of the IMG nodes from the list will be the one you need. It means that it is time to try option number 3.

  1. Find a maintenance view in SE11

Start transaction SE11 and put your table name into the field “Database table”. Don’t forget to check that the radio-button switch is in the correct position too. Now click button “Where-Used List” on the panel.

SE11 - GB01
SE11 – GB01

You will get a pop-up window with a list of ABAP objects where your table is used. Tick checkbox “Views” leaving all other checkboxes unticked. Press Enter to continue.

SE11 - where-used list
SE11 – where-used list

You will get a list of table views relevant to the table you want to maintain. Now copy-paste your view name into the SM30 transaction and try both of the options described above.

Another way is to double-click the view name in the list. This will take you to the list of fields in the view. From there, click the “Contents” icon on the panel.

SE11 - view contents
SE11 – view contents

You will see the maintenance view for the table in Display mode. You only need to switch to Edit mode if you need that.

Hopefully, you now can maintain the table you wanted.

Do you know other ways to maintain a table in SAP?

Related Posts

SAP Expert is in top 30 of SAP Blogs

Dmitry Kaglik

March 16, 2018


No Comment

Share the knowledgeFacebookGoogle+TwitterLinkedinDiggemailSAP Expert blog is now about 5.5 years old. There are about 140 posts on this site, and there is a free e-book you can read to learn more about SAP Finance. It means that the inclusion of SAP Expert into Top 60 SAP Blogs by Feedspot is a well deserved award. Who […]

Read More

The most popular posts from 2017

Share the knowledgeFacebookGoogle+TwitterLinkedinDiggemailYear 2017 is now well in the past. I hope you read a lot of articles from SAP Expert in 2017. Do you want to know which posts were the most interesting and most read? Let me show you! 5. How to track changes in SAP objects 4. Eight methods to pay vendor in SAP […]

Read More

Leave a Reply

Your email address will not be published. Required fields are marked *

Search this site



Will you be happy to pay for the 3rd edition of the book FREQUENTLY ASKED QUESTIONS ON SAP FINANCE?

View Results

Loading ... Loading ...
Disclaimer and privacy policy