cancel
Showing results for 
Search instead for 
Did you mean: 

Table Maintaiance generator for large table

0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

matt
Active Contributor

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.

Answers (3)

Answers (3)

raymond_giuseppi
Active Contributor

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.

former_member196331
Active Contributor
0 Kudos

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.

former_member241258
Active Participant
0 Kudos

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.

SimoneMilesi
Active Contributor

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.