Skip to Content
0
Former Member
Dec 21, 2016 at 01:11 PM

Query for Ship on Time in SAP B1

285 Views Last edit Dec 21, 2016 at 01:10 PM 2 rev

I've been searching for a query that will return the on time shipments in SAP B1. I'm new to SAP and using 8.82. What I need is a query that will return data based upon date range of ordered created and order ship date. I need the output to be order number, date created, expected ship date, date shipped, warehouse code, line item, quantity ordered, quantity shipped, customer number, customer name.

I've seen multiple queries that come close, however most don't give me results that are useful for measuring the outbound performance.