Skip to Content

Logic for fetching Quantity Delivered and Invoiced

I am creating a Sales Order report in which I need to Fetch the delivered Quantity and Invoiced Quantity fields.

I am currently going to VBFA table and pass SO and line item number and fetch all data. Then I perform addition/ subtraction to remove cancelled quantities. this is making the logic complicated.

Is there any standard Function module/ or table or BAPI which can fetch the Delivered and Invoiced quantities directly?

Regards,

Onkar Borkar

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2009 at 09:12 AM

    Hi,

    connect your logic like this

    After passing SO and line item number, refer table LIPSD filed G_LFIMG for delivered qyt and then to to table VBRP field FKIMG for actual billed qty.

    The report with these tables may get performance issues, to ease out and improve efficiency you can refer structure DOCUMENT_FLOW_ALV_STRUC where all these datas are available.

    Hope this solves your issues.

    Thanks &regards

    Hameed Parvez

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 21, 2011 at 12:21 PM

    Hi Experts,

    There is a requirement where in it is required to track changes in the field 'Batch' in the deliveries. This change log report should have the option of checking the log for multiple deliveires at a time. It can be similar to the delivery change log report that we have but shoul run for multiple deliveries at a time.

    Please let me know if such a reporet is available in standard SAP or in LIS repporting.

    Thanks/ Regards,

    Onkar

    Add a comment
    10|10000 characters needed characters exceeded

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.