cancel
Showing results for 
Search instead for 
Did you mean: 

Partial Shipped Amount for Sales Order amount

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member184701
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thanks you very much this answer is very very helpful and answered all my questions..pls tell me how to close this thread and how to appreciate your answers by providing my feeback.(points).

Jess

Answers (0)