SAP HANA console not matching SE11 results

[former_member221140]

When querying SAP via the HANA studio console, I am seeing different results from table MSKU than what I see in SE11. What could explain this? his does not match se11 records on a column value basis (E.g. KULAB), however the record counts, MATNR, CHARG, and KUNNR do match.

E.g. My query is:

select * from sapabap1.msku

where MATNR, CHARG, and KUNNR = whatever

Se11 results have different column values for same table/query.

I am querying the same server/client.

[lbreddemann]

From your description of the problem the first thing that comes to mind is that your query does not constrain on the client (MANDT) column when you run it from SAP HANA studio.

In SE11 this is done automatically in the background.

Not sure how you checked the record count(s ?) or the individual columns to see that these "match".

Also, keep in mind that the database tables don't have any implicit ordering. If you want to compare the records, you usually have to add an ORDER BY clause to have the same record order.