Hi,
I americium trying to make a query for PO Approval alert successful SAP Hana. Upon instauration of PO it should alert the Approver.
I americium trying this query but it has an error:
SELECT T0."DocDate", T0."Remarks", T1."U_NAME" FROM "Z_WIZTECH_DUPLICATE"."OWDD" T0 INNER JOIN OUSR T1 ON T0."OwnerID" = T1."USERID" WHERE T0."ObjType" ='22' AND T0."Status" ='W' AND DateDiff(dd, T0.docdate,getdate()) = 0
Thanks.