topic Re: SM30 sort using non-key fields in Application Development and Automation Discussions

SM30 sort using non-key fields

Former Member — Tue, 27 Dec 2011 18:44:45 GMT

Hi All,

I've created a table in SE11 and generated its table maintenance(SM30), now I need to sort the entries by a non-key field...

I thought of using the event 26, but it isn't triggering!

Instead of this, i used the event AA also I'm scared of leaving any functionality back.

I need an event in which the internal table "TOTAL" is already filled, so i can transfer its data to a local internal table, sort it then overwrite "TOTAL".

Can anyone tell me what's the better event to be used in this case, and if I'm using the correct internal table to do this?

Thanks,

Arline.

Re: SM30 sort using non-key fields

nabheetscn — Tue, 27 Dec 2011 19:13:00 GMT

First of all I think you should not play with total only as we also extract table ..changing the sequence may cause an undesireable effect. You can try to do it pai after endloop..when do you want to sort the data..?

Nabheet

Re: SM30 sort using non-key fields

Former Member — Tue, 27 Dec 2011 22:37:48 GMT

I don't think it's an easy chore; however, I recall seeing a thread some months ago in the forum where a solution is given. If you search for sort and table maintenance, you should find it.

Rob

Re: SM30 sort using non-key fields

Former Member — Wed, 28 Dec 2011 10:07:48 GMT

Nabheet

I need to sort the data before displaying not before inserting a new entrie...

What internal table you advise me to use?!

Re: SM30 sort using non-key fields

nabheetscn — Wed, 28 Dec 2011 10:24:46 GMT

What you can try is as follow.

Go to the screen in table maintainence generator.

after MODULE LISTE_INITIALISIEREN. add your own custom module. In it you will have access to extract and total internal table.

Move them in temporary internal table sort your way move back.

Make sure this thing happens only once while calling not everytiime even if user press enter. You can handle it by setting a flag for initial sorting.

Hope it Helps

Nabheet

Re: SM30 sort using non-key fields

Former Member — Wed, 28 Dec 2011 12:32:26 GMT

Ok Rob, I found a link!

But i still don't know which event to use...

I tried the event 26 but it doesn't triggered!

Nabheet, same problem...

I need an event to trigger the code.

Arline

Re: SM30 sort using non-key fields

nabheetscn — Wed, 28 Dec 2011 12:59:20 GMT

I was not talking about events the logic presented above is implemented directly in maintainence screen of tmg.

Nabheet