Skip to Content
May 23, 2019 at 01:47 AM

HANA Query to Exclude Cancelled Journal Entry


I'm creating a report and I don't want the canceled journal entries to appear. I have this query below but it is working in SQL can anyone help me to convert it into HANA?

SELECT T0.TransId FROM OJDT T0 WHERE (T0.TransId not IN (SELECT T0.StornoToTr FROM OJDT T0 where t0.stornototr is not NULL)) AND (t0.stornototr is NULL)