HANA SQL returns different result as Open sql

[Octav]

Hello,

Can you please help me to understand why a query written in open sql for abap is returning different results than the same query written for hana?

Example: Table TVKOV : key fields VKORG & VTWEG

Values:

VKORG VTWEG

CBC1 C2

CBC1 C5

Open SQL query:

select vbak~vbeln,vbak~vkorg as vbak_vkorg,vbak~vtweg as vbak_vtweg , tvkov~vkorg , tvkov~vtweg from vbak inner join tvkov on ( vbak~vkorg = tvkov~vkorg and vbak~vtweg = tvkov~vtweg ) where vbak~vbeln = '4510363566'

-> 1 Row retrieved

Hana Sql script - Same query in the same system with DB02

Thank you,

[michael_eaton3]

This could be data from multiple clients, try adding MANDT to the query.

[Octav]

Thank you very much Michael.

Indeed, MANDT was the cause.