cancel
Showing results for 
Search instead for 
Did you mean: 

Exclude top 10 in BEx query

0 Kudos
460

Hi Experts,

I need to exclude top 10 from the query result. Creating condition in the query with top 10 is easy but how to exclude the top 10 in the query output? Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Create new condition, in this u will create a variable for Top N.

Keyfigures operators Values

Eg:qty not equal to &ztopn&(variable)

Regards,

Sai.

0 Kudos

Hi Sai,

Thanks for your reply. But it doesn't work. It's pulling all data. Any other way to get this functionality? Thanks

Former Member
0 Kudos

Hi Waseem,

Have you tried Ninand Warang procedure . Is it working or not?

If not you have use the APD concept

create a query on top of that infoprovider with out any conditions..

Create A direct update dso..

In APD use Query as source and DSO as target. In between use ABAP program sort them > delete the first 10 records>

Create a query on top of DSO will get the Excluding TOP 10.

Hope it helps..

Regards,

Ranganath.

Former Member
0 Kudos

Hi Waseem

Here's what you can try out:

Create a query 1 with the condition to show only TOP 10 values.

Then create a query 2 and using replacement path variable restrict some characteristic (like doc no) in query 2 with the output of query 1 and exclude this variable from the query 2.

This way the top 10 values from query 1 should get excluded from the query 2 output.

Hope this helps.

Regards,

Ninad