Skip to Content
-1
Jul 10, 2019 at 02:01 PM

HANA SQL returns different result as Open sql

234 Views Last edit Jul 10, 2019 at 02:20 PM 2 rev

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,

Attachments

abap-sql.jpg (40.6 kB)
hana-sql.jpg (53.3 kB)