Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Custom Approval Query

Does anyone have an idea of why this is not working?

SELECT 'TRUE' from ORDR a INNER JOIN OCRD b on a.CardCode = b.CardCode

where a.DocNum = $[$8.0.0] and ($[$29.0.number] + b.Balance) > b.CreditLine

I am testing this because there are other criteria I have to out in the where clause. But, I cannot B1 to trigger this approval.

If I run this after the Sales Order is added, the query appears to be working, I get TRUE as my result. Running 2007A PL38.

Not what you were looking for? View more on this topic or Ask a question