Apologies I am very new to learning how to write queries in SAP, I can do basic queries where I pick lots of information to display, however I am looking to write something more complex where the query only picks information up on specific terms.
For example, here is the basis of what I am wanting to find out: I need to run this query daily to check what lines have come through on back order in customers orders. We have a field in UDF where we specify whether customers allow back orders or not. I need to find out when lines are coming through (out of stock) on customers orders which don't allow back orders.
What is the correct way to do this?