https://userapps.support.sap.com/sap/support/knowledge/en/1789331
1789331 - Analyse and fix wrong data returned by query - BWA | SAP Knowledge Base Article
A query displays wrong data when the Business Warehouse Accelerator (BWA) is used. When the query is run against the database the data is correct.