09-10-2008 2:14 PM
Hi all,
At the item level in a sales order, can anyone tell me the link between schedule line data and delivered quantity.
Schedule line data can be found in VBEP and delivery qty can be found in LIPS. But I want the link between the two. For which partcular date in the schedule line item the delivery qty is displayed.
Thanks in advance.
09-10-2008 2:17 PM
Rajini
There is no direct link between them.. It is dynamically calculated in Schedule Lines Screen.
You will have to go to VBFA table to get the Corresponding Delivery Orders for the given Sales Order Item. Then, You can collect it from Delivery Item table LIPS.
Thanks
Amol Lohade
09-10-2008 2:28 PM
hi,
there is no direct link.
There is a realatiion between the sales order and the delivery number in teh table of document flow (VBFA). so, for each schedule line, you can get the Sale sorder number and item number. Use those two fields to ge the delivery number from VBFA table.
Regards,
rahul sinha
09-11-2008 5:11 AM
Hi Amol and Rahul,
Actually I dont want the link between sale order and delivery, I want the link between schedule line dates and delivery qty.
Hope I am clear.
Thanks in advance.
Edited by: Rajini R M on Sep 11, 2008 6:12 AM