SAP B1 Hana - PO Approval email alert

[wiz_traceremo]

Hi,

I am trying to create a query for PO Approval alert in SAP Hana. Upon creation of PO it should alert the Approver.

I am trying this query but it has an error:

SELECT T0."DocDate", T0."Remarks", T1."U_NAME" FROM "<Dbase Name>"."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.

[wiz_traceremo]

Just an update, since we're using Hana, instead of getdate. We used Current_date function

[SonTran]

Hi,

The approval notification is out of the box, why you want to customize an alert?

Beside that, you can use approval status report and approval decision report for approver who can query/filter related to approval process.

Hope this helps,

Son Tran