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

[pramodv]

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

[Former Member]

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

[former_member187989]

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.

[Former Member]

Hi

VBUK=Header

VBUP=Item

status view for sales ordr items..

Thanks

mk

[Lakshmipathi]

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