Skip to Content
author's profile photo Former Member
Former Member

What is the direct link between Schedule Line item and Delivery line item?

Hi SAP SD Gurus,

The question is simple. I would like to calculate the Open order quantity for a particular month based on the Schedule Line Date.

I am taking all the Schedule lines falling below the running date of the month and sum up that and look for the deliveries happened for that Schedule lines.

I am unable to link that Schedule line with that Delivery line item.

The only link is Schedule Line Number in VBEP table which is not available in LIPS. I would like sum up the Schdule line Quantities and Subtract the sum of the Delivery quantities which will give me the Open orders for the particular day of the month.

Can anyone help me to link this VBEP table to LIPS table to connect the Schedule line number with the Delivery line item?

Thanks in advance for your help..

Augustine

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 19, 2007 at 05:51 AM

    Hi Augustine

    You sould check in VBBE and not VBEP. This table will give you open orders.

    I am sure this will solve your problem and if so, please dont forget to reward me points.

    Regards

    G. Lakshmipathi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 07:05 AM

    Hey

    Delivered quantity at the schedule line is calculated with function module <b>RV_SCHEDULE_CHECK_DELIVERIES...</b>

    Now for your Querry Check document flow from sales order to delivery VBFA, schedule lines VBEP status VBUP and sales order item VBAP to get the VSMNG( Delivered quantity in sales units) filled in VBEP.

    Also please check the following FM.

    SD_VBEP_READ_WITH_POSNR

    SD_VBEP_READ_WITH_VBELN

    SD_VBEP_SINGLE_READ

    See if this below mentioned link helps you

    <b>LIPS-VGBEL = VBEP-VBELN and

    LIPS-VGPOS = VBEP-POSNR</b>

    so Actual quantity delivered (in sales units) can be fetched from <b>LFIMG</b>(LIPS)

    Cheers

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Anuj,

      I am aware of the Functional Modules.

      I wanted to know for this Schedule Line, this is Delivery document created.

      Where in SAP through Tables it is linked? Because, I need to source the Tables to calulate the open orders by way of external report through Business Object.

      The table link from VBEP to LIPS is not directly linked. It is linked from Sales order line item level. Because we are capturing all the Sales order Line tiems through the Delivery Status which is not equalled to C. But if there are partial deliveries against the Scheuld Line item level, we need to identify. The only common joint should be Scheldule line number which is not available in LIPS.

      If we are developing report inside SAP, we can use the said Functional Modules to capture through Structures VBEPD. Since it is a external reporting , we need to give correct tables and the joints. Hence I am looking for any other way to solve this.

      Thanks

      Augustine Ponraj

  • author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2007 at 11:35 AM

    Thanks for all your help.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Augustine,

      Saw your post. I am facing a similar issue. I need a link between LIPS and VBEP. In case of split confirmations, means multiple schedule lines for the same item number, I am not able to track the schedule line for the delivery item.

      Thanks for your help.

      Amit Aggarwal

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.