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,