VA02 billing date

[vallamuthu_madheswaran2]

Hi Friends,

In VA02 , how to identify whether a particular material(item) is invoiced, is there any indicator for this? Kindly tell me in which table the inidicator is stored?

Thanks!!!

vallamuthu

[Former Member · Accepted solution]

Hi,

You can check the billing status in VBUP table.

If the billing document has been created/completed to that corresponding item, then field VBUP-UVFAK = 'C'.

Hope this help.

Cheers,

[vallamuthu_madheswaran2]

SOLVED OWN

[Former Member]

Select that particular item and press F5. You can see document flow.

Regards,

Aparna

[vallamuthu_madheswaran2]

Hi,

i want "partially invoiced/not invoiced" material in va02. in document flow we know the status how to apply the report?

Thanks!!

[Former Member]

Hi,

Read into table VBFA for getting the document flow of Sales Order.

VBELV = SO Number

POSNV = SO item

VBTYP_N = 'M' (Invoice) or 'N' (Cancelled Invoice)

Sum up invoice qty and minus cancelled Invoice, then compare total invoice qty with SO qty.

If total invoice qty less than SO qty, means partially invoiced.

If total invoice qty equal to SO qty, means fully invoiced.

If total invoice qty = 0, means not invoiced yet.

Hope this helps.

Cheers,

Edited by: Ed on Dec 11, 2008 9:11 AM