How to sort database table in View SM30

[chau1995]

Dear everyone,
I have a table in the system and inputted some value in SM30 (table which was TMG)
But My table doesn't sort by order ascending/descending at SM30
I want to sort it, and tried some code, but It conflicts with some event (change/save/display/delete).
Could anyone please help me with this issue.
Thanks so much

[Abinathsiva]

HI,

Go to TMG in the menu Environment -> modification -> events, add an event name that comes from the F4 help of the field... this could help to sort in TMG screen

[chau1995]

I don't know what event for it

[Sandra_Rossi]

It's been already answered:

How to sort database table in View SM30 site:sap.com

[former_member1716]

Hello chau1995,

Recommend You to Go through the blogs available in the FORUM, there are few discussing the same.

You can use the below Links to start with:

BLOG

THREAD

Regards!

[chau1995]

This code is conflicted with some events (ex: delete). So i think it is not good to resolve this issue

[Former Member]

Hi Chau,

please check the below link..hope it helps to your requirement.

https://blogs.sap.com/2016/12/27/sorting-with-anymultiple-fields-in-table-maintenance/

Best Regards,

Santhosh

[vivek_seth]

You can use Maintenance Event 'AA' in TMG.

https://help.sap.com/doc/saphelp_gbt10/1.0/en-US/4d/da26cd13f1679ce10000000a42189e/content.htm?no_ca...