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?
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??