How to trigger a workflow if Price is changed in SAP Sales Order

[SAPlearner7861]

Hi 

Can you help me to trigger a workflow if any price in Sales order is changed then a workflow must be triggered .

Thanks

[Dan_vL]

One option may be to create a trigger that gets called when an update to price occurs.  It could perhaps update a new column "price_last_updated". 

Then a query could periodically be run to look for values between a certain time range and if a change is seen, start the workflow.  The SAP Automation Pilot can schedule a query to be run and can notify the SAP Alert Notification Service which provides various actions such as the ability to send an email, create a ticket etc.  An example of this is shown in the tutorial https://developers.sap.com/tutorials/hana-cloud-alerts-custom.html.  The SQL used for creating a trigger can be found at https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/c....