Skip to Content

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

Purchase Approval

2007B

want to trigger an approval for purchase orders higher than 25000 rupees.

I need the query for this approval

replied

You could click on the Document Total check box in the Terms tab and enter your Total numbers.

When you have these range scenario's you will need 3 seperate Approval templates

The amount can also be embedded into your Query..like this

For using the Amount shown on Total Before Discount you will use

SELECT 'TRUE' WHERE $[$88.0.0] = 12 AND $[$22.0.Number] <= 25000 

For checking the DocTotal

SELECT 'TRUE' WHERE $[$88.0.0] = 12 AND $[$29.0.Number] <= 25000 

You will need 3 queries for each of the Amount ranges which will be linked to 3 seperate Approval Templates

0 View this answer in context

Helpful Answer

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