Home SM30 maintenance view with text table
Post
Cancel

SM30 maintenance view with text table

Basically, only columns of the table itself can be displayed/edited in a SM30 maintenance view. However, there is often a request to display e.g. the material short text for the material number in the maintenance view. This can be achieved with the help of a separate DDIC “maintenance view” (SE11). However, the following requirements must be met for this:

Insertion of a foreign key to the MARA.

So that the table in the SM30 can be linked with the MAKT, a foreign key must be created in the table on the field of the material number for the first time:

Foreign key

Create a maintenance view

Afterwards, a view of the type maintenance view must be created on the actual table in SE11. The actual table is then entered in this maintenance view and then the link to MARA is first created via the Relations button.

Then the table MARA is marked in the list of tables and the table MAKT is selected via the button Relations:

Maintenanve view - relations

To ensure that only the material short text is displayed in the logon language in the maintenance view, the following must be entered for the selection conditions:

Maintenanve view - selection conditions

To ensure that the material short text cannot be changed, this field must also be declared as read-only afterwards:

Maintenanve view - read only field

Finally, only the maintenance dialog has to be generated and thus the material short text is available as a separate column in the SM30:

SM30 with MAKTX