How to take the Nth value?

[Former Member]

Hi Experts,

I am having a situation where I need to take the nth value after sorting in ascending order. Suppose, if

1. 10,

2. 20,

3. 30,

4. 40,

5. 50,

How to take the third value that is 30 and put it in the query designer?

Thanks in advance,

Regards,

Kannan

[shanthi_bhaskar · Accepted solution]

Kannan,

copy into internal table and you can sort it accordingly.

LOOP AT ITAB WHERE KEY = '30'.

"Move it any variable that is used in query which is of type Customer exit.

ENDLOOP.

[Former Member · Accepted solution]

Hi,

Well, I am sorting in ascending order and taking a count of it. Now, say - the count is 10 and I want to take the 8th value from it. How to do it?

Thanks in advance,

Regards,

Kannan

[shanthi_bhaskar · Accepted solution]

use this.

read table itab with index 8.

[Former Member · Accepted solution]

Hi,

Can you tell me which Customer Exit I should use for this?

Thanks in advance,

Kannan