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.
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.