Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

running same SQVI query with different results

Former Member
0 Kudos
195

I created a SQVI query joining tables MARA and marc.

I made a selection screen variant: I run the query several times, with the same variant and every time i execute (a few seconds from each other, not days) i get different results each time.

does anyone have an idea?

5 REPLIES 5

Former Member
0 Kudos
93

Hi,

did you check filtering and sorting?

0 Kudos
93

i did not set any

Former Member
0 Kudos
93

do you have any restriction for number of entries? result differs based on that as well..

0 Kudos
93

restrictions where?

and if so, the number should be the same....if I run a query on a join between MARC and MARA and MAKT i request all materials, filtering according to:

1) material type

2) material group

3) plants

4)exclude flagged for deletion

5) 1 language

and my output is:

1) material type

2) material group

3) plants

4) material number

5) description

I run the same query 5 times in 2 minutes and every time with the same variant and i get different results every time....

0 Kudos
93

hello alisa,

Your ALV report probably has a default filtering or sorting options. These optiıons are applying for particular fields. If you didn't select to include that particular fields, you can't see that options on these fields. I suggest you to check layout options/sorting & filtering in that ALV report.

Kind Regards,

Kerim.