Skip to Content

Order of entries in SM30

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 16, 2016 at 02:19 PM

    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


    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2016 at 10:14 PM

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

    Add comment
    10|10000 characters needed characters exceeded