Field which relates Delivery and Schedule line of the Sales Order

[Former Member]

Hi

Can anybody post the table and field which relates the Delivery number with the Schedule line number.

For example :

Sales Order : 100001

Item : 10 - 5 pcs

Schedule line 1: 0001 - 3 pcs

Schedule line 2: 0002 - 2 pcs

Two deliveries are created 1 . 200001

2. 200002

Now how do we find which delivery is created for which schedule line.

Thanks in advance.

Muthu

[Lakshmipathi · Accepted solution]

Dear Muthu

You can track the schedule line from Table VBBE - Field Name ETENR in which you cannot track the delivery reference. Delivery reference can be tracked either from LIKP or LIPS.

However, if you want to see the document flow for a sale order, use table VBFA.

thanks

G. Lakshmipathi

[Former Member]

Hi

Please refer table VBEP - ETENR this will give the detils of the schedule line agsinst the sales order. And for delivery doc please refere table LIKP

U will not find sch. line no agisnt the delivery no.

Hope this will help you.

Thx

[former_member183879]

Hi,

I dont think you can find the schedule line number of the sales order in the delivery document. As mentioned by Lakshmi, you can check in VBBE for s.line data of the sales order.

If you want to verify the item for which the delivery is created, you can check in table VBUP for the sales order and there you can find the delivery status of all the line items of the sales order. This gives the status, but not the document number of delivery.

If you want the delivery document number for a particular line item, you can check that in VBFA table.

Hope this helps