Skip to Content

How to find a Sales order line item is completely invoiced?

Hi All,

I need to pick sales order line items which are completely invoiced, comparing tables VBREVE and VBFA. Please let me know the fields for the select query with where clause. I have the sales order number (VBELN).

Thanks in advance.

Pramod

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Sep 08, 2010 at 01:52 PM

    There are many standard TCodes which may suit your needs. Explore that and if that is not fit into your requirement, then you can go for zee development as follows:-

    From Table VBAP, you have to consider the following:-

    VBELN - Sale Order reference

    POSNR - Sale Order Line Item

    MATNR - Material

    KWMENG - Sale Order quantity

    Next you have to pass the above first two fields in table VBFA and subsequently to VBRP.

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2010 at 12:28 PM

    Hi

    VBUK=Header

    VBUP=Item

    status view for sales ordr items..

    Thanks

    mk

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2010 at 05:43 PM

    Open Sales order using VA02,In item detail --> Schedule lines tabe --> If Committed qty = Delivered qty then item is completely invoiced.

    Find these details in table VBEP.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2010 at 08:20 PM

    Pramod,

    You can find billing status of line item in table VBUP. If you do billing based on delivery then FKSTA should be 'C' or billing is based on order then FKSAA should be 'C' then get POSNR.

    Regards

    Nagendra P Boggarapu

    Add comment
    10|10000 characters needed characters exceeded