Skip to Content
avatar image
Former Member

Hi

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2007 at 06:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17, 2007 at 06:13 AM

    Hi ..

    Billing Document Tables VBRK, VBRP.

    Billing Doc Status field : VBRK-RFBSK.

    <b>Reward if Helpful</b>

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17, 2007 at 06:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 06:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded