cancel
Showing results for 
Search instead for 
Did you mean: 

VA02 billing date

vallamuthu_madheswaran2
Active Contributor
0 Kudos
137

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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,

Answers (2)

Answers (2)

vallamuthu_madheswaran2
Active Contributor
0 Kudos

SOLVED OWN

Former Member
0 Kudos

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

Regards,

Aparna

vallamuthu_madheswaran2
Active Contributor
0 Kudos

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
0 Kudos

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