Invoice details in tables BSEG,BSID

[Former Member]

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.

[Former Member · Accepted solution]

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.

[aramsum]

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

[Former Member]

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.