Sales Orders Model part-1

Researching Sales Order models before building a BI model

read the order by looking at VBAK table which is the header table for the order header information. now determine the line items for this table by using VBAP table.
based on the number of line items you can now determine how man schedule lines are there for each line item. i.e some line items can be delivered by breaking down to 2or 3 schedule lines....one line item has 10 as the qty and that 10 can be delivered in 2 schedule lines 3 and 7.this can be determined by table VBEP....now to determine if these line items are delivered or not look at the delivery line table
which is LIPS and determine the several line items being delivered.
the header info for these deliveries can be found in LIKP table.

the table join happens in 2 places: between orders and delivery it is the VBAP table with fields VBAP-POSNR & VBELN with LIPS-VGBEL &VGPOS .....and combining delivery tables and billing tables the join happens between LIPS-VBELN & POSNR and VBRP-VGPOS & VGBEL

Here is a good example of how SD tables are linked and this forms the basis for any BI modelling !

http://www.erpgenie.com/sap/abap/tables_sd.htm