Delivered quantity for each schedule line

[Former Member]

Hi,

Our scenario is that we have an order for each order's each item we can have multiple schedule lines, when any of the schedule line is delivered the delivered quantity colum is updated, the schedule lines table in VBEP but the thing is it doesnot have the delivered quantity, system calculates it at runtime or may be it is keeping it in some other table.

I hope some body can help in this regard.

Thanks

Khusro Habib

[LucianoBentiveg]

If the system don't confirm delivered quantity, may be is an stock issue or a credit limit.

Check that.

Regards.

[Former Member]

Check in VBRP and VBRK , Delivery tables.

Rgds,

Mano Sri

I assume you have a Delivery note created.

[Former Member]

Thanks for anwering,

the thing is i can get the data for delivery from VBRP and the schedule line data from VBEP but our report we have to show each schedule lines and its delivery against it. and we are unable to find a link where we can link each schedule line to its corresponding delivery.

Regards

Khusro Habib

[Former Member]

I think you want VBFA - Sales documnet flow. VBFA-VBTYP_N = 'J' is a delivery (you also need to take into account returns). VBFA-RFMNG is the quantity.

Rob

[Former Member]

You can also use the FM RV_FLOW with VBTYP_N = 'J'

But you will not get exact one to one relation.

Like you can't check the exact relation between Schedule line and delivered Qty.

SAP calculate it dynamically.

You also need to take care of any reversal.

Regards

Aman

[Former Member]

It is a calculated value, not a value of a table field. Also, it may lead to wrong results if you don't pay attention to this description of the field here under in bold.

Delivered quantity in sales units

The quantity from the schedule line that has already

been delivered.

Use

When there is more than one schedule line for an item,

the system distributes the total delivered quantity for

the item across the schedule lines according to the

sequence of their delivery.

Example

A sales order item has three schedule lines, each with

an order quantity of 50 pieces. You make two subsequent

deliveries: the first for 20 pieces, the second for 60

pieces. The delivered quantity for the first schedule

line is 50 pieces, for the second 30 pieces, and for the

third zero.

If you delete the first delivery (20 pieces), the

delivered quantity for this schedule line is still 50

pieces. However, the system reduces the delivered

quantity for the second schedule line to 10 pieces.

[Former Member]

Hi all,

I have the same type problem now...as Delivered quantity for each schedule line. How to find goods issue date(vbfa-erdat) and delivered quantity(vbfa-lmeng) from VBFA for each VBEP schedule line item.

Thanks,

Bt

[Former Member]

Hi Experts,

Any idea about this problem.

thanks,

Bt