topic Re: Issue with maintenance view in Application Development and Automation Discussions

Issue with maintenance view

Former Member — Wed, 24 Apr 2013 11:32:19 GMT

Hi All,

In have a z table and TMG is already created for this.

Now the requirement is to add additional field into it and create maintenance view and allow only new field in changeable mode all other fields should be display only.

I have done the above changes, but the issue is new field is not coming in maintenance view and even other fields are not coming in display only mode.

Please suggest.

Thanks,

Vikas

Re: Issue with maintenance view

Former Member — Wed, 24 Apr 2013 11:50:05 GMT

hi vikas

1. after alter your table go with tr se14 then select your table name & then click active & adjust database

2. Reprocess TMG and then active database table

if helpful rewards with points

Thanks & Regards

RKarmakar

Re: Issue with maintenance view

Former Member — Wed, 24 Apr 2013 12:40:54 GMT

Hi Vikas,

You are add additional field to ztable , activated properly.

Go to se14 ---Adjust table .

se11--open table---utilities----table maintenance generator--- delete existing TMG ----create TMG once again with same name & screen no.--save and activate.

Surly your new fields also come in maintenance view.

next you want new fields in changeable mode.

sm30 ---open your maintenance view -----system--status----you will find program name & screen no ...etc ------double click on screen no ---go to layout you will find all the fields in you table ---click on new fields it will open the properties of that field in that ---Attributes---programs tab ---you will find the drop down list there you have to select not possible option --you have to check input field check box . for all new fields you have to do like that then it will allow that four fields in changeable mode.

Many thanks,

venkat

Re: Issue with maintenance view

Former Member — Wed, 24 Apr 2013 12:51:27 GMT

Hi Vikas,

Open table in SE11 in editable mode.Then follow Menu path

Utilities--> Table Maintenance generator

then Press delete Icon and Once deleted create new One.

You will find you fields appearing.

Re: Issue with maintenance view

mayur_priyan — Wed, 24 Apr 2013 13:04:21 GMT

Delete the table maintenance generator and recreate it once again through se11.

Re: Issue with maintenance view

Former Member — Wed, 24 Apr 2013 13:05:09 GMT

Hi Vikas,

1. You have a Z-table and you created TMG on top of it

2. I guess your requirement is to add new field, create maintenance view for the Z-table and create TMG for this view

The correct approach can be:

1. modify the database Z-table (add the field)

2. activate the Z-table.

3.a delete TMG for the Z-table by deleting it's function group in SE80

3.b re-generate TMG for the Z-table (you can choose either 3a or 3b)

4. in SE11 create maintenance view for your z-table

5. Create TMG for the new maintenance view

6. Modify the code in the generated code of TMG for this view to set some columns visible/invisible/editable/read only/...see the code excerpt at end of my post

For precise steps on how to create maintenance view, it's TMG and how to make selected fields visible/invisible/editable, you can use my fully functional example at http://oprsteny.com/?p=375

In the link above see chapter about creation of table view (maintenance view + view TMG) + part where a column attributes are changed during runtime:

loop at <vim_tctrl>-cols assigning <fs_col>.
  if <fs_col>-screen-name eq 'YOUR_COLUMN_NAME'.
    <fs_col>-invisible = ''1'.    "  field is visible(0)/invisible(1)
    <fs_col>-sceen-input = '0'.          " field is editable(1)/read only(0)
  endif.
endloop.