no 'order by' selection for cluster tables generates run-time

[Former Member]

Hi together,

Basically I want to use a "select...order by" statement with table mhnd.

Since mhnd is a cluster table you can not use "...order by".

So, I use a select ... into table. I then sort this table and finally read it (index = 1)

Unfortunatly this approach generates huge run-time.

What can be done to minimize run-time?

Thanks for any help

[Former Member]

Hi Gerd,

Which cluster table you are using and what`s data you wanted? Maybe there are some FM to extract data from it.

regards,

Archer

[PeterJonker]

Like Dengyong said, look for a function module that will do it for you. I saw function modules starting with GET_DUNNING_DATA*, they might do the trick.