SQL engine change query results

[Former Member]

Hello,

We have built a CV. When we run the same view twice, first time with SQL ENGINE and second time without SQL ENGINE we were surprised to get different number of records. The SQL engine also less efficient in our case:

Can someone please explain how can SQL engine change the result of a query?

Thanks,

Amir

[Former Member]

See SAP Note 2222121 about "wrong" results. The calculation engine sometimes doesn't behave like you would expect from a normal SQL statement. These features can be responsible for a different result set based on the used engine.