Researching Open Sales Orders Part -1

Building any Business Intelligence Model requires some blueprinting and investigation
from the ECC perspective and below is one classic example....more to come in part-2

so when an order is created a specific number is entered in the quantity field.
this quantity is required to be delivered to the customer when the order is
completed. now, when you create an order table VBAK gets updated with the header
information while the line item info gets updated in VBAP

when a delivery is created for this order the delivery document gets updated
in LIKP with header info and LIPS with line item. to find out if the quantity
ordered has been delivered check the delivery status for each of the line items
in VBUP table and determine if there is anything with the status B or A since
C is complete and we want to identify which of the line items have not yet been
delivered. now use table VBAP and determine the quantity for the line item
which is not yet completed and compare the quantity to the delivery line item
quantity in table LIPS- VGBEL and then check field LFIMG(delivery qty) and determine the difference. If there is a difference then the order status is still incomplete.