unbilled quantity in sales

[Former Member]

hi experts,

basically i am a bi consultant , i have to develop a reports for unbilled quantity , can anybody tell me how to know the unbilled quantity.

tnx,

praveen,

[ivano_raimondi · Accepted solution]

Hello Praveen,

you can get all the necessary information from table VBFA.

This table contains the subsequent documents created for a specific sales order item:

- VBFA-VBELV sales order

- VBFA-POSNV sales order item

- VBFA-VBTYP_N SD document category of subsequent document (so you can search for billing)

- VBFA-RFMNG reference quantity

Best regards,

Ivano.

[Former Member · Accepted solution]

hi ivanao

thanx for the rply,

then how to know unbilled quantity from that table please can you explain in details.

tnx,

praveen

[ivano_raimondi · Accepted solution]

Hi Praveen,

the sales order item quantity is present in VBAP-KWMENG.

The billed quantity is present in VBFA record corresponsidng to subsequent invoice, field RFMNG.

The difference is the unbilled quantity.

Best regards,

Ivano.

[suman_sardar2 · Accepted solution]

Hi Praveen,

In case of Order related billing what Mr.Ivano told is correct.

But my question is Sales Order Qty =100

                            Delivery (PGI) Qty=40

                            Invoice Qty          = 0 Means Invoice not done.

What will be the Unbilled Qty in your report?

1.100?

2.40?

3.0?

Please clarify.

Thanks,

Suman

[Former Member · Accepted solution]

hi ivano,

thank u very much

can u explain with an example. the difference is unbilled quantity. i did not get that point.

tnx,

praveen,

[ivano_raimondi · Accepted solution]

Hi Praveen,

a sales order has 3 items.

VBAP:

POSNR  PSTYV  KWMENG

000010   TAN                 1,000  not delivered
000020   TAN                 2,000  partially delivered and billed
000030   TAD                 3,000  not relevant for delivery, partailly billed

VBFA:

POSNV    VBTYP_N RFMNG

-------------------------------------------

000020   J                    1,000
000020   M                    1,000
000020   R                    1,000
000030   M                    2,000

Item 10 has not VBFA record with VBTYP_M containing billing SD document category, so unbilled quantity is the total item order quantity VBAP-KWMENG.

Item 20 and 30 are partailly billed, so the unbilled quantity is VBAP-KWMENG - VBFA-RFMNG

Best regards,

Ivano.

[Former Member · Accepted solution]

hi ivanov,

thanx alot for your explanation,

can you explain how item 20 and 30 are partially billed. please explain as i am new to this SD modul.

thanx,

praven

[ivano_raimondi · Accepted solution]

Hi Praven,

in delivery creation, in the overview screen of the delivery you can change the quantity.

In billing creation the quantity can be changed as explained in SAP KBA 1585194.

Best regards,

Ivano.

[Former Member · Accepted solution]

hi ivano,

thanx alot,

can you explain what is the use of the fields in the

vbap-kwmeng.

vbfa-rfmng.

Is both refers to same ? then why the value is same in both the tables.

tnx,

praveen

[ivano_raimondi · Accepted solution]

Hi Praveen,

why do you say the value is the same ?

In the example above item 20 has VBAP-KWMENG = 2, that is the quantity in sales order item, whilst VBFA record has RFMNG = 1.

VBFA-RFMNG specifies how much of an item quantity has already been processed in a

subsequent document.

Please check the F1 help of these fields.

Best regards,

Ivano.

[Former Member · Accepted solution]

hi ivano,

thanx for the rply,

i need one more information , In which table invoice information is present.and i want to know the cancelled invoics data in that tables is it possible to get that dtails.

tnx,

praveen,

[ivano_raimondi · Accepted solution]

Hi Praveen,

instead of check if a specific invoice is cancelled, you could simply count the number of invoice and invoice cancellations directly in VBFA.

You can get that info by the field VBTYP_N in table VBFA, as it specify the kind of billing type.

Example 'M' is an invoice, 'N' is a cancellation.

Best regards,

Ivano.

[Former Member · Accepted solution]

hi ivano,

then we can get that no. of cancelled invoices with the help of VBTYP_N field , and if the value is 'N' , then it is cancelled invoices.

tnx,

praveen.

[suman_sardar2]

Hi,

If you are doing Delivery related billing then after PGI you have not billed this scenario will come.

For that use standard Tcode VF04.

But in this case you only get the Header level info.

So plz try to fetch the data directly from the table VBUK where check the Total gds mvt stat.(WBSTK)=C and doc Category (VBTYP) = J.

And fetch the Item data from VBUP table accordingly.

For further clarification do let me know.

Thanks,

Suman