Order of entries in SM30

[valtermartins]

Is it possible to change the order in which the entries (lines) appear in sm30? I needed them to appear sorted by several key indexes, but from what I see sm30 puts the entries in a random order always different even without making changes to the contents of the table. Anyone know if it's possible to sort the entries?

[raymond_giuseppi]

You could use event Event AA: Instead of the Standard Data Read Routine in your dialog to force order of records, either with a ORDER BY in SELECT statement or a SORT of generated internal table. AFAIK the standard forms don't force order of records, but 'most of the time' the SQL optimizer will use the PRIMARY KEY index.

Your form should replace either form GET_DATA_viewname (copy it from some generated function group) or TABLE_GET_DATA for a table (copy it from include LSVIMFTX)

Regards,
Raymond

[Jelena]

Google -> "SM30 sort site:sap.com" -> 814 results. Kindly search before posting.