Skip to Content
0
Sep 10 at 10:11 AM

Row level column value match with Document number SAP Business One HANA

80 Views

Dear all,

In below query how to match row level UDF column T1."U_UNE_PONUM" with Purchase order document number.

How to apply where condition?

Select T0."DocNum", T0."DocType", T1."U_UNE_PONUM"

from ORPC t0

INNER JOIN rpc1 T1 ON T0."DocEntry" = T1."DocEntry"

LEFT JOIN por1 T4 ON T1."DocEntry" = T4."DocEntry" AND T1."BaseRef"= T4."BaseRef"

LEFT JOIN Opor T5 ON T4."DocEntry" = T5."DocEntry"

Regards,

Nikunj