on 06-20-2012 4:38 AM
Hi Gurus,
I have question for our business need. We have sales order with multiple items for which we do generate individual outbound delivery docs and do post GI individually which generates seperate invoice document for each outbound delivery. NOw on one custom screen we have to shows partial shipped amount for particular sales order, i have to provide logic for that seach and display. Basically system will go in VBFA (doc flow) table based on sales order number as query for each sales order item and if it finds entry in invoice filed that means line item is invoiced already (may be partial) now system extract that invoice entry and make it as query and search in VBRP table (billing table) and finds NETWR (net value for invoiced amount) and get that value put it in temp table and basically do a loop till system finish check for all sales order items and get shipped amount for all applicable line items. after getting this value system will sums up and display that total $ as partial invoiced(shipped) amount. MY question here is that Can someone point me that what is the field name for invoice doc(entry) in table VBFA???? also if anyone know any other way to find out so far invoiced amount for sales order from any table then pls tell that table and field??? that will solve all these iterations for system.
Thanks.
Jess
dear,
to pick up the invoice number from VBFA you need to use your sales order number in VBFA-VBELV field and set up VBFA-VBTYP_N = 'M'
VBFA-VBELN is your invoice number
the VBFA-POSNN is your item in invoice which matches item in order (VBFA-POSNV)
now take your invoice number (VBFA-VBELN) and go to VBRP to get all data you need on invoice item ...
regards,
p.s. you also can use the tables VBUK and VBUP
say, for your invoice look at fields VBUK-BUCHK and VBUK-GBSTK and find the statuses
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.