Skip to Content
0
Aug 09, 2023 at 07:10 AM

Approval when Doctotal is Less than the BP commitment

101 Views Last edit Aug 10, 2023 at 03:16 AM 2 rev

Hello Guys,

I'm trying to make approval whenever we enter a document that the total value is less than the BP commitment limit. Currently my setting is below but seems not working and I'm clueless what to put the value.

Im using SAP HANA.

deviation.png

Also below Query Im trying to use but to no avail.

SELECT distinct 'True' from ODLN where CAST ($[ODLN."DocTotal"] as DECIMAL) < $[$87.6.1]

Attachments

deviation.png (15.9 kB)