3 Replies Latest reply: Sep 15, 2009 11:57 AM by A Ram Pedarla RSS

Invoice details in tables BSEG,BSID

maddy sap
Currently Being Moderated

Hi Experts,

 

1.How to get the details of open invoice(customer invoice) from table BSEG, BSID or BKPF.

2.Which field in these table belongs to invoice number?

3.Will accounting document gete generated for every invoice created & cancelled?

 

I dont want the details from VBRK or VBRP...

 

Thanks in adv,points for sure.

 

Regards,

Ponraj.s.

  • Re: Invoice details in tables BSEG,BSID
    Mohan Phani Krishna Bobba
    Currently Being Moderated

    Hi,

     

    You can get all the invoices which are open from "BSID" table.

     

    Here open means all the documents which are not posted/CLeared.

     

    All cleared can be viewed in "BSAD" table.

     

    "XBLNR/VBELN" refers to the invoice number.

     

    "BELNR" refers to the accounting document number.

     

    In general both are same values but may be different also.Control will be done at the FI level.

     

    Yes,Accounting document will be generated for every invoice if all the entries are correctly maintained.If not generated we can release the invoice to accounting by using VF02/VFX3 T.Code.

     

    VFX3 is suggestable which gives you the detailed log why the accounting document is not generated.

     

    So that the necessary action can be taken.In BSEG we can check that accounting document.

     

    Regards,

    Krishna.

  • Re: Invoice details in tables BSEG,BSID
    Bheem Singh Yadav
    Currently Being Moderated

    Hi

     

    1.How to get the details of open invoice(customer invoice) from table BSEG, BSID or BKPF.

    A: Open items BSID table.

     

    2.Which field in these table belongs to invoice number?

    VBELN or XBELNR

     

    3.Will accounting document gete generated for every invoice created & cancelled?

     

    For accounting document, check BSID or BSEG.

  • Re: Invoice details in tables BSEG,BSID
    A Ram Pedarla
    Currently Being Moderated

    Hi,

     

         You can see the Invoice number in "BKPF" Table and the filed is "AWKEY". You can see that invoice in "VBRK" table or VF02 transaction. You will get the accounting document generated for the cancelled Invoices too. In BSEG , There is a field called assignment. You check that to get the Invoice number. Kindly please let me know If you need any more information on this.

     

    Regards

    Ram Pedarla

Actions