Skip to Content
Former Member
Sep 18, 2007 at 06:42 AM

What is the direct link between Schedule Line item and Delivery line item?


Hi SAP SD Gurus,

The question is simple. I would like to calculate the Open order quantity for a particular month based on the Schedule Line Date.

I am taking all the Schedule lines falling below the running date of the month and sum up that and look for the deliveries happened for that Schedule lines.

I am unable to link that Schedule line with that Delivery line item.

The only link is Schedule Line Number in VBEP table which is not available in LIPS. I would like sum up the Schdule line Quantities and Subtract the sum of the Delivery quantities which will give me the Open orders for the particular day of the month.

Can anyone help me to link this VBEP table to LIPS table to connect the Schedule line number with the Delivery line item?

Thanks in advance for your help..