Skip to Content
Mar 05, 2020 at 08:24 PM

Back Order Query with IF included - New Learner


Hi all,

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?