on 09-08-2010 2:29 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
VBUK=Header
VBUP=Item
status view for sales ordr items..
Thanks
mk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.