cancel
Showing results for 
Search instead for 
Did you mean: 

Creating a Query for Purchase Order Approval

Former Member
0 Kudos

I need to develop a query to check if any of the line totals in a new purchase order exceeds $500. I have to attach this query to the approval procedure (under 'Terms' in 'Define Approval templates'). When the 'Add' button on the purchase order is clicked, the values on the form are still not available in the database. This means, my query has to pick the data from the new purchase order form. Is there any way to build such a query? Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

AlexGrebennikov
Active Contributor
0 Kudos

Hi Satish!

i hope i understand your issue properly.

now you cannot create such query.

all i can say - join our team at

FOA
Advisor
Advisor
0 Kudos

Satish, Alerts just notify the appropriate parties. They do not stop a document from being posted. This means, it is not capable to recognize the situation unless it's already stored in the DB.

Alexey. what about creating a Development Request about this topic?

Regards,

Felipe

Answers (1)

Answers (1)

Former Member
0 Kudos

try select $[opor].[something] the $ sign indicates that the value should come from the active form. download from service.sap.com/smb the available documentation on reporting. should be really helpful