Link between actual ship date of an item and schedule line in Sales Order

[Former Member]

So, we are developing a custom report that compares actual Ship Date (Goods Issue Document MKPF-BUDAT) and the date the item should've been shipped (Schedule Line Date).

I am able to link the GI Document to Delivery Document and can then link to Sales Order Number/Item Number.  However, a line item can have multiple schedule lines.  What logic can be put in the mapping so that the correct scheduling line is picked for the GI date to be compared against?

Example:

Sales Order 123

Item 10 Product X - Quantity 10

Schedule Line 1: 11/15/2014 8 pieces

Schedule Line 2: 12/15/2014 2 pieces

Let's say first shipment gets delayed 2 months and ships 1/15/2015

Due date in report should know to select 11/15/2014 to calculate that shipment was late 60 days

Any way to link delivery document to a specific schedule line??

Thanks!!

[former_member274400]

Hello,

Just did similar development for customer report. List of deliveries based on sales order number and sales order line item numbers. Sort these deliveries either with number or actual goods issue date. Compare goods issue quantity with schedule line quanity and start allocating deliveries to schedule line. For example

Schedule line 1 - 10 MT, Schedule line 2 - 5 MT. Now you have created 3 delivery. First with 7MT, second with 5MT and third with 3MT. Your first delivery will be for first schedule line. Your second delivery is for first and second schedule line and your thrid delivery will be for second schedule line

Regards,

[Former Member]

Hi,

to my experience, a schedule line can be split into multiple delivery lines, however, for a single delivery line, it can only be traced back to a unique schedule line, and for an outbound delivery document, you can find 'actual goods issue date' at header level which should be applied to each delivery line, so for any given delivery item, its actual goods issue date can be found from document header, and when traced back to a schedule line, you can also find the 'planned/confirmed goods issue date'

correct me if any, thanks

[Former Member]

GI date is already found in LIKP-WADAT_IST. There is no need to link to material document.

In VBFA table for the respective SO and Item, you have delivery and item.

This is just a matter of comparing VBEP against VBFA and do your logic of getting the dates. Build your "what if" scenarios on each possibility and then do your logic in your report program.