Skip to Content

Table Maintaiance generator for large table

Hello Friends,

I have a large z table with over 150 fields, the current table maintance generator screen is not aligned properly and fields appear all over the screen.. Is there way to order these fields so it is becomes easy for the users to update the table easily and it looks beautiful.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 25, 2017 at 05:23 AM

    150 column table? What is this data for?

    In my view there's no way you can maintain that through TMG in way that's easy for the user and/or in any way beautiful. When you've that many columns TMG will always be highly unwieldy.

    You should instead adopt an approach of your own dialog screens, with grouped data on single screens, and a sensible route through.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2017 at 06:40 AM

    I agree with previous answers, you should build your own module dialog...

    If you modify the dynpro, eventually someone will change the table, regenerate the dialog and d'oh!

    With lack of time or something else, you could create some "adequate" maintenance views on the table and manage the dialog in a view cluster, just insure mandatory fields are on main/first view.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2017 at 03:43 AM
    -3

    As per my knowledge, one option is there. go to se11-> TMG ->Menus->Environmnet->Modification->maintain Screens. Here one screen will be apper. This screen is what you see in sm30. Now adjust the fields.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2017 at 03:43 AM
    -4

    hi

    for this goto -> table maintance generator-> there function group is there.

    take that function group and go to -> SE80.

    open that function group in SE80-> goto sreen.

    here ur table maintenance generator SM30 screen is there.

    now u can modify according ur requirement and activate screen .

    then also activate total function group also. then go SM30.

    see ur results.

    Add comment
    10|10000 characters needed characters exceeded

    • So anytime he add-remove-change a field, all the manual changes performed via SE80 on the generated screen are lost.

      Not really wise imho.

      If i've to change manually the screen, it's better to follow Matthew's suggestion and develop a custom solution, surely more easy to maintain on long run.