ON TIME DELIVERY REPORT

[Former Member]

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

[Jelena]

For item # 1 an entry in VBRK table does not exist (unless you're using the order-related billing and the item has been billed but not delivered). You need to do LEFT JOIN instead of JOIN on VBRK table or in some other way consider the situation when there is a recird in VBEP but not in VBRK.

[Former Member]

Other table that you can explore are

LIPS (delivery item)

VBAP (Sales Order Item) tables.