OUTER APPLY in SAP HANA

Former Member — Wed, 21 Dec 2016 15:05:04 GMT

Hi Guys,

We are currently translating all queries to SAP HANA.
Can anyone please tell me how an "OUTER APPLY" works in HANA?

See my query below.
After the last join I used an "OUTER APPLY".

Thanks!

Kind regards, William

SELECT *  
FROM  [dbo].[RDR1] T0  
		INNER JOIN dbo.ORDR T1 ON T1.DocEntry = T0.DocEntry
		OUTER APPLY (SELECT TOP 1 T20.U_DocType, T20.U_LineNum, T21.ItemCode
								 FROM dbo.[@CUSTOMTABLE] T20
									 INNER JOIN dbo.OITM T21 ON T20.U_Treatment = T21.ItemCode
								 WHERE T20.U_DocEntry = T0.DocEntry AND T0.ObjType = T20.U_DocType AND T0.LineNum = T20.U_LineNum
									 AND T21.U_Type IN ('A', 'B') 
									 AND ISNULL(T20.U_Cut, 0) > 0) T13

Re: OUTER APPLY in SAP HANA

cribad — Tue, 11 Feb 2025 09:02:18 GMT

Did you get an answer on this? I'm running into the same problem right now.

Question Re: OUTER APPLY in SAP HANA in Technology Q&A

OUTER APPLY in SAP HANA

Re: OUTER APPLY in SAP HANA