Hi

[Former Member]

hi,

I had the list of billing documents. In that some were cancelled . when we cancel the billing document another number is generated. I want to write a program which should have the list of billing documents(It should not consider the cancelled documents)

Thanks

[Former Member]

Hi Rams,

Check the table VBRK for the list of canceled invoices and for the respective invoice which considered for cancellation.

VBRK-FKSTO is the billing document canceled for the billing doucment VBRK-VBELN.

Thanks,

Vinay

[former_member196280]

Try to fetch data from VBRP and VBRK using join conditions.. IN where clause you must use <b>vbrk-fksto NE 'X' </b> "Billing documents

Reward and close the thread if your question is answered.

Regards,

SaiRam

[varma_narayana]

Hi ..

Billing Document Tables VBRK, VBRP.

Billing Doc Status field : VBRK-RFBSK.

<b>Reward if Helpful</b>

[Former Member]

Hi

Join the tables VBRK and VBRP and fetch the data where VBRK-VBTYP <> 'N'.

<b>VBTYP = N</b> means cancelled Invoices

<b>Reward points for useful Answers</b>

Regards

Anji