Billing Document Table & field

[Former Member]

Hi Friends,

I have to Calculate Qty. and Amt. Related to Billing Document .But I also want to Deduct the Qty. and

Amount of Cancelled Invoice as well as Credit Note Cancelled.Is there any table exist in which i have the

Indicator or field type in which i get the total of qty (Less cancelled Invoice Qty.)

Points will be awarded for Useful answer

Regards

Kamal

[abdulazeez12 · Accepted solution]

VBRK is the table for Billing Document Header

and VBRP is for Billing Items..

Pls check if the fields you are searching for exist in these tables

[kumar_dasari07 · Accepted solution]

how can I find open invoices against scheduling agreements what is the logic.

[Former Member]

VBRK is the table for Billing Document Header

and VBRP is for Billing Items..

Pls check if the fields you are searching for exist in these tables from SD side and let me know

[former_member187748]

Hi Nitin,

please see how old this thread is, please do not responds to older threads.

[Former Member]

No, sanjeev this thread is helping to us.,.,., for new comers to scn.,

Thanks,

Phani.

[Former Member]

Hi!

I thing all data can be found in the VBRK and VBRP tables.

VBRK-SFAKN - storno invoice number

VBRP-FKIMG - invoiced quantity

VBRP-NETWR - net price

Regards

Tamá

[Danielrmz88]

thanks!

[Former Member]

hi,

fetch all the invoices with the condition

vbrk-fksto <> SPACE

u will get cancelled invoices,

regards,

muralidhar.

[Former Member]

Hi,

VBRK-FKSTO is the field which stores the cancelled invoice data,

fetch the invoices vbrk-fksto <> SPACE.

regards,

muralidhar.

[Former Member]

check in tables : VBRK

VBRP