ON TIME DELIVERY REPORT

hI,

I'm creating otd report.

in sales order -sline tab cust requested delivery date is entered

difference between cust requested date - invoice date =otd

i'm using VBEP -EDATU & VBRK TABLES

But suppose in sales order 2 line items are there

item 1 not delivered

item 2 delivered/billed

when executing tthe query only item 2 is coming , item 1 is not coming

is there any other table/fileds i can use so that all items irrespective of delivered or not

can get picked up so that

say like

cust requested date billing date

item 1 1.1.08 -

item 2 1.1.08 1.1.08