How-to find a maintenance dialogue for the SAP table

Dmitry Kaglik

February 2, 2015

SAP

No Comment

Share the knowledge!

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?

Share the knowledge!

Related Posts

Controlling Account Assignment for non-Financial consultants

One of the most common issues that users experience when trying to post a document into the Accounting module of SAP is the issue about Assignment of Controlling Object. This error may appear in different situations: manual entry of the document in Finance, Goods Receipt or Service Entry Sheet for a Purchase Order, and so […]

Read More

An offer from SAP Expert for those in job search

Are you in the job search? Do you want some help? SAP Expert wants to give you a helping hand. There are actually two parts of this help. First of all, I am offering you an impartial  CV / Resume review. Seeing many of them, writing my own, I have some views on what should […]

Read More

Search this site

SAP Expert on the web

Subscribe!

Enter your email address:

Polls

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

View Results

Loading ... Loading ...
Visit Us On TwitterVisit Us On LinkedinCheck Our Feed