Sort Data in Maintain Table View

[Former Member]

Hello everybody,

I have created a generated Maintain View (from SE54) for one customizing table.

I want to sort the data of table (the sort includes fields that aren't keys) before showing the data in my view (SM30). Ho can I achieve this?

The method that I found is to sort the table TOTAL[] in the event AA (Instead of the standard read routine). The data is shown as sorted, but when i select one record for delete or I use the function "Position", then I'm in trouble, since the program doesn't read correctly the record I have selected.

Do you have any idea in how to solve this?

Thank you very much!

[Former Member]

You should create a maintenance view with your sort keys first, then the missing primary keys and last the other fields from the database table. Use this view to generate the maintenance dialog.

Regards,

Raymond

[RaymondGiuseppi]

You should create a maintenance view with your sort keys first, then the missing primary keys and last the other fields from the database table. Use this view to generate the maintenance dialog.

Regards,

Raymond

[Former Member]

Hello Raymond,

thanks for you answer.

There is only one problem with your solution: since the primary keys are somewhere at the end of the table, the new records can not be saved in a transport job and implicit in the Database, because the key of the view is to long in this case.