Invoice details in tables BSEG,BSID

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.



Helpful Answer