2011年3月31日 星期四

Enhance standard SM30 table maintain screen and flow


How to enhance standard SM30 table maintain screen and flow.
We known the SE11 can create table maintain screen, but the screen maybe too small, or maybe we did like to fulfill value to some fields automatically. If required you can follow these steps:
1:
If you propose to include extend fields from other table in the screen , and your table didn't store the value. ex., you only store customer number(KUNNR) but no customer name(NAME1). Then you need to create maintenance view.
Before you create maintenance view, don't forget to create foreign key to link your add-on table field and external table. ex., in case was customer number field(KUNNR) v.s KNA1.
2:
You can to go to create maintenance view use your add-on table as primary table. When you want to add other table into your maintenance view, you can do that in Tables/Join conditions tab page.
Place the cursor on the primary table and choose Relationships below. All existing foreign key relationships of the primary table are displayed. Select the required foreign key and choose Copy.
The secondary table used in such a foreign key is included in the view. The join conditions derived from the foreign keys are displayed.
3:
When you completed above actions, now you can create the maintenance view's maintain screen. At menu:
Unitilies->Table Maintenance Generator
4:
To be continue ... ]